mysql为字段添加或删除自增属性

删除自增属性:

ALTER TABLE `members` CHANGE uid uid INT(10) UNSIGNED NOT NULL ;

添加自增属性:

ALTER TABLE `members` CHANGE uid uid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;

posted on 2018-01-16 08:03  dongruiha  阅读(11444)  评论(0编辑  收藏  举报

导航