MySQL 修改报错 You can't specify target table 'tb_trade' for update in FROM clause

修改前

 

delete from tb_order where tradeId in (


select o.tradeId from tb_order o INNER JOIN tb_trade t where o.tradeId=t.id and receiverState='台湾'


)

修改后

delete from tb_order where tradeId in (

select o.tradeId from(


select o.tradeId from tb_order o INNER JOIN tb_trade t where o.tradeId=t.id and receiverState='台湾'
)o

)

MySQL不能查询后直接update该数据表，可以先将查询结果再select保存后再查询