SQL执行顺序及常用join查询

最新推荐文章于 2023-06-14 15:40:18 发布

流火如夏xx

最新推荐文章于 2023-06-14 15:40:18 发布

阅读量385

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/m0_37873390/article/details/113995765

版权

MySQL 专栏收录该内容

12 篇文章 1 订阅

订阅专栏

1. SQL执行顺序

手写：

select distinct 
    <select_list>
from 
    <left_table> <join_type>
join <right_table> on <join_conditions>
where 
    <where_condition>
group by
    <group_by_list>
having
    <having_conditions>
order by
    <order_by_conditions>
limit <limit_number>

机读：

union后的select先执行

select a from t1 union select b from t2;

先执行select b from t2;

from <left_table> 
on <join_conditions>
<join_type> join <right_table> 
where <where_condition>
group by <group_by_list>
having <having_conditions>
select 
distinct <select_list>
order by <order_by_conditions>
limit <limit_number>

2. join图