Open main menu
Home
Random
Recent changes
Special pages
Community portal
Preferences
About Wikipedia
Disclaimers
Incubator escapee wiki
Search
User menu
Talk
Dark mode
Contributions
Create account
Log in
Editing
Database trigger
(section)
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
==== Schema-level triggers ==== * After Creation * Before Alter * After Alter * Before Drop * After Drop * Before Insert The four main types of triggers are: # Row-level trigger: This gets executed before or after ''any column value of a row'' changes. # Column-level trigger: This gets executed before or after the ''specified column'' changes. # For each row type: This trigger gets executed once for each row of the [[result set]] affected by an insert/update/delete. # For each statement type: This trigger gets executed only once for the entire result set, but also fires each time the statement is executed.
Edit summary
(Briefly describe your changes)
By publishing changes, you agree to the
Terms of Use
, and you irrevocably agree to release your contribution under the
CC BY-SA 4.0 License
and the
GFDL
. You agree that a hyperlink or URL is sufficient attribution under the Creative Commons license.
Cancel
Editing help
(opens in new window)