创建触发器:
	CREATE trigger <触发器名>
< BEFORE | AFTER > <INSERT | UPDATE | DELETE >
ON <表名>
FOR EACH Row
<触发器主体>
< BEFORE | AFTER > <INSERT | UPDATE | DELETE >
ON <表名>
FOR EACH Row
<触发器主体>
create TRIGGER audid_log after insert on employees_test for each row begin insert into audit values(new.id,new.name); end



 京公网安备 11010502036488号
京公网安备 11010502036488号