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,

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,