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;