删除数据后,id不连续的问题 set @id = 0; UPDATE test set id = (@id := @id +1); ALTER TABLE test AUTO_INCREMENT = 1; 转自 https://blog.csdn.net/TC0221/article/details/129424845