给各位老大拜年里,祝新春快乐!
mysql无主键表添加主键后TABLE_ID发生变化,请问是什么原理?
版本mysql> select version();
±----------+
| version() |
±----------+
| 8.0.29 |
±----------+
1 row in set (0.00 sec)
use test;
create table test(id int,iq int);
test表没有主键,id是1206
select TABLE_ID,name from information_schema.INNODB_tables where name='test/test';
+----------+-----------+
| TABLE_ID | name |
+----------+-----------+
| 1206 | test/test | 《-------id是1206
+----------+-----------+
1 row in set (0.00 sec)
mysql> alter table test add primary key(id);
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
添加主键后id变为
mysql> select TABLE_ID,name from information_schema.INNODB_tables where name='test/test';
+----------+-----------+
| TABLE_ID | name |
+----------+-----------+
| 1207 | test/test |
+----------+-----------+
1 row in set (0.00 sec)