EXPLAIN SELECT * FROM `tcb_capital_log` WHERE id IN(66,79,47)EXPLAIN SELECT * FROM ( SELECT 66 AS id UNION ALL SELECT 79 AS id UNION ALL SELECT 47 AS id) AS tmp , tcb_capital_log WHEREtcb_capital_log.id = tmp.id
本文共 263 字,大约阅读时间需要 1 分钟。
EXPLAIN SELECT * FROM `tcb_capital_log` WHERE id IN(66,79,47)EXPLAIN SELECT * FROM ( SELECT 66 AS id UNION ALL SELECT 79 AS id UNION ALL SELECT 47 AS id) AS tmp , tcb_capital_log WHEREtcb_capital_log.id = tmp.id
转载于:https://www.cnblogs.com/adtuu/p/6365768.html