mysql [ERR]1093 - you can't specify target table xx for update in from clause

update games set nation_code = '36' where id in (select id from games);

结果报1093错误：以前在oracle上面是正确的。

后来查百度：说在mysql中这样的语法是错误的，相当于在视图中修改数据,不被允许。

正确写法：

update games set nation_code = '36' where id in (select a.id from (select id from games) a);