Jun

07

How to perform a MySQL update from one table to another

Filed Under (Databases and SQL) by admin on 07-06-2008

Tagged Under : , ,

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

0 Comments
Read More