触发器实例

多个执行语句的触发器的基本写法：

CREATE TRIGGER trigger_name trigger_time trigger_eventON tbl_name FOR EACH ROW trigger_stmt

实例：创建一个触发器，每次插入一条数据之后分别往三张表插字段：

CREATE TRIGGER trigger_student AFTER INSERT ON studentFOR EACH ROW BEGIN    INSERT INTO triggerstudentname values(NEW.studentName);    INSERT INTO triggerstudentAge values(NEW.studentAge);    INSERT INTO triggerstudentPhone values(NEW.studentPhone);END