Update one column from value of another column from another table in MySQL

05JunJune 5, 2020

Update one column from value of another column from another table in MySQL

By UNITRAi Web Web 0 Comments

This can be achieved using a single query with join. We can use the query like this:

UPDATE table2
INNER JOIN table1 ON table2.id = table1.id
SET table2.column_to_update = table1.column_from_update
WHERE table1.column_from_update != "";

Note:

We want to update table2.column_to_update
We will update table2.column_to_update from the value of table1.column_from_update
table2.id and table1.id is common column in both of the tables.
We will update only where table1.column_from_update have some value ( not empty )

Author

Leave a ReplyCancel reply