RE: lock the tables - Tom Crimmins - com.mysql.lists.mysql

5 messages in com.mysql.lists.mysqlRE: lock the tables

From	Sent On	Attachments
leegold	08 Jan 2005 01:38
Jigal van Hemert	08 Jan 2005 02:03
Tom Crimmins	08 Jan 2005 02:06
leegold	08 Jan 2005 02:46
Tom Crimmins	08 Jan 2005 03:11

Subject:	RE: lock the tables
From:	Tom Crimmins (mys...@pottcounty.com)
Date:	01/08/2005 03:11:14 AM
List:	com.mysql.lists.mysql

Correct, if the form generates independent insert statements then they will not "bump into each other", even with an auto_increment.

-----Original Message----- From: leegold Sent: Saturday, January 08, 2005 4:46 AM To: No name Subject: RE: lock the tables

On Sat, 8 Jan 2005 04:06:44 -0600 , "Tom Crimmins" said:

Unless your form is changing the same rows and order of operations is important (which is probably not the case), there is no need to lock the tables. So if each time the form is submitted it inserts a new row, there is no reason to lock the tables.

So in MYSQL/PHP different users inserting data into the same tables (w/an autoincremt as the PK) - they will not bump into each other Under "normal" circumstances. Correct? If they did i will know it very fast:^)

-----Original Message----- From: leegold Sent: Saturday, January 08, 2005 3:39 AM To: No name Subject: lock the tables

I'm going to have a php web form that potentially many users will use to insert into a MYSQL DB, maybe they will try at the same time. Do I have to lock the tables that are being populated?

Will a solution queue insert requests or just say I am busy?

Thanks, Lee