Question

MySql报错：You can't specify target table 'table name' for upda

Answer 1

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;

已经测试,尽请使用