DELETE FROM a WHERE a.mobile NOT IN ( SELECT DISTINCT mobile FROM b WHERE mobile IS NOT NULL )
比如这样的一条 sql 逻辑 ，not in
数据量很大 删了好久
• 请不要在回答技术问题时复制粘贴 AI 生成的内容
This topic created in 2254 days ago, the information mentioned may be changed or developed.
 |
1
heaton_nobu Mar 19, 2020
1. NOT EXISTS
2. LEFT JOIN |
 |
2
ganbuliao Mar 19, 2020
子查询当然慢了 和 not in 无关
|
 |
3
hammer86 Mar 19, 2020 via iPhone
not in 不走索引 所以慢
|
 |
4
sagaxu Mar 19, 2020 via Android  1
|
 |
5
shangfabao Mar 19, 2020
left join * b
where b.* is null |
 |
6
alya Mar 19, 2020
left semi join
|
 |
7
25OHd2qObJmJ6P10 Mar 19, 2020
IS NOT NULL 和 NOT IN 都不走索引，能不慢么，楼上都对
|
Select Language