学习笔记（4):MySQL数据库从入门到实战课-查询分析器EXPLAIN

立即学习:https://edu.csdn.net/course/play/27328/362531?utm_source=blogtoedu

use mydb;

show tables;

select * from employee;

select * from employee where name = '柳峰';

select * from employee where id = 13;

explain select * from employee where name = '柳峰';

explain select * from employee where name = '柳峰'\G;

explain select * from employee where id = 13\G;

select * from test_user where username = 'user_0008888';

explain select * from test_user where username = 'user_0008888'\G;