MySql报错: You can＇t specify target table ＇table name
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,
