Re: More locking issues

2002-12-12 Thread Anderson Pereira Ataides
>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

Re: More locking issues

2002-12-12 Thread Gelu Gogancea
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

Re: More locking issues

2002-12-12 Thread Michael T. Babcock
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

Re: More locking issues

2002-12-12 Thread Gelu Gogancea
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