Bug #72395 ON SELECT trigger
Submitted: 20 Apr 2014 8:40 Modified: 21 Apr 2014 18:08
Reporter: Jassim Rahma Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D5 (Feature request)

[20 Apr 2014 8:40] Jassim Rahma
Description:
I suggest the following improvement:

Please add an option for an ON SELECT trigger

How to repeat:
this is a suggestion
[21 Apr 2014 18:08] Sveta Smirnova
Thank you for the reasonable feature request.
[20 Nov 2015 7:28] Daniël van Eeden
Probably a duplicate of:
Bug #21553 	RFE: CREATE TRIGGER ... SELECT ON ...

Note that in MySQL 5.7 with the Rewriter plugin similar functionality is available. I don't think the Rewriter plugin allows multiple statements, but it could call a stored procedure which does that. It might be hard to get the Rewriter plugin to intercept all SELECT queries on a table. So this might solve the issue for some cases, but not for all cases so this RFE is still needed.

Together with this RFE it might make more sense:
Bug #16525 	INSTEAD OF triggers