trigger_name 的命名规范

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