gpt4 book ai didi

mysql - join sql查询中where和and子句的区别

转载 作者:行者123 更新时间:2023-11-30 23:04:56 25 4
gpt4 key购买 nike

<分区>

下面两个SQL查询有什么区别

select a.id, a.name, a.country 
from table a
left join table b on a.id = b.id
where a.name is not null

select a.id, a.name, a.country 
from table a
left join table b on a.id = b.id and a.name is not null

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com