重置自增

ALTER TABLE `table_name` DROP `id`;

ALTER TABLE `table_name` ADD `id` BIGINT(20) PRIMARY KEY NOT NULL AUTO_INCREMENT FIRST;

posted @ 2020-11-15 19:20  applekingghfhfhbr  阅读(110)  评论(0编辑  收藏  举报