Pete Freitag Pete Freitag

MySQL - SQL To Add a Column to a Table


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);

Like this? Follow me ↯

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

Post a Comment