[PHP-DB] Add column to a table
Hi, Please could someone tell me what the syntax is to add a column to a table? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Add column to a table
For mysql: Alter table tablename add column column-name columntype; Regards, Marcel -Original Message- From: Shaun Thornburgh [mailto:shaun;mania.plus.com] Sent: 31 October 2002 13:39 To: [EMAIL PROTECTED] Subject: [PHP-DB] Add column to a table Hi, Please could someone tell me what the syntax is to add a column to a table? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- If you have received this e-mail in error or wish to read our e-mail disclaimer statement and monitoring policy, please refer to http://www.drkw.com/disc/email/ or contact the sender. -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Add column to a table
ALTER TABLE TableName ADD COLUMN columnParametersHere E.g: ALTER TABLE UserTable ADD COLUMN userName varchar(255); Aaron -Original Message- From: Shaun Thornburgh [mailto:shaun;mania.plus.com] Sent: Thursday, October 31, 2002 7:39 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Add column to a table Hi, Please could someone tell me what the syntax is to add a column to a table? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php