June 20, 2013

Post: Using VIEW to reduce number of tables used

triggers on views, specially INSTEAD OF triggers so you could write triggers to perform insert inserts to base tables instead of views. BEFORE INSERT triggers

Post: Using Flexviews - part two, change data capture

trigger is immediate and affects every transaction. Finally, MySQL has limited trigger support, some of which is the cause ofInstead, it invokes the ‘mysqlbinlog’ utility and it processes the predictable output of