关于mysqldelete的问题_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;