lock statement

2002-09-23 Thread Chris Barnes
hi people, just a quick question. is there a way i can use the lock tables statement to lock all the tables in a database which out having to specify all tables individually? i dont really want to use a statement like: lock tables table1 read, table2 read table3 read, table4 read, table5 read,

Re: lock statement

2002-09-23 Thread Paul DuBois
At 1:13 +1000 9/24/02, Chris Barnes wrote: hi people, just a quick question. is there a way i can use the lock tables statement to lock all the tables in a database which out having to specify all tables individually? i dont really want to use a statement like: lock tables table1 read, table2