MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

Re: Select with update (Select trigger)
Posted by: Peter Brawley
Date: June 28, 2011 01:17PM

> I want FLAG to be updated to TRUE if that row of the database has been selected.

To accomplish that, you'd have to prevent all SELECT access except the one you configure to combine that SELECT with that UPDATE. That could be awkward, for example you yourself would not be able to execute a raw SELECT on the table from the mysql client or phpMyAdmin or any other general purpose mysql client, for example.

PB

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Select with update (Select trigger)
5045
Ronald Albury
June 28, 2011 11:59AM
Re: Select with update (Select trigger)
2729
Peter Brawley
June 28, 2011 01:17PM
Re: Select with update (Select trigger)
1662
Ronald Albury
June 28, 2011 01:19PM
Re: Select with update (Select trigger)
1395
Ronald Albury
June 28, 2011 02:19PM
Re: Select with update (Select trigger)
1292
Peter Brawley
July 01, 2011 11:01AM


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.