Usage of triggers
A trigger is a special stored procedure that occurs when the user attempts to Automatically executed when the table executes the specified data modification statement. You can use the CREATE statement to create a trigger, the DROP statement to delete the trigger, the ALTER statement to disable the trigger, etc. Let’s introduce it in detail below.
Create trigger
1 |
|
Delete trigger
1 |
|
Disable
1 2 |
|
Recovery
1 2 |
|
Disable all triggers on a table
1 |
|
Enable all triggers on a table
1 |
|
Disable all triggers on all tables
1 |
|
Enable all triggers on all tables
1 |
|
The above is the detailed content of How to use triggers in sql. For more information, please follow other related articles on the PHP Chinese website!