SELECT 语句模式

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

SELECT
    field1,
    field2,
    ...
FROM table1 a
JOIN table2 b on 1=1
    AND join_condition1
    AND join_condition2
..
WHERE 1=1
AND filter_condition1
AND filter_condition1
AND (1=2
    or filter_condition_sub1
    or filter_condition_sub2
    )