EN
MySql - update table values using another table rows
5 points
In this short article, we would like to show how to update some table values using source table rows in MySQL.
Quick solution:
xxxxxxxxxx1
UPDATE updated_table u2
SET updated_column=(3
SELECT source_column4
FROM source_table s5
WHERE u.some_column=s.some_column6
);Note: be sure that
WHERE u.some_column=s.some_columncauses returning one row for the updated column.