select * from a inner join b on a.id = b.aid和select * from a,b where a.id = b.aid效果一样吗?如果一样的话,用哪一个效果更好?为什么?
select * from a inner join b on a.id = b.aid
select * from a,b where a.id = b.aid
小伙看你根骨奇佳,潜力无限,来学PHP伐。
select * from a inner join b on a.id = b.id This is an inner joinselect * from a, b where a.id=b.id This is an equijoin
The effect of inner join and equivalent join is the same, and the execution efficiency is the same
select * from a inner join b on a.id = b.id This is an inner join
select * from a, b where a.id=b.id This is an equijoin
The effect of inner join and equivalent join is the same, and the execution efficiency is the same