• You must to post comments

There are six triggers are allowed to use in MySQL database:-

  1. Before Insert
  2. After Insert
  3. Before Update
  4. After Update
  5. Before Delete
  6. After Delete

Uses for triggers :

  • Enforce business rules
  • Validate input data
  • Generate a unique value for a newly-inserted row in a different file.
  • Write to other files for audit trail purposes
  • Query from other files for cross-referencing purposes
  • Access system functions
  • Replicate data to different files to achieve data consistency
  • You must to post comments
Showing 1 result
Your Answer

Please first to submit.