EXPLAIN
EXTENDED
select s.* from student s
where s.sid in (
select sid
from sc
where sc.cid = 0 and sc.score = 100);
show WARNINGS;
查看mysql sql执行器优化后的sql
2023-12-29 17:30:06 32 阅读
EXPLAIN
EXTENDED
select s.* from student s
where s.sid in (
select sid
from sc
where sc.cid = 0 and sc.score = 100);
show WARNINGS;