mysql报错：You can‘t specify target table for update in FROM clause解决办法

运行

delete from t_files where id in (select id from t_files where find_in_set(id, getChildLst(1)));

报错：You can't specify target table for update in FROM clause。

 其含义:不能在同一表中查询的数据作为同一表的更新数据。

那么新建一个虚表

delete from t_files where id in 
(select id from (select id from t_files where find_in_set(id, getChildLst(1)));

报错：Every derived table must have its own alias

其含义： 每一个派生出来的表都必须有一个自己的别名，

那我给派生表加上别名

delete from t_files where id in 
(select id from (select id from t_files where find_in_set(id, getChildLst(1)) ) as a);

那么便可以了