MySQL触发器在删除操作之前插入另一个表

Question

我写过类似的东西，但它不起作用。怎么办？

mysql> create trigger deleteStudentTrigger
-> before delete on tblStudent for each row
-> begin
-> insert into tblDeletedStudents select * from tblStudent where StudentId = new.StudentId;
-> end;$

ERROR 1363 (HY000): There is no NEW row in on DELETE trigger

Answer 1

如错误中所述，没有新行，只有旧行(因为当您删除某些内容时，它不是新的，您知道)所以应该是这样

mysql> create trigger deleteStudentTrigger
-> before delete on tblStudent for each row
-> begin
-> insert into tblDeletedStudents select * from tblStudent where StudentId = old.StudentId;
-> end;$

有关更多信息，请参阅 MySQL 文档