立即学习:https://edu.csdn.net/course/play/27328/362532?utm_source=blogtoedu
use mydb;
show tables;
show index from employee;
show index from employee\G;
explain select * from employee where name = '柳峰';
create index idx_name on employee(name);
explain select * from employee where name = '柳峰';
drop index idx_name on employee;
show index from employee\G;
select * from test_user where username = 'user_0008888';
create index idx_username on test_user(username);
select * from test_user where username = 'user_0008888';
explain select * from test_user where username = 'user_0008888';
explain select * from test_user where username like '%user_0008888%'\G;