Mysql update field using another table

You are here:

Home
dev stuff
Mysql update field using another…

A simple usage of updating a field using another tables field

MySQL syntax:

UPDATE destination_table
INNER JOIN source_table ON destination_table.id = source_table.id 
SET destination_table.first_name = source_table.first_name

UPDATE destination_table

INNER JOIN source_table ON destination_table.id = source_table.id

SET destination_table.first_name = source_table.first_name

Mysql update field using another table

MySQL syntax:

Related posts