MySql SELECT语句执行顺序
SELECT语句 - 执行顺序:
①FROM
②ON
③JOIN<join, left join, right join...>
④WHERE
⑤GROUP BY
⑥HAVING
⑦SELECT
⑧DISTINCT
⑨ORDER BY
⑩LIMIT
SELECT语句 - 执行顺序:
①FROM
②ON
③JOIN<join, left join, right join...>
④WHERE
⑤GROUP BY
⑥HAVING
⑦SELECT
⑧DISTINCT
⑨ORDER BY
⑩LIMIT