o: 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
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, ther
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.
---
Tom Crimmins
Interface Specialist
Pottawatta
> 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?
You can use inserts, updates and selects without locking tables as long as
you don't need the table to
