MySQL Forums
Forum List  »  Newbie

Re: Trigger on Select
Posted by: Phillip Ward
Date: April 09, 2014 05:15AM

Even if you could create such a thing - you can't - what would hope to do with it?

Triggers are there to do low-level data integrity checking, e.g. checking field values or validating "foreign keys" that aren't actually implemented as foreign key constraints or modifying data based on the data being changed.

None of which has anything to do with selecting data.

If your application has a need to record something whenever some data is read, then you need to get your application to do so.

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
April 09, 2014 05:01AM
Re: Trigger on Select
April 09, 2014 05:15AM
April 09, 2014 06:00AM
April 09, 2014 08:51AM
April 10, 2014 05:19AM


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.