Re: Read past Equivalent in MySQL

[Ramesh G]

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?
Regards
Ramesh
On Fri, 13 May 2005 11:54:11 +0200, Martijn Tonies <[EMAIL PROTECTED]>  
wrote:



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


--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]