删除重复记录

 delete  from ResourceMedia where movieid not in ( select min(movieid)  from ResourceMedia group by mediaID, volumeid  )

 

在mysql中不能用

 

mysql中不能这么用。 （等待mysql升级吧） 

错误提示就是说，不能先select出同一表中的某些值，再update这个表(在同一语句中)   

替换方案：  create table tmp as select min(id) as col1 from blur_article group by title; delete from blur_article where id not in (select col1 from tmp);  drop table tmp;