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).
The coronavirus outbreak has drastically changed the way we live our lives. Yes, that's absolutely…
Sales and marketing teams help attract, convert, and retain customers to ensure an organization’s long-term…
Are you an owner of a small business who’s trying to come up with ways…
Introduction When patients bring me their lab reports, the confusion is almost always the same.…
Are you excited about remodeling your house after a long time? Perhaps if you're planning…
The practice of yoga teaches us to be present, patient and mindful of our decisions.…