• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Posted By

tclancy on 05/01/09

Tagged

Versions (?)

05/01/09 05:17pm

Who likes this?

2 people have marked this snippet as a favorite

vali29
mgerdt

 / Published in: MySQL

 

URL: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

ALTER TABLE pages_htmlpage ADD sidebar_image VARCHAR(100) NULL;

Report this snippet   Tweet

Comments

Subscribe to comments

Posted By: tclancy on September 28, 2009

To provide a default value,

ALTER TABLE profilesyacht ADD sortorder INT DEFAULT '1';