trigger_name = table_name_[A|B] [I|U|D] [R|S]
trigger_name 长度限制在30个字符
表名缩写+trigger属性信息
trigger属性信息
[A|B] 触发器类型是BEFORE 还是AFTER.[I|U|D] 显示触发器事件, INSERT,UPDATE,DELETE
[R|S] 显示触发器类型是ROW 还是STATEMENT
下面举例子:
Table |
Trigger Type |
Triggering Event |
Trigger Name |
STUDENTS |
BEFORE EACH ROW | INSERT | students_bir |
STUDENTS |
AFTER EACH ROW | INSERT OR UPDATE | students_aiur |
STUDENTS |
BEFORE EACH ROW | INSERT | students_ais |