如何修复SQL触发器

Question

如何修复？

CREATE TRIGGER tb_mhs2_hapus AFTER DELETE 
ON tb_mhs2 FOR EACH ROW
BEGIN
INSERT INTO tb_mhs2_hapus (nama, no, alamat, org_tua, timeee) VALUES (old.nama, old.no, old.alamat, old.org_tua, SYSDATE());
END;

我搞不清楚我错在哪里了"您的SQL语法有错误">

Answer 1

首先，为什么您的触发器名称与表名称相同？tb_mhs2_hapus

所以你的代码应该是：

CREATE OR REPLACE TRIGGER TRG_tb_mhs2_hapus 
AFTER DELETE ON tb_mhs2 
FOR EACH ROW
BEGIN
INSERT INTO tb_mhs2_hapus (nama, no, alamat, org_tua, timeee) 
VALUES (old.nama, old.no, old.alamat, old.org_tua, SYSDATE());
END;