in Projects, Programming, Technology

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

Write a Comment

Comment