mysql - sql中的in与not in,exists与not exists的区别？为什么not in 没有用到索引？

Answer 1

You can read this blog post to briefly talk about the difference between in and not in, exists and not exists in sql