Update From Another Table MySQL

by

Update From Another Table MySQL

We can update another table with the help of the inner join.

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
UPDATE
TableName1
SET
TableName1.col1 = TableName2.col1,
TableName1.col2 = TableName2.col2
FROM
Some_Table AS TableName1
INNER JOIN Other_Table AS TableName2
ON TableName1.id = TableName2.id
WHERE
TableName1.column3 = 'Yes'
UPDATE TableName1 SET TableName1.col1 = TableName2.col1, TableName1.col2 = TableName2.col2 FROM Some_Table AS TableName1 INNER JOIN Other_Table AS TableName2 ON TableName1.id = TableName2.id WHERE TableName1.column3 = 'Yes'
UPDATE
    TableName1
SET
    TableName1.col1 = TableName2.col1,
    TableName1.col2 = TableName2.col2
FROM
    Some_Table AS TableName1
    INNER JOIN Other_Table AS TableName2
        ON TableName1.id = TableName2.id
WHERE
    TableName1.column3 = 'Yes'