关于mysql delete的问题

由于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;