Help: How do you manually lock a table? 
Author Message
 Help: How do you manually lock a table?
Hi,  We need to purposely lock a table to test some scripts.
How would you do that?
Somebody suggested us building a huge table and rebuild the index on it,
is that the only way to do it?

Thanks for your help



Sun, 23 May 2004 21:00:56 GMT
 Help: How do you manually lock a table?

feng.shao doodled thusly:

Quote:
>Hi,  We need to purposely lock a table to test some scripts.
>How would you do that?
>Somebody suggested us building a huge table and rebuild the index on it,
>is that the only way to do it?

LOCK TABLE <tablename> IN EXCLUSIVE MODE;

should do the trick?

Cheers
Nuno Souto



Sun, 23 May 2004 21:03:55 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. manually lock a table

2. Locking table when deletion is doing

3. Locking tables on a network before doing a series of queries

4. How to manually lock

5. Do we need to LOCK it manually?

6. how to lock row manually

7. manually lock a record?

8. Help with statement in proc suddenly doing full table scan

9. help figuring out why query doing full table scan

10. Help - Simple SQL query doing full table scans

11. Table is locked, workstation coughs, table stays locked.


 
Powered by phpBB® Forum Software