mysql中not in，in，exists，not exists原理和区别

区别:

in:

where id in(x1,x2)等同于where id=x1 or id=x2

not in:

where id not in(x1,x2)等同于where id!=x1 and id!=x2

exists:

where exists(select ......);select 子查询有结果则“exists(select ......)”返回true,否则返回false,等同于where true(false)

not exists:

where not exists(select ......);select 子查询有结果则“not exists(select ......)”返回false,否则返回true,等同于where false(true)