How can i assign value when creating a column of a mysql table?
alter table tablename add column mark tinyint NOT NULL;
I want to assign 1 as a default value of 开发者_高级运维that mark column .
How can i do this ?
alter table tablename add column mark tinyint default 1 NOT NULL;
精彩评论