作者:小佡人 | 来源:互联网 | 2018-04-16 13:31
由于mysql数据库的相关内部问题
导致delete from table where col not in (select col from table group by xx)
会提示报错
我们要做的是
create table tmp selete col from table group by xx;
delete from table where col not in (select col from tmp);
drop table tmp;