select * from a as a where a.id in (1,2,3,...,100)效率如何select * from a as a where a.id in (1,2,3,...,100)效率如何in里面的东西是没有规律的是从另一个表按条件select出来的是单这么写效率好,还是select * from a as a inner join b as b on b.xx=xx and a.xx=b.xx效率好[解决办法]少了好多解析的时间[解决办法]
