mysql左连接中on and和on where的区别

1. on and是进行韦恩运算时 连接时就做的动作
   select * from a left join b on a.sid=b.sid and a.sid=1; 等价于：
   select * from a left join b on (a.sid=b.sid and a.sid=1);

2. where是全部连接完后，再根据条件过滤
   select * from a left join b on a.sid=b.sid where a.sid=1;

3. 在使用inner join时，不管是对左表还是右表进行筛选，on and和on where都会对生成的临时表进行过滤，二者等价
   select * from a inner join b on a.sid=b.sid and a.sid=1;
   select * from a inner join b on a.sid=b.sid where a.sid=1;