因为null的原因,导致出现子查询的结果为空 正确的写法应排除NULL值 delete from test where id NOT in (SELECT id FROM test where id is not null);