Shulou(Shulou.com)06/01 Report--

This article mainly introduces what is the execution order of sql and mysql, which can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

The internal mechanism of sql and mysql is the same, and the biggest difference lies in aliases.

Mysql execution order

1 、 from

2 、 on

3 、 join

4 、 where

5. Group by (start using aliases in select, which can be used in subsequent statements)

6 、 avg,sum.

7 、 having

8 、 select

9 、 distinct

10 、 order by

Thank you for reading this article carefully. I hope it is helpful for everyone to share the order of sql and mysql execution. At the same time, I also hope you can support us, pay attention to the industry information channel, and find out if you have any problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.