MySQL Forums
Forum List  »  Triggers

Re: How can I create a trigger that increments on read?
Posted by: Greg Chandler
Date: August 19, 2005 04:33PM

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...

Options: ReplyQuote

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.