alter table TABLENAME add COLUMN_NAME etc, etc...
ie:
alter table members add firstname varchar(50) not null;
If you want to put it after a specific column you can do the following:
alter table members add firstname varchar(50) not null after lastname;
-- Jason
On 7/18/01 10:32 AM, Paul C
mysql> alter table mytable add newcolumn varchar(16);
Have a look at the ALTER TABLE syntax in the manual...
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
On Wed, 18 Jul 2001, Paul Castiglione wrote:
> Hello
>
> Is there a way to add addition feilds to a table after it been created.
>
>
Hello
Is there a way to add addition feilds to a table after it been created.
Thank in Advance
Paul
