I concede to the MySQL engineer :-)
-Original Message-
From: Shawn Green [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 10, 2007 3:30 PM
To: Jonathan Langevin
Cc: Chris White; Richard Reina; mysql@lists.mysql.com
Subject: Re: Does Update allow for aliases?
Hi all,
Multi-table
Hi Reina,
Try like:
mysql > UPDATE maindb o,altdb ao set o.price =ao.price where o.id=ao.id;
This will do good.
Thanks
ViSolve DB Team
- Original Message -
From: "Richard Reina" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 10, 2007 10:08 PM
Subject: Does Update allow for alias
Hi all,
Multi-table updates are not possible for versions older than 4.0.4.
(http://dev.mysql.com/doc/refman/4.1/en/update.html) so the operation is
not possible with your current version.
To be complete, though, each of you missed the second syntax error in
his statement
Jonathan Langevin
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 10, 2007 12:10 PM
To: Richard Reina
Cc: mysql@lists.mysql.com
Subject: Re: Does Update allow for aliases?
Richard Reina wrote:
> I am trying to update from one table to another but I get a syntax
error when I try:
>
> UPD
Hi Richard,
Richard Reina wrote:
I am trying to update from one table to another but I get a syntax error when I
try:
UPDATE from maindb.orders o, altdb.orders ao SET o.price=ao.price WHERE o.ID=a.ID;
If update does not support aliases, is there another way to do this query? I am usin V3
Richard Reina wrote:
I am trying to update from one table to another but I get a syntax error when I
try:
UPDATE from maindb.orders o, altdb.orders ao SET o.price=ao.price WHERE o.ID=a.ID;
First off, it'd be best if possible (I know some cases prevent it) to
upgrade your server. The
