Re: How can I create a trigger that increments on read?
I don't mind updating to 5.0 or higher, I just need to know the best way to do this.
I read the links above, and it still seems like there is too much time in between the begin and commit.
I'm not sure how mysql queues that sort of query.
What I need is a way to ensure that no two reads **ever** get the same data from the SELECT.
What I also need is to not lock the database into a position {if something crashes} that nothing else can read from it too.
Whatever I need to go about to do it is cool with me...
Subject
Views
Written By
Posted
7565
August 18, 2005 07:36PM
2843
August 19, 2005 02:55AM
2548
November 01, 2006 03:50AM
2661
November 01, 2006 04:28AM
2461
August 19, 2005 12:43PM
2681
August 19, 2005 01:09PM
Re: How can I create a trigger that increments on read?
2395
August 19, 2005 04:33PM
2444
August 19, 2005 01:40PM
2474
August 20, 2005 12:36PM
2219
October 22, 2006 11:29PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.