The subquery opens and closes the table before the outer UPDATE opens the table, so the query will now succeed: mysql> UPDATE tbl -> INNER JOIN( —> SELECT ...
確定! 回上一頁