MySQL8.0新特性~最左前缀匹配原则被打破了
测试 在MySQL8.0.25和mysql5.7.33中创建如下 CREATE TABLE t1 (f1 INT NOT NULL, f2 INT NOT NULL, PRIMARY KEY(f1, f2)); INSERT INTO t1 VALUES(1,1), (1,2), (1,3), (1,4), (1,5),(2,1), (2,2), (2,3), (2,4), (2,5); INSERT INTO t1 SELECT f1, f2 5 FROM t1; INSERT I…
2024-09-21