database, sql
Hi there
I have tried looking in the manual but can't see the solution to this.
user a issues a lock on table1, userb then tries to do a select and
obviously the select will wait until the lock is released.
So my questions are :-
1. How do you change the 'timeout' period that userb will wait for?
2. When the timeout is reached, I want to give the user a message box that
shows them who is currently locking the table. How do I see who is locking
table1?
Regards
Warren
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
