huangxingjie的博客

IN语句： SELECT * FROM order WHERE status IN (1,2,3) EXISTS语句转换： SELECT * FROM order a WHERE EXISTS( SELECT * FROM ( SELECT 1 AS type UNION ALL SELECT 2 AS type UNION ALL SELECT 3 AS type ) b WHERE b.type=a.type ) 该代码用到了临时结果集的概念 ...