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,
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, that MySQL uses
a read (SELECT) lock.
Regards,
Jerry Schwartz
Global Information Inco
