Mysql触发器使用（insert、update、delete）

insert

DELIMITER //    
CREATE TRIGGER InsertUser    
BEFORE INSERT ON user1   
FOR EACH ROW    
BEGIN   
INSERT INTO user2(id,NAME,age) VALUES(new.id,new.name,new.age);    
END;//    
DELIMITER ; 

update

DELIMITER //    
CREATE TRIGGER updateUser AFTER
UPDATE ON user1 FOR EACH ROW
BEGIN
UPDATE user2 SET NAME = new.name,age=new.age WHERE id = new.age;
END; //  
DELIMITER ;   

delete

DELIMITER //    
CREATE TRIGGER deleteUser AFTER
DELETE ON user1 FOR EACH ROW
BEGIN
DELETE FROM user2 WHERE id = old.id;
END; //  
DELIMITER ;