MySQL Forums
Forum List  »  French

Re: update multi-tables
Posted by: maadh necib
Date: October 03, 2007 10:41AM

Bonjour,

Il est possible de faire de mise à jour (ci-dessous un exemple) dans une instruction UPDATE. Le WHERE ne posera aucun problème.
Cependant votre question ne semble pas claire pouvez la reformuler.

UPDATE t1
INNER JOIN t2 ON(t1.id = t2.id)
INNER JOIN t3 ON(t1.ref = t3.ref)
SET
t2.C1=t3.C1,
t2.val=t3.val ;

Cordialement,

Options: ReplyQuote


Subject
Views
Written By
Posted
9406
October 01, 2007 11:07AM
5995
October 01, 2007 11:33AM
Re: update multi-tables
4638
October 03, 2007 10:41AM
3990
October 16, 2007 07:38PM


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.