In this post, we’re going to learn how to use MySQL Update Join query to update a mysql table column with the values from another table column using inner join.
UPDATE [table1_name] AS t1 INNER JOIN [table2_name] AS t2 ON t1.[column1_name] = t2.[column1_name] SET t1.[column2_name] = t2.[column2_name];
Replace all “[ ]” with the values of your table properties.
- [table1_name] – This is the name of the table which you’re going to update which is represented as t1
- [table2_name] – This is the table, from which your’re going to take the values which is represented as t2
- t1.[column1_name] – This is the column which is going to link two tables (t2.[column1_name]) using inner join
- t1.[column2_name] – This is the column which is going to be updated with the values from t2.[column2_name]
UPDATE student_marks AS t1 INNER JOIN student_profile AS t2 ON t1.student_id = t2.student_id SET t1.student_name = t2.student_name;
If you want to add a where clause with this query.
UPDATE student_marks AS t1 INNER JOIN student_profile AS t2 ON t1.student_id = t2.student_id SET t1.student_name = t2.student_name WHERE t1.student_id <= 100;
I hope this helps you to use MySQL update join query. Share this post and comment your doubts below if you have any.