MySQLInnerJoin–UpdateValuesFromAnotherTable_MySQL

来源：懂视网责编：小采时间：2020-11-09 20:01:15

MySQLInnerJoin–UpdateValuesFromAnotherTable_MySQL

MySQLInnerJoin–UpdateValuesFromAnotherTable_MySQL:IntroductionIn this post, were going to learn how to update amysql tablecolumn with the values from another table column usinginner join.Query SyntaxUPDATE [table1_name] AS t1 IN

推荐度：

点击下载本文 文档为doc格式

导读MySQLInnerJoin–UpdateValuesFromAnotherTable_MySQL:IntroductionIn this post, were going to learn how to update amysql tablecolumn with the values from another table column usinginner join.Query SyntaxUPDATE [table1_name] AS t1 IN

Introduction

In this post, we’re going to learn how to update amysql tablecolumn with the values from another table column usinginner join.

Query Syntax

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];

Properties

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]

Example

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.

声明：本网页内容旨在传播知识，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

MySQLInnerJoin–UpdateValuesFromAnotherTable_MySQL

推荐度：

点击下载本文 文档为doc格式

标签： update mysql table

热门焦点

MySQLInnerJoin–UpdateValuesFromAnotherTable_MySQL

MySQLInnerJoin–UpdateValuesFromAnotherTable_MySQL

Introduction

Query Syntax

Properties

Example

MySQLInnerJoin–UpdateValuesFromAnotherTable_MySQL

最新推荐

猜你喜欢

热门推荐