MySQL Inner Join – Update Values From Another Table_MySQL

文章目录[隐藏]

Introduction

In this post, we’re going to lear

本文来源gaodai^.ma#com搞#代!码网

n how to update amysql tablecolumn with the values from another table column usinginner 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;

I hope this helps you. Share this post and comment your doubts below if you have any.

搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]‍，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：MySQL Inner Join – Update Values From Another Table_MySQL