Bug #16525 INSTEAD OF triggers
Submitted: 15 Jan 2006 23:37 Modified: 16 Jan 2006 12:13
Reporter: Markus Popp Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S4 (Feature request)
Version:5.X OS:Any (all)
Assigned to: CPU Architecture:Any

[15 Jan 2006 23:37] Markus Popp 
Description:
I think, INSTEAD OF triggers would be a nice feature.

How to repeat:
-
[16 Jan 2006 12:13] MySQL Verification Team 
Thank you for the feature request's bug report.
[14 Sep 2006 10:58] Valeriy Kravchuk 
Bug #19990 was marked as a duplicate of this one.
[24 Oct 2008 17:57] MySQL Verification Team 
Bug: http://bugs.mysql.com/bug.php?id=39466 was marked as duplicate of this one.
[25 Oct 2008 17:30] Valeriy Kravchuk 
Bug #40012 was marked as a duplicate of this one.
[4 Feb 2009 2:44] Jim Manico 
I to have run up against this limitation. It would be a great addition.
[14 Jul 2011 8:34] Meenakshi SUndara Santhosh 
Consider this one as high priority.
We are changing from MSSql to Mysql. We uses this feature very much. 

Regards
VMSSanthosh
[26 Dec 2012 20:59] MySQL Verification Team 
http://bugs.mysql.com/bug.php?id=67977 is a duplicate of this
[20 Nov 2015 7:32] Daniël van Eeden 
With the Rewriter plugin (and possibly other rewrite plugins) this is sort-of possible.
One major limitation in the Rewriter plugin is that it is limited to SELECT.
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html

This feature should be combined with:
Bug #72395 	ON SELECT trigger

This is useful for situations with partitioning where the partitions are not equal (e.g. old partitions have less indexes or slightly different column definitions).