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
; mysql@lists.mysql.com
Subject: RE: Question regarding Update ... LEFT JOIN
I hope it is locking both tables. Even if you aren't changing any fields
in
the right-hand column, you don't want anyone changing it under you. I
hope
that, if you aren't actually modifying the right-hand table,
bal Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Jonathan Langevin [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 03, 2007 4:13 PM
> To: mysql@lists.mysql.com
> Subject: Question regarding
I've used the syntax, UPDATE ... LEFT JOIN a few times in the past, and
today I used it again for a new employer that I work for.
Several of my associates were unaware that the UPDATE ... LEFT JOIN
syntax is valid in MySQL. After I demonstrated that the query does
indeed work fine on our MySQL 5.x
