Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
Massage_debug_15_11_2017
:
migration_V3.txt
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
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;