MySQL :: MySQL 5.0 Reference Manual :: 13.2.10 UPDATE Syntax

For the multiple-table syntax, UPDATE updates rows in each table named in table_references that satisfy the conditions. Each matching row is updated once,  ...

www.google.com.tw