mysql-1093error

删除数据

delete from abc where id in( select id from abc )

 

 

 

查了下手册

·         错误：1093 SQLSTATE: HY000 (ER_UPDATE_TABLE_USED)

消息：不能在FROM子句中制定要更新的目标表’%s’。

 

修改sql

 

delete from abc where id in(select a.id from (select tmp.* from abc tmp)a)