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:
UPDATE updated_table u
SET updated_column=(
SELECT source_column
FROM source_table s
WHERE u.some_column=s.some_column
);Note: be sure that
WHERE u.some_column=s.some_columncauses returning one row for the updated column.