From: Martijn Tonies Date: May 13 2005 9:54am Subject: Re: Read past Equivalent in MySQL List-Archive: http://lists.mysql.com/mysql/184059 Message-Id: <022f01c557a1$b6872af0$3802a8c0@martijnws> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit > Yes, that's what i said. He is trying to ovverride data consistency, and read > uncommitted is so possible. So why not use it if it solves the problem. > else, read uncommitted sould be droped from mysql. I don't think he is trying to override data consistency... with MS SQL, "read past" wil simply skip the locked records and return a resultset without em. With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com