mysql使用EXISTS代替join

SELECT a.id FROM a WHERE a.id = 5100359  AND EXISTS ( SELECT b.id FROM b WHERE a.id = b.id) ORDER BY a.id DESC LIMIT 0, 5

posted @ 2018-03-22 15:53  jintaonote  阅读(428)  评论(0)    收藏  举报