[turba] Changes in table to all lower (???)

m.ibarra@cdcixis-na.com m.ibarra@cdcixis-na.com
Mon, 15 Apr 2002 13:12:03 -0400


Thanks, and forgive me :-)

-mike

-----Original Message-----
From: Chuck Hagenbuch [mailto:chuck@horde.org]
Sent: Monday, April 15, 2002 12:21 PM
To: turba@lists.horde.org
Subject: RE: [turba] Changes in table to all lower (???)


Quoting m.ibarra@cdcixis-na.com:

> OK, sorry for this off topic question, but how do I
> change the name of a column within a table in mysql?
> as well as add a column within a table (for the pgp
> addon).

ALTER TABLE tablename CHANGE COLUMN old_fieldname new_fieldname field_type 
    options

and

ALTER TABLE tablename ADD COLUMN fieldname field_type options

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
"A dream which helps you to live your reality with dignity
 and justice is a good dream." - Tariq Ramadan
-
Turba mailing list
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: turba-unsubscribe@lists.horde.org