MySQL :: MySQL 5.1 Reference Manual :: 13.2.10 UPDATE Syntax

MySQL :: MySQL 5.1 Reference Manual :: 13.2.10 UPDATE Syntax

瀏覽:816
日期:2025-04-25
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 ......看更多