Thursday, June 21, 2012

MYSQL: Add a column to an existing MySQL table


MySQL tables are easy to extend with additional columns.

Use the following SQL statement:
ALTER TABLE contacts ADD email VARCHAR(60);

This first statement will add the email column to the end of the table. To insert the new column after a specific column, such as name, use this statement:

ALTER TABLE contacts ADD email VARCHAR(60) AFTER name;

If you want the new column to be first, use this statement:
ALTER TABLE contacts ADD email VARCHAR(60) FIRST;



..

0 comments:

Post a Comment