开发者

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

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜