If you can add a table structure why not create a SELECTED table with REPORT ID and PERSON ID as the 2 field PRIMARY KEY.
Then you could INSERT IGNORE into this table [with no BEGN/COMMIT] and the IGNORE would throw away those already selected. -----Original Message----- From: Duncan Hill [mailto:[EMAIL PROTECTED] Sent: Friday, May 13, 2005 10:25 AM To: mysql@lists.mysql.com Subject: Re: Read past Equivalent in MySQL On Friday 13 May 2005 16:19, Eric Bergen typed: > I agree. It sounds like you could use plain repeatable read isolation > transactions. If someone else is modifying those rows you get an older > version from when your transaction was started. No need for skipping > anything. In the case of what I'm programming, I need to be able to skip records that have been selected by another instance of the program (don't want to send the same person 40 reports with the same content). Hence why I use flags on the table to say 'in progress, don't read me'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
