《MysqL应用MysqL 子查询与join性能对比》要点：
本文介绍了MysqL应用MysqL 子查询与join性能对比，希望对您有用。如果有疑问，可以联系我们。
有如下的数据表：
application_daily 11万条数据
application_info400多条数据
查询成果数据为19498MysqL学习
select sql_no_cache * from application_daily where application_info_id in
(select id from application_info where Team_TeamID=3)
(select id from application_info where Team_TeamID=3)
select sql_no_cache * from application_daily where application_info_id in
(161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190)
(161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190)
例3,衔接查询,两条语句等价(0.001s)
MysqL学习
select sql_no_cache * from application_daily,application_info where
Team_TeamID=3 and application_daily.application_info_id=application_info.idMysqL学习
select sql_no_cache * from application_daily inner join application_info on
(application_daily.application_info_id=application_info.id) where Team_TeamID=3MysqL学习
《MysqL应用MysqL 子查询与join性能对比》是否对您有启发，欢迎查看更多与《MysqL应用MysqL 子查询与join性能对比》相关教程，学精学透。编程之家PHP学院为您提供精彩教程。