Page 1 of 1

Adding fields

Posted: Thu Jun 26, 2008 8:12 pm
by pauls74462
How do you add fields after a table has been created in php?

Re: Adding fields

Posted: Thu Jun 26, 2008 8:33 pm
by John Cartwright

Code: Select all

ALTER TABLE `your_table_name` ADD `your_new_column` FIELDTYPE;
Where you would replace, the table name, the column name, and FIELDTYPE appropriatly.