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

Chuck Hagenbuch chuck@horde.org
Mon, 15 Apr 2002 12:21:08 -0400


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