MYSQL触发器怎么写？

Question

问题遇到的现象和发生背景

按照书上例子写报错，但不理解，不会改

问题相关代码，请勿粘贴截图

mysql> CREATE TRIGGER Student_Count
    -> AFTER INSERT ON Student
    -> REFERENCING
    -> NEW TABLE AS DELTA
    -> FOR EACH STATEMENT
    -> INSERT INTO StudentInsertLog(Numbers)
    -> SELECT COUNT(*)FROM DELTA;

运行结果及报错内容

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REFERENCING
NEW TABLE AS DELTA
FOR EACH STATEMENT
INSERT INTO StudentInsertLog(N' at line 3

我想要达到的结果

将每次对表Student的插入操作所增加的学生个数记录到表StudentInsertLog中

Answer 1

参考：

CREATE OR REPLACE TRIGGER TRI_DELETE_INFO
  AFTER DELETE ON T_INFO_2012
  REFERENCING OLD AS OLD NEW AS NEW
  FOR EACH ROW
DECLARE
  V_SQLERRM VARCHAR2(200);
BEGIN
  DELETE FROM T_INFO_2013 WHERE CODE = :OLD.CODE;
  --COMMIT; 触发器中不可以使用COMMIT;
EXCEPTION
  WHEN OTHERS THEN
    V_SQLERRM := '触发器 TRI_DELETE_INFO 出错：' || SQLERRM;
    INSERT INTO PROCEDURE_LOG
      (ERRMSG, ERRDATE)
    VALUES
      (V_SQLERRM, SYSDATE);
END;