转自:http://www.2cto.com/database/201308/236323.html
MySQL更新时Error Code:1093和Error Code:1175的解决办法 MySQLSQLError Code: 1093. You can't specify target table 'ws_product' for update in FROM clause这个是我们在使用update或者delete语句时,在where条件里面加入的子查询导致的。例如如下的update语句:
update table set type = 'static' where id in (
select id from ws_product where first_name ='superman'
);
update ws_product set type = 'static' where id in (
select id form (
select id from ws_product where first_name ='superman'
) xx
);