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

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

错误写法

#update base_extend set remark='aa' where id in (select id from base_extend where base_id=224515) limit 1;

正确写法

update base_extend  b set b.remark='aa' 

where b.id in (select t.id from (select tmp.* from base_extend tmp) t  where t.base_id=224515) limit 1;