Detailed explanation of the writing order and execution order of Mysql series SQL query statements

1. The writing order of a complete SQL query statement

-- "mysql statement writing order"
1 select distinct *
2 from table (or result set)
3 where …
4 group by …having…
5 order by …
6 limit start,count
-- Note: 1 and 2 are the most basic statements and must be included.
-- Note: 1 and 2 can be matched with any one of 3, 4, 5, and 6, or with more than one of 3, 4, 5, and 6 at the same time.

2. A complete SQL statement execution order

The explanation of the above picture is as follows:

3. Explanation on the execution order of select and having

If anyone has a convincing argument, please leave a message to let me know, thank you.

The above is the detailed content of the detailed explanation of the writing order and execution order of the Mysql series SQL query statements. For more information about the writing order and execution order of SQL query statements, please pay attention to other related articles on 123WORDPRESS.COM!