[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