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 Castiglione was heard saying:
> Hello
>
> Is there a way to add addition feilds to a table after it been created.
>
> Thank in Advance
> Paul
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
