Update From Another Table MySQL Example

Update From Another Table MySQL We can update another table with the help of the inner join. 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’