MySQL触发器示例

 DELIMITER |
CREATE TRIGGER trg_tbl_coupon_insert BEFORE INSERT ON tbl_coupon FOR EACH ROW
BEGIN
 INSERT INTO tbl_coupon_new SET id = NEW.id,group_id=NEW.group_id,has_use_number=NEW.has_use_number,is_use=NEW.is_use,
 card_number=NEW.card_number;
END
|

 

DELIMITER |
CREATE TRIGGER trg_tbl_coupon_update BEFORE UPDATE ON tbl_coupon FOR EACH ROW
BEGIN
 REPLACE INTO tbl_coupon_new SET id = NEW.id,group_id=NEW.group_id,has_use_number=NEW.has_use_number,is_use=NEW.is_use,
 card_number=NEW.card_number;
END;
|