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
View the documentation here:
http://dev.mysql.com/doc/refman/5.0/en/join.html
You could write your statement as
SELECT
Field1, field2
FROM
Table1
LEFT JOIN Table2
LEFT JOIN Table3
OR
SELECT
Field1, field2
FROM
(Table1, Table2)
LEFT JOIN Ta
The proper syntax would need to be:
UPDATE maindb.orders o, altdb.orders ao SET o.price=ao.price WHERE
o.ID=a.ID;
The only problem is the existence of the "from".
That being said, an UPDATE ... JOIN likely doesn't work under MySQL 3
-Original Message-
From: Chris White [mailto:[EMAIL PR
total time used for a SELECT lock)
-Original Message-
From: Jonathan Langevin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 03, 2007 4:49 PM
To: Jerry Schwartz; mysql@lists.mysql.com
Subject: RE: Question regarding Update ... LEFT JOIN
That would be fine with me, but then conversely
That would be fine with me, but then conversely it means multiple tables
would be locked by one query, which is bad in our environment (high
transaction)
-Original Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 03, 2007 4:24 PM
To: Jonathan Langevin
ld
determine whether I'll continue to use this update structure.
Many thanks!
RED VENTURES
Jonathan Langevin
PHP Developer (Home Services Corp)
14120 Ballantyne Corporate Place
Suite 200
Charlotte, NC 28277
Tel: 704-971-4373
Fax: 704-971-2303
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>