MySQL :: MySQL 5.5 Reference Manual :: 13.2.11 UPDATE Syntax

MySQL :: MySQL 5.5 Reference Manual :: 13.2.11 UPDATE Syntax

瀏覽:1228
日期:2024-09-08
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 ......看更多