- Oracle
注意: 目前测试发现,clob类型字段无法成为触发器内字段(或因内容处理问题,暂无解)
--更改汉字部分即可 触发器名称可自定义,但有长度限制,直接为表名也可以
CREATE TRIGGER 触发器名称
AFTER INSERT OR UPDATE OR DELETE ON 表名
FOR EACH ROW
BEGIN
IF INSERTING THEN
INSERT INTO 表名 库名对象
(字段名1, 字段2)
VALUES
(:NEW.字段名1, :NEW.字段2);
ELSIF UPDATING THEN
UPDATE 表名 库名对象
SET 字段名1 = :NEW.字段名1, 字段2 = :NEW.字段2
WHERE ID = :OLD.ID;
ELSIF DELETING THEN
DELETE FROM 表名 库名对象 WHERE ID = :OLD.ID;
END IF;
END;
2.Mysql
CREATE TRIGGER `触发器名称` AFTER DELETE ON `表名` FOR EACH ROW
BEGIN
DELETE FROM 表名 WHERE id = old.id;
END;
CREATE TRIGGER `触发器名称` AFTER UPDATE ON `表名` FOR EACH ROW BEGIN
UPDATE user SET 列名 = new.列名 WHERE id = old.id;
END;
CREATE TRIGGER `触发器名称` AFTER INSERT ON `表名` FOR EACH ROW BEGIN
INSERT INTO `user`(字段名1, 字段2) VALUES (new.字段名1,new.字段2);
END;
Navicat 图例: