万答#13,MySQL自增键用完后,插入数据会发生什么情况
1.实验场景GreatSQL8.0.25InnoDB2.实验测试主键索引添加自增参数测试1.建表测试表CREATETABLEt6(idint(1)NOTNULLAUTOINCREMENT,namevarchar(64),PRIMARYKEY(id))ENGINEInnoDB;2.写入测试数据insertintot6values(1,'chen'),(2147483646,'wu');3.继续写入后,提示主键冲突4.查询数据如下普通索引添加自增参数测试1.建表测试表CREATETABLEt7(idint(1)NOTNULLAUTOINCREMENT,namevarchar(64),KEYidxid(id))ENGINEInnoDB;2.写入测试数...