自增锁ID复用问题
mysql> select * from pp; +----+------+ | id | name | +----+------+ | 1 | xx | | 2 | xx | | 3 | xx | | 4 | xx | | 5 | xx | | 6 | xx | | 7 | xx | | 8 | xx | | 9 | xx | | 10 | xx | | 13 | xx | | 14 | xx | | 15 | xx | | 16 | xx | | 17 | xx | | 18 | xx | | 19 | xx | | 20 | xx | | 21 | xx | | 22 | xx | | 23 | xx | | 24 | xx | +----+------+ 22 rows in set (0.00 sec) mysql> delete from pp where id=24; Query OK, 1 row affected (0.11 sec) mysql> show create table pp; CREATE TABLE `pp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=gbk
重起MYSQL 服务器
mysql> show create table pp; | pp | CREATE TABLE `pp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=gbk |