2021
08-08
08-08
MySQL索引失效的典型案例
目录典型案例附:常见索引失效的情况典型案例有两张表,表结构如下:CREATE TABLE `student_info` ( `id` int(11) NOT NULL, `name` varchar(10) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_name` (`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4CREATE TABLE `student_score` ...
继续阅读 >