MySQL 中 You can't specify target table '表名' for update in FROM clause 解决办法
删除的A表,条件为A表的子查询,报错解决
-- 错误的写法
DELETE
FROM
usr
WHERE
id IN ( SELECT id FROM usr WHERE name= '-' )
-- 修改后正确的写法
DELETE
FROM
usr b
WHERE
b.id IN ( SELECT a.id FROM ( SELECT id FROM usr WHERE name= '-' ) a )