>From MySQL Reference Manual:
...
Normally, you don't have to lock tables, as all single UPDATE statements are
atomic; no other thread can interfere with any other currently executing SQL
statement. There are a few cases when you would like to lock tables anyway:
* If you are going to run many
ssage -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "Gelu Gogancea" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Jeff Snoxell" <[EMAIL PROTECTED]>
Sent: Thursday, December 12, 2002 8:44 PM
Subject: Re: More locking issues
> Gelu Go
Gelu Gogancea wrote:
If you have more than one user connected to the database which handled the
same tables, you need to use LOCK/UNLOCK tables.
MySQL daemon don't lock tables or records if you don't require this.
Can I ask if this is in fact accurate? As I understand it, MySQL does a
fairl
Hi,
If you have more than one user connected to the database which handled the
same tables, you need to use LOCK/UNLOCK tables.
MySQL daemon don't lock tables or records if you don't require this.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanen