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,
![2024Mysql And Redis基础与进阶操作系列（9）作者——LJS[含MySQL存储过程之局部、系统变量、参数传递、流程控制-判断/case具体详步骤；注意点及常见报错问题所对应的解决方法]](https://ucc.alicdn.com/pic/developer-ecology/56pfyutwi4tv4_c53df19098d2427391fe36eeb35f84c8.png?x-oss-process=image/resize,h_160,m_lfit)