MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: UPDATE multiple tables with one UPDATE statement
Posted by: Peter Brawley
Date: April 26, 2006 12:48PM

UPDATE a
INNER JOIN b USING (id)
SET a.firstname='Pekka', a.lastname='Kuronen',
b.companyname='Suomi Oy',companyaddress='Mannerheimtie 123, Helsinki Suomi'
WHERE a.id=1;

PB

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
UPDATE multiple tables with one UPDATE statement
Anthony Linhardt
April 26, 2006 12:38PM
Re: UPDATE multiple tables with one UPDATE statement
Peter Brawley
April 26, 2006 12:48PM
Re: UPDATE multiple tables with one UPDATE statement
Anthony Linhardt
April 26, 2006 02:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.