This is an old revision of the document!

MySQL - Add a column to an existing table

ALTER TABLE table_name ADD new_column INT NOT NULL;
ALTER TABLE table_name ADD new_column VARCHAR(50) AFTER existing_column;
ALTER TABLE table_name ADD new_column VARCHAR(50) FIRST;