在用到mysql update in的时候报错 update area set status=’ON’ where id in(select id from area where status=’ON’ and name like ‘%市辖%’) [SQL]update area set status=’ON’ where id in(select id from area where status=’ON’ and name like ‘%市辖%’
在用到mysql update in的时候报错
update area set status=’ON’ where id in(select id from area where status=’ON’ and name like ‘%市辖%’)
[SQL]update area set status=’ON’ where id in(select id from area where status=’ON’ and name like ‘%市辖%’)
[Err] 1093 – You can’t specify target table ‘area’ for update in FROM clause
下面语句可以通过
update area a inner join(select id from area where id in(select id from area where status='ON' and name like '%市辖%')) b on a.id=b.id set a.status='OFF'select * from area a inner join(select id from area where id in(select id from area where status='ON' and name like '%市辖%')) b on a.id<i style="color:transparent">本文来源gaodai$ma#com搞$代*码6网</i>=b.id
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：mysql update in 报错解决
转载请注明原文链接：mysql update in 报错解决
