mysql触发器实例

来源：动视网责编：小采时间：2020-11-09 13:48:55

mysql触发器实例

mysql触发器实例:DELIMITER // DROP TRIGGER IF EXISTS t_after_insert_test// CREATE TRIGGER t_after_insert_test AFTER INSERT ON test FOR EACH ROW BEGIN IF new.type='1' THEN insert into test_hisy(name, type, create_time, operation) values(new.name, new.type,

推荐度：

点击下载本文 文档为doc格式

导读mysql触发器实例:DELIMITER // DROP TRIGGER IF EXISTS t_after_insert_test// CREATE TRIGGER t_after_insert_test AFTER INSERT ON test FOR EACH ROW BEGIN IF new.type='1' THEN insert into test_hisy(name, type, create_time, operation) values(new.name, new.type,

DELIMITER // DROP TRIGGER IF EXISTS t_after_insert_test// CREATE TRIGGER t_after_insert_test AFTER INSERT ON test FOR EACH ROW BEGIN IF new.type='1' THEN insert into test_hisy(name, type, create_time, operation) values(new.name, new.type,

DELIMITER //

DROP TRIGGER IF EXISTS t_after_insert_test//

CREATE TRIGGER t_after_insert_test

AFTER INSERT ON test

FOR EACH ROW

BEGIN

IF new.type='1' THEN

insert into test_hisy(name, type, create_time, operation)

values(new.name, new.type, new.create_time, 'insert');

END IF;

END;//

，