search

Home  >  Q&A  >  body text

mysql - sql中两个语句的区别

select * from a inner join b on a.id = b.aidselect * from a,b where a.id = b.aid效果一样吗?如果一样的话,用哪一个效果更好?为什么?

伊谢尔伦伊谢尔伦2897 days ago801

reply all(1)I'll reply

  • PHP中文网

    PHP中文网2017-04-17 14:46:34

    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

    reply
    0
  • Cancelreply