Re: [PHP-DB] Locking for data integrity

2002-11-04 Thread Peter Beckman
They will be queued, in my experience. Peter On Mon, 4 Nov 2002, Josh Johnson wrote: > I'm making a query to one table, and inserting it into another table > (INSERT.SELECT syntax). The table that's the source of the copy is > updated constantly, and is has a large amount of data in it. Will > l

[PHP-DB] Locking for data integrity

2002-11-04 Thread Josh Johnson
I'm making a query to one table, and inserting it into another table (INSERT.SELECT syntax). The table that's the source of the copy is updated constantly, and is has a large amount of data in it. Will locking the table for write (or read??) access keep insert queries to the source table from execu