Correct, if the form generates independent insert statements then they will not "bump into each other", even with an auto_increment.
--- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -----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:^) > > --- > Tom Crimmins > Interface Specialist > Pottawattamie County, Iowa > > -----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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]