One, what triggers1, personal understandingThe function of the trigger is to achieve synchronization between the two libraries, that is, the operation of library A and so on in the operation of library B, you can create a change on the table a
Why use a trigger? Advantages of triggers 1. Trigger's "automatic"For programmers, the trigger is invisible, but he does. If no trigger is needed, when you update the name field of the user table, you need to write code to update redundant fields in
One, the advantages of the trigger1, the " automatic " of the triggerTo the programmer, the trigger is not visible, but he did do things, if you do not use a trigger, you update the user table name field, you also write code to update other tables
Reprint, original linkOne, what triggers1, personal understandingFlip-flops, literally understood, trigger a device, called triggers (haha, personal understanding), for example, like dark, you turn on the lights, you see things. You put the
a more comprehensive set of PHP tutorials , basic video and some small combat projects, below is the video directoryCD-ROM (i) \php employment Class (I.)CD-ROM (i) \php Technical exchange zone. URLCD-ROM (i) \ "Wisdom Special issue" belongs to it
I. What trigger is a special stored procedure. Its execution is not called by a program or started manually, but triggered by an event, for example, when you perform operations (insert, delete, update) on a table, it is activated for execution.
One, what triggers1, personal understandingFlip-flops, literally understood, trigger a device, called triggers (haha, personal understanding), for example, like dark, you turn on the lights, you see things. You put the firecracker, lit, and then
This article mainly introduces the MySQL5 trigger. Every time I demonstrate the actual code, I will use MySQL (the best combination with PHP) the code displayed on the screen of the client is adjusted, mainly by changing the font to Courier, making
Beckham _ mysql trigger and Beckham _ mysql triggerTriggerBrief1. Basic concepts of triggers2. Trigger syntax and practical examples3. Differences between before and after
I. Basic concepts of triggers
1. Instant Transmission
2. Role: monitor a
One, what triggers
1, personal understandingTriggers, which are literally understood, a hair-trigger device, a trigger (haha, personal understanding), for example, like when it's dark, you turn on the light, you see something. You put the
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.