带子查询的 MySql 更新语句

Question

请看一下我在 MySql Workbench 中写的这条语句:

update customer set flag = 1
where id in (select id from customer
group by phoneNumber
having count(phoneNumber) > 1);

显示以下消息:

Error Code: 1093. You can't specify target table 'customer' for update in FROM clause

我做错了什么？

Answer 1

尝试一下:

  update customer set flag = 1
  where id in (select * from (select id from customer
  group by phoneNumber
  having count(phoneNumber) > 1)t ) ;