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
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 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
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
Use of SQL triggers
Triggers: A special type of stored procedure that is not invoked directly by the user or manually, but is triggered by events, such as when working on a table (insert,delete,update). When a trigger is created, it is defined so
Sophomore database, just vaguely heard the teacher mentioned the view ah, stored procedures AH, trigger ah what, but just a faint remember the name, and then do small projects, little programs, also no use, are just simple to build tables, related
MySQL database Advanced (v)--trigger one, Introduction to triggers 1, Introduction to TriggersA trigger is a special stored procedure associated with a table that triggers execution when data is inserted, deleted, or modified in a table, with finer
A trigger is a special kind of stored procedure that triggers a run when inserting, deleting, or altering data in a particular table, which has finer and more complex data control than the standard functionality of the database itself.Database
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.