关于mysql的自增id测试，innodb和myisam下的不同表现
发布网友
发布时间：2022-03-27 05:15
共1个回答
热心网友
时间：2022-03-27 06:44
mysql> update innodb_test set id=105 where id=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from innodb_test;
+-----+
| id |
+-----+
| 2 |
| 3 |
| 100 |
| 105 |
+-----+
4 rows in set (0.00 sec)
mysql> show create table innodb_test\G
1. row
Table: innodb_test
Create Table: CREATE TABLE `innodb_test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
