更新（嵌套子查询）

错误

UPDATE siteinfo set ORG_ID =CONCAT('0',ORG_ID) WHERE ORG_ID in (select ORG_ID from siteinfo whereLENGTH(ORG_ID)=6)

 报错

[Err] 1093 - You can't specify target table 'siteinfo' for update in FROM clause

正确

UPDATE siteinfo a INNER JOIN siteinfo bon  LENGTH(b.ORG_ID)=6 and a.biz_id =b.biz_id set a.ORG_ID = CONCAT('0',a.ORG_ID)