Posted By

tclancy on 05/01/09


Tagged


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

vali29
mgerdt


MySQL Add Column


 / Published in: MySQL
 

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

  1. ALTER TABLE pages_htmlpage ADD sidebar_image VARCHAR(100) NULL;

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: tclancy on September 28, 2009

To provide a default value,

ALTER TABLE profilesyacht ADD sortorder INT DEFAULT '1';

You need to login to post a comment.