> Yes. Martijn is correct. > I am trying to skip locked rows and get the next unlocked > row available. Reading uncommited data will cause unexpected > problems. I don't want to do that. > Is there a way to do this?
Use InnoDB and you don't _have_ to skip past locked records :-) With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]