触发器示例

在这里插入代码片

//添加触发器
CREATE TRIGGER insert_user2_trigger  
AFTER INSERT ON auth_enter  
FOR EACH ROW  
BEGIN  
    INSERT INTO peddler_user (id, peddler_user_id)  
    VALUES (null, NEW.enter_id);  
END;
//查看
show triggers;
//删除触发器
drop trigger insert_user_trigger;


end;