MySql update one table using other table

Posted: June 27, 2013 in MySql

If you want to update one column with another table’s column you can use below query

UPDATE `tb_student`
 INNER JOIN  tb_student_backup ON ( tb_student_backup.student_id = tb_student.student_id)
 SET tb_student.address_1 = tb_student_backup.street_address

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s