List:General Discussion« Previous MessageNext Message »
From:Gordon Date:May 13 2005 5:21pm
Subject:RE: Read past Equivalent in MySQL
View as plain text  
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:duncanh@stripped] 
Sent: Friday, May 13, 2005 10:25 AM
To: mysql@stripped
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/mysql?unsub=1


Thread
Read past Equivalent in MySQLRamesh G13 May
  • Re: Read past Equivalent in MySQLmfatene13 May
    • Re: Read past Equivalent in MySQLmfatene13 May
    • Re: Read past Equivalent in MySQLRamesh G13 May
  • Re: Read past Equivalent in MySQLMartijn Tonies13 May
  • Re: Read past Equivalent in MySQLMartijn Tonies13 May
    • Re: Read past Equivalent in MySQLmfatene13 May
  • Re: Read past Equivalent in MySQLMartijn Tonies13 May
    • Re: Read past Equivalent in MySQLRamesh G13 May
  • Re: Read past Equivalent in MySQLMartijn Tonies13 May
    • Re: Read past Equivalent in MySQLRamesh G13 May
      • Re: Read past Equivalent in MySQLDuncan Hill13 May
  • Re: Read past Equivalent in MySQLMartijn Tonies13 May
    • Re: Read past Equivalent in MySQLEric Bergen13 May
      • Re: Read past Equivalent in MySQLDuncan Hill13 May
        • RE: Read past Equivalent in MySQLGordon13 May
          • Re: Read past Equivalent in MySQLDuncan Hill14 May
            • Re: Read past Equivalent in MySQLmfatene14 May