mysql trigger insert into another table

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

I used to have mysql too. Now I am writing SQL Server triggers and I feel that the changes are quite large. define the variable # SET @ VALUE111; # declare @ countint in sqlserver; # assign a value to set @ count0; # if it is a query, must be so

In SQL, a noun trigger is the program code automatically executed in the database to respond to certain events in a special table. (Wikipedia) is a piece of code that is automatically activated when a special database event, such as INSERT or DELETE

　　A: basic knowledge of triggers　　A trigger is a special kind of stored procedure, but without interfaces (input and output parameters), triggers are part of the transaction that raises them because SQL Server automatically throws them as an

Stored Procedure 6-trigger and Stored Procedure 6 I. triggers A trigger is a table-related named database object. This object is called when a specific event occurs on the table. It is a special stored procedure related to table events. Its

This article describes in detail the related knowledge of mysql database triggers, which is very comprehensive. For more information, see. MySQL supports triggers. A trigger is a database object related to table operations. when a specified event

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.

Introduction to MySQL Trigger 1 The database server is passive in nature. We use an SQL statement to display the requirement, and it will execute an operation. A trigger is to program a passive server as an active server. A trigger is a piece of

TriggerMySQL includes support for triggers. A trigger is a database object associated with a table operation that invokes the execution of a trigger on a table when a specified event occurs on the table on which the trigger is located.Triggered by

Mysql (10) trigger 1 bitsCN.com Mysql (10) trigger 1 Related links: Mysql (1) installation of mysql Http: // database/201210/162314 .html; Mysql-related operations (2) Http: // database/201210/162315 .html; Mysql operations on data tables (3) Http: