mysql You can't specify target table 'mall_goods_tag' for update in FROM clause
[SQL] UPDATE `mall_goods_tag` set goods_category_id = 120 where parent_id in (SELECT id FROM mall_goods_tag where goods_category_id = 121 and parent_id = 0);
[Err] 1093 - You can't specify target table 'mall_goods_tag' for update in FROM clause
You can't specify target table 'XXXXXXX' for update in FROM clause