mysql自增断档,mysql重置自增
- 解决方法
SET @rownum = 0;
UPDATE table_name SET id = @rownum := @rownum +1;
- 再次查看
SELECT COUNT(*) from table_name;
SELECT MAX(id) from table_name;
SET @rownum = 0;
UPDATE table_name SET id = @rownum := @rownum +1;
SELECT COUNT(*) from table_name;
SELECT MAX(id) from table_name;