MySQL - SQL To Add a Column to a Table

Published on October 03, 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);

MySQL - SQL To Add a Column to a Table was first published on October 03, 2006.