例如:
update from a表 where id in( select id from a表 where ......)
mysql 会报 [Err] 1093 - You can't specify target table 'tc_cust' for update in FROM clause
MySQL手册UPDATE documentation这下面有说明 : “Currently, you cannot update a table and select from the same table in a subquery.”
解决方法:
1,创建临时表。(挺麻烦的。)
2,在in 字句 中 再用一层select 查询封装a表
update from a表 where id in( select id from (select id from a表 where ......) a1)