0

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

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

17th Mar 2017, 8:26 AM
Thabo Nthako
3 ответов
+ 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
17th Mar 2017, 8:51 AM
देवेंद्र महाजन (Devender)
देवेंद्र महाजन (Devender) - avatar
0
That said Devender can it minimize declarative DDL statements in a program. An inhance performance?
17th Mar 2017, 9:33 AM
Thabo Nthako
0
Yes to some extent it can minimize declarative constraints. And enhances the performance especially when multiple tables needed to be updated.
17th Mar 2017, 9:51 AM
देवेंद्र महाजन (Devender)
देवेंद्र महाजन (Devender) - avatar