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 2245 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