mysql触发器

DELIMITER $$

create trigger upd_tmp after update on tmp1 for each row begin insert into tmp2 (id,name,age) values (new.id,new.name,new.age);
//update触发器

show triggers \G
CREATE TRIGGER tmp_time3 AFTER INSERT ON tmp1 FOR EACH ROW BEGIN INSERT INTO tmp3(id,name,age,updateTime) VALUES (new.id,new.name,new.age,now()); END;$$

//insert触发器

DELIMITER ;  //设置;为结束语