MySQL You can‘t specify target table ‘x_customer‘ for update in FROM clause

问题

先查出A表的字段然后在对A表中的字段进行更改会报错

update A
    set area_id = (select id from B where name like '%xxx%')         
    where id in 
    (select id from A where address_detail like '%xxx%'); 

You can't specify target table 'x_customer' for update in FROM clause

无法在FROM子句中为更新指定目标表“x_customer”

解决

用随便一个中间表过度一下

update A
    set area_id = (select id from B where name like '%xxx%')         
    where id in 
    (select id from
        (select id from A where address_detail like '%xxx%')
    B ); 

我这里是用B给他包了一下，用什么都可以！！！

希望能够帮到大家！！！