On Sat, 8 Jan 2005 04:06:44 -0600 , "Tom Crimmins" <[EMAIL PROTECTED]> 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]