MYSQL相关设置 [私人]
[ 2008-06-29 00:59:38 | 作者: progame ]
max_allowed_packet=16M
UTF8支持即可正确显示中文
Incorrectly used table in subquery:
Error 1093 (ER_UPDATE_TABLE_USED)
SQLSTATE = HY000
Message = "You can't specify target table 'x'
for update in FROM clause"
This error occurs in cases such as the following:
UPDATE t1 SET column2 = (SELECT MAX(column1) FROM t1);
You can use a subquery for assignment within an UPDATE statement because subqueries are legal in UPDATE and DELETE statements as well as in SELECT statements. However, you cannot use the same table (in this case, table t1) for both the subquery's FROM clause and the update target.
For transactional storage engines, the failure of a subquery causes the entire statement to fail. For non-
评论Feed: /feed.asp?q=comment&id=1751
UTF8支持即可正确显示中文
Incorrectly used table in subquery:
Error 1093 (ER_UPDATE_TABLE_USED)
SQLSTATE = HY000
Message = "You can't specify target table 'x'
for update in FROM clause"
This error occurs in cases such as the following:
UPDATE t1 SET column2 = (SELECT MAX(column1) FROM t1);
You can use a subquery for assignment within an UPDATE statement because subqueries are legal in UPDATE and DELETE statements as well as in SELECT statements. However, you cannot use the same table (in this case, table t1) for both the subquery's FROM clause and the update target.
For transactional storage engines, the failure of a subquery causes the entire statement to fail. For non-
评论Feed: /feed.asp?q=comment&id=1751
标签:
您可能感兴趣的文章:
这篇日志没有评论.
