MySQL triggers are nothing but a SQL statement stored in the database. When any event associate with a table is fired i.e. insert, update or delete a trigger is executed.
TRUNCATE statement delete the all data in a table but does not execute the triggers associated with this.
The different between trigger and stored procedure is trigger is called automatically when a event is fired but stored procedure must be called explicitly.
– BEFORE INSERT
– AFTER INSERT
– BEFORE UPDATE
– AFTER UPDATE
– BEFORE DELETE
– AFTER DELETE
MySQL triggers stored with the file name tbl_name.TRG (maps the triggers to table) and tbl_name.TRN (trigger definition).
In a world where digital presence is paramount, the question isn't whether you should do…
Over the years, people have experimented with various methods to maintain healthy and beautiful hair.…
Your brand more than developing an attractive and creative logo and infectious motto. It's the…
Introduction Are you someone who has suffered from a personal injury and want to file…
Operating from home has emerged as one of the most popular ways of doing jobs…
If the consequences of our society’s ever-growing debt are what worries you, then it is…