mysql trigger tutorial

Typically used to detect inserted values when inserting a table, or to calculate a value on update.The app can be manipulated when insert,update,delete a tableGrammar:Creating a trigger CREATE TRIGGER trigger name Before/after insert/update/delete on table name for each row SQL statementSuch as:Create trigger Cal_num b

Label:Three after triggers DROP TABLE IF EXISTS tab1;CREATE TABLE Tab1 (tab1_id varchar (11),Tab1_name varchar (11),Tab1_pass varchar (11));DROP TABLE IF EXISTS tab2;CREATE TABLE TAB2 (tab2_id varchar (11),Tab2_name varchar (11),Tab2_pass varchar (11));--Add after insert triggerDROP TRIGGER IF EXISTS t_afterinsert_on_tab1;CREATE TRIGGER T_AFTERINSERT_ON_TAB1After INSERT on TAB1For each ROWBEGINInsert into

correct.The reasons are: to assign values to multiple variables through a SELECT statement, use the following statement form: Select Id,name into @v1, @v2 from ...So eventually I changed to the following way:CREATE TRIGGER IstmingxiAfter UPDATE on Sys_shenbao for each ROW BEGINSELECT Jl.skid,shen.gonghao,jl.vuid,ct.leibie,ct.bianhao,ct.fenshu,zl.bumen,shen.verifytimeInto @kid, @gonghao, @vuid, @zhibiao, @citiao, @fenshu, @bumen, @ctimeFrom Sys_shenba

The following two examples are from:Http://www.cnblogs.com/nicholas_f/archive/2009/09/22/1572050.htmlThe actual measurement is valid, but the original post delimiter is not correct, so modify it slightly.Where old means tab2 (passive trigger), new represents TAB1 (active, external application executes INSERT statement in this table) Example 1: Create two tables to add one record in one table, and another to add a record:DROP TABLE IF EXISTS tab1;CREA

How to use mysqldump to export a Trigger Description:When using mysqldump to export a Trigger, you may encounter a problem and paste it to avoid mistakes. When you perform the following operations:[Root @ ytt ~] #/Usr/local/mysql/bin/mysqldump-S/tmp/mysql1.sock test> test. SQLThe exported result contains the Trigger

How to use mysqldump to export a Trigger Description:When using mysqldump to export a Trigger, you may encounter a problem and paste it to avoid mistakes. When you perform the following operations:[Root @ ytt ~] #/Usr/local/mysql/bin/mysqldump-S/tmp/mysql1.sock test> test. SQLThe exported result contains the Trigger

Label: first, the concept of triggers A trigger is a special stored procedure, in which the stored procedure is invoked with call, and the trigger does not need to be called, nor does it need to be started manually, as long as a predefined event occurs and is automatically called by MySQL. A trigger is a special kind o

Mysql uses a trigger to synchronize two tablesCurrently, the local test is successful.Assume that two local databases a and B have table1 (id, val) and table2 (id, val) in table)Assume that you want to synchronize data updates in table 1 and table 2.Code:DELIMITER $CREATE/* [DEFINER = {user | CURRENT_USER}] */TRIGGER 'A'. 'tr