CODEWITHSUNDEEP
mysqltriggers
Nemoden
Nemoden

Reputation: 9056

MySQL triggers pros & cons

In a nutshell, what are pros and cons of using triggers in MySQL? Yet I have not ever used neither triggers nor stored procedures in MySQL, so I'm used to solve any task I have using PHP for business logic and SQL for CRUD. Now I've got a task to save table's history and thinking of usage of triggers for this purpose. So, the sub-question is: are triggers good for this particular task?

Upvotes: 1

Views: 2805

Answers (1)

Andrey
Andrey

Reputation: 21275

In short: (pros/cons of triggers vs implementing functionality in code, e.g. php)

Pros: easier to implement audit/history

Cons: harder to debug issues

Upvotes: 5

Related Questions