Ramesh, > Thanks a lot for your comments. In MS SQL we have something which can > achieve this very simply: > > select Top 1 * from Table1 with (updlock,readpast) > > I am looking for something exactly similar to this in MySQL.
This actually is a work-around for that bloody MS SQL locking crap. >Creating temp > tables will not work for me as the no of users for the system could be as > high as 500. As far as I know, InnoDB uses multi-versioning to AVOID locks. MS SQL Yukon uses this technique as well and will probably tout it as "new!" while the technique is waaaaay old and first commercially used in InterBase. 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]