File "migration_V3.txt"

Full Path: /home/analogde/www/Massage_debug_15_11_2017/migration_V3.txt
File size: 677 bytes
MIME-type: text/plain
Charset: utf-8

Add a column to an existing MySQL table

Posted February 8, 2004 by Quinn McHenry in MySQL	

MySQL tables are easy to extend with additional columns.


To add a column called email to the contacts table created in Create a basic MySQL table with a datatype of VARCHAR(80), 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;