是时候检查一下使用索引的姿势是否正确了！
复制CREATETABLE `user2` (
`id` int(11) unsigned NOTNULL AUTO_INCREMENT,
`username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULTNULL,
`address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULTNULL,
`gender` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULTNULL,
PRIMARYKEY (`id`),
KEY `username` (`username`,`address`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1.2.3.4.5.6.7.8.
阅读剩余
THE END
