Abstract
A trigger is a task that executes in response to some predefined database event, such as after a new row is added to a particular table. Specifically, this event involves inserting, modifying, or deleting table data, and the task can occur either prior to or immediately following any such event. This chapter begins by offering general examples that illustrate how you can use triggers to carry out tasks such as enforcing referential integrity and business rules, gathering statistics, and preventing invalid transactions. I will then discuss MySQL’s trigger implementation (available as of version 5.0.2), showing you how to create, execute, and manage triggers. Finally, you’ll learn how to incorporate trigger features into your PHP-driven web applications.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2010 W. Jason Gilmore
About this chapter
Cite this chapter
(2010). MySQL Triggers. In: Beginning PHP and MySQL. Apress. https://doi.org/10.1007/978-1-4302-3115-8_33
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3115-8_33
Publisher Name: Apress
Print ISBN: 978-1-4302-3114-1
Online ISBN: 978-1-4302-3115-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books