Yes, i need this too but for a whole database. i just thought, if there is a power loss, and the database is get stuck, the users won't able to connect again ...
Vaso -----Original Message----- From: Hayan Al Mamoun [mailto:[EMAIL PROTECTED]] Sent: 2002. janu?r 28. 9:48 To: MYSQL MAILING LIST (E-mail) Subject: Table Lock Hi, Is there a way to lock a table so that only one user can change it and then unlockit? I need to do this coz I want visitors to retrieve some values from a database but each value must be retrieved only by one user and then marked up to be expired, so I don't want two users to retrieve the same value Any suggestions Best Regards Hayan --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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