mysql 查询优化 in 和 not in
select title.id,title.`name` from title where title.id not in (select user_tag.tagid from user_tag )可以改为select title.id,title.`name`from title left join user_tag on user_tag.tagid = title.id ...
原创
2018-03-29 14:52:57 ·
2031 阅读 ·
0 评论