Hi, Assuming that there are 2 users for MYSQL. First user issues 'lock tables customer_table write'; Second user wish to view the customer info using the command 'select * from customer_table'; This select query will be pending untill the first user issues the 'unlock tables' command. I am wondering is there any method that i can get the message something like 'This customet_table is currently being locked by xxx(first user name)' while the select query is pending. And display this message to the second user. Can it be done?
Thank You --------------------------------------------------------------------- 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
