Re: Help: How do you manually lock a table?

feng.shao doodled thusly:

>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
nsouto_at_optushome.com.au.nospam Received on Wed Dec 05 2001 - 07:03:55 CST