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 2429 days ago, the information mentioned may be changed or developed.
 |
heaton_nobuMar 19, 2020
1
1. NOT EXISTS
2. LEFT JOIN |
 |
ganbuliaoMar 19, 2020
2
子查询当然慢了 和 not in 无关
|
 |
hammer86Mar 19, 2020 via iPhone
3
not in 不走索引 所以慢
|
 |
4
|
1 |
shangfabaoMar 19, 2020
5
left join * b
where b.* is null |
 |
alyaMar 19, 2020
6
left semi join
|
 |
25OHd2qObJmJ6P10Mar 19, 2020
7
IS NOT NULL 和 NOT IN 都不走索引，能不慢么，楼上都对
|
Select Language