mysql出错：You can't specify target table 'App' for update in FROM clause

Question

执行 update App set App.packageName_id=(select id from PackageName,App where App.packageName=PackageName.packageName);
出错：ERROR 1093 (HY000): You can't specify target table 'App' for update in FROM clause
求优化？

Answer 1

[code="java"]UPDATE App,PackageName SET App.packageName_id=PackageName.id where
WHERE App.packageName=PackageName.packageName;[/code]