MySQL :: MySQL 5.0 Reference Manual :: 13.2.10 UPDATE Syntax
Update column in a table whose values are not found in another table. UPDATE TABLE_1 LEFT JOIN TABLE_2 ON TABLE_1.COLUMN_1= TABLE_2.COLUMN_2 SET TABLE_1.COLUMN = EXPR WHERE TABLE_2.COLUMN2 IS NULL An outerjoin is performed ......
網址安全性掃描由 
提供
