How to perform a MySQL update from one table to another

The MS SQL syntax is different from the MySQL syntax (MS SQL allows you to do a join).

UPDATE updatefrom p, updateto pp

SET pp.last_name = p.last_name

WHERE pp.visid = p.id

Tweet

Adam Loving wrote this post.

Tagged as: mysql, sql, update