MySQL新增字段并设置默认值

参考(AFTER表示在某列之后新增列,可以不要):

ALTER TABLE `admintype` ADD tags VARCHAR(255) NOT NULL DEFAULT '' AFTER typename

 

Was this helpful?

0 / 0

发表评论 0

Your email address will not be published. Required fields are marked *