Page 1 of 1

adding another field to a table

Posted: Tue Mar 15, 2005 12:44 pm
by psychotomus
how do I add another field to a table?

Posted: Tue Mar 15, 2005 12:48 pm
by feyd
huh? Do you mean add a field to a table in a database?

http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html

Posted: Tue Mar 15, 2005 12:49 pm
by John Cartwright
in mysql

Code: Select all

ALTER TABLE `tablename` ADD `column` TEXT NOT NULL ;
TEXT being the column type..