mysql条件触发器实例_mysql 触发器实例

测试表1

DROP TABLE IF EXISTS test;

CREATE TABLE test (

id bigint(11) unsigned NOT NULL AUTO_INCREMENT,

name varchar(100) NOT NULL DEFAULT '',

type varchar(100),

create_time datetime,

PRIMARY KEY (ID)

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

测试表2

DROP TABLE IF EXISTS test_hisy;

CREATE TABLE test_hisy (

id bigint(11) unsigned NOT NULL AUTO_INCREMENT,

name varchar(100) NOT NULL DEFAULT '',

type varchar(100),

create_time datetime,

operation varchar(100) COMMENT '操作类型',

PRIMARY KEY (ID)

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

insert触发器

表test新增记录后，将type值为“1”的记录同时插入到test_hisy表中(AFTER INSERT：录入后触发， BEFORE INSERT：录入前触发)

DELIMITER //

DROP TRIGGER IF EXISTS t_after_in