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;

原文地址:https://www.cnblogs.com/dongruiha/p/8294777.html