Hi: I have an application that is used by around 40 users who need to access a table, obtain a sequential code, and write it back. I'm using MyISAM tables, and mysql 3.23 running under LM 9.0.
A couple of times during the day, the users get the same code, and that is causing us many problems. The code I use is: select lock.... get code add one to code write code release lock.... I have tried lock tables / unlock tables and it will eventually deadlock, even though the manual says it's guaranteed not to happen. I would appreciate a suggestion as to where I can read more about locking tables / records using MySQL and My ISAM tables. Thank you. -- Alfredo J. Cole [EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
