A trigger is a special stored procedure that triggers execution when inserting, deleting, or modifying data in a particular table, and it has a finer and more complex data control capability than the standard functionality of the database itself.the
0. Basic concepts of Triggersa trigger is a special stored procedure that triggers execution when inserting, deleting, or modifying data in a particular table, and it has a finer and more complex data control capability than the standard
This article mainly introduces the basic learning tutorial of MySQL triggers, including the basic knowledge of trigger creation and management! For more information, see
0. basic concepts of triggersA trigger is a special stored procedure that
The following articles mainly describe the detailed usage and case analysis of MySQL triggers. At the same time, this article also lists some code in the actual operations of MySQL triggers, the following is a detailed description of the article.
MySQL learning-triggers, MySQL learning-triggers
MySQL supports triggers. A trigger is a database object related to table operations. When a specified event occurs on the table where the trigger is located, this object is called, that is, the
MySQL Optimization-triggers and mysql triggers
Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46763665
A trigger is a special stored procedure. The difference is that the stored procedure must be called by
Conventions and styles conventions and programming styles
Every time I want to demonstrate the actualCodeI will adjust the code displayed on the screen of the mysql client and change the font to courier to make them look different from normal
The following articles mainly describe the detailed usage and case analysis of MySQL triggers. At the same time, this article also lists some code in the actual operations of MySQL triggers, the following is a detailed description of the
Creating triggers
Create a trigger with only one execution statementCREATE TRIGGER Trigger Name before| After Trigger eventOn table name for each ROW executes the statement where the trigger name parameter refers to the name of the trigger to be
MySQL 21-29 highlights: Views, triggers, stored procedures, cursors, transaction processing bitsCN.com
21. create and operate tables
21. 1. create a table
Create table:
1) Name of the new table, after the keyword CREATETABLE
2) names and definitions
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.