What important features do i need to impliment in the usage of MySQL Triggers?

Question

Any suggestions on any business procedures that one would favour in its usage.

Answer 1

A trigger is a kind a stored procedure is executed automatically in response to an insert, update, or delete operation w.r.t a table for which trigger is defined.
Advantages:
- Best suited while validating a DML statement that modifies a table whenever DML statement is executed on that table.
- These can be for automatic updation of one or more tables whenever a DML/DDL statement is executed
- Triggers can be used to enforce constraints which are otherwise can't be declarative and are more logical
For eg : DML statements should be allowed on a particular table only in office hours
- Triggers can be used to record auditing purpose. Such as old state of data should be saved before applying change to the data.
- Enable developers to update multiple related objects and records

Answer 2

That said Devender can it minimize declarative DDL statements in a program. An inhance performance?

Answer 3

Yes to some extent it can minimize declarative constraints. And enhances the performance especially when multiple tables needed to be updated.