MySQL "You can't specify target table 'X' for update in FROM clause" 错误解决方法
"You can't specify target table 'X' for update in FROM clause" 错误的意思,在官方文档有说明就是“你不能修改你从子查询出来的数据”。解决这个方法我们可以用子查询当临时表来解决。
Delete
DELETE ebayitem AS a FROM ebayitem AS a,
(
SELECT itemId, MAX(eb
原创
2013-09-02 22:38:54 ·
1407 阅读 ·
0 评论