MySQL - SQL To Add a Column to a Table

October 3, 2006 by Pete Freitag

Here's a simple SQL statement to add a varchar column of size 100 to a table:

ALTER TABLE tablename ADD COLUMN columnName varchar(100);