3.mysql自增的字段如何重新派逊

alter table sales drop id;
ALter table sales add id int(6) PRIMARY key not null auto_increment FIRST;

原文地址:https://www.cnblogs.com/caimuqing/p/9002630.html