使用alter 直接进行序号指派
在使用ALTER命令
mysql> ALTER TABLE account AUTO_INCREMENT=2;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
(116条消息) MySQL删除某列后编号不连续——重置Mysql自增列的开始序号_鹏哥儿HZU的博客-CSDN博客 https://blog.csdn.net/Cap220590/article/details/107089417?spm=1001.2101.3001.6650.2&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-2-107089417-blog-52435226.pc_relevant_default&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-2-107089417-blog-52435226.pc_relevant_default&utm_relevant_index=4