ERROR 1093 (HY000): You can't specify target table 'bm_area' for update in FROM clause

开发执行时出现错误:

update bm_area  set level = 2 where parent_code in (select b.parent_code from bm_area as b where b.level = 1);

ERROR 1093 (HY000): You can‘t specify target table ‘bm_area‘ for update in FROM clause

一般使用：

create table tmp as select b.parent_code from bm_area as b where b.level = 1;

update bm_area  set level = 2 where parent_code in (select parent_code from tmp);

两条合成一条

update bm_area  set level = 2 where parent_code in (select parent_code from (select parent_code from bm_area  where level = 1)tmp);

本文出自 “dba天空” 博客，请务必保留此出处http://9425473.blog.51cto.com/9415473/1676995

ERROR 1093 (HY000): You can't specify target table 'bm_area' for update in FROM clause

原文：http://9425473.blog.51cto.com/9415473/1676995