mysql - Difference between where and and clause in join sql query -


this question has answer here:

what difference between following 2 sql queries

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

and

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

base on following 2 test result

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

is faster (237 vs 460). far know, standard.

enter image description here

enter image description here


Comments