Surf 11 » MySQL - SQL To Add a Column to a Table

Finding the best waves on the web.

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

Related Entries

Email: (optional, not displayed on site)
   Subscribe to this thread
Comments: (html will be escaped)

Subscribe to our RSS Feed: subscribe to this feed XML
Archives   Tags   Contact