一次奇怪的 mysql update，按条件批量更新数据

update app set broker = '{"act":80,"reg":100}' where id in(select id from app where broker = '{"act":100,"reg":120}');

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

改造下，加一层临时表：

update app set broker = '{"act":80,"reg":100}' where id in(select id from app where broker = '{"act":100,"reg":120}') tmp);

又可以执行成功，奇怪的mysql