最新消息: 新版网站上线了!!!

mysql删除重复的数据

执行sql
create table tmp as select min(id) as col1 from fanwe_task group by title;
delete from fanwe_task where id not in (select col1 from tmp); 
drop table tmp;

MySql报错: You can't specify target table 'table name' for update in FROM clause

这样报错也可以有这种 方法

.....

转载请注明:谷谷点程序 » mysql删除重复的数据