MySQL触发器



-- Drop trigger if exists netcenter_bc ;
delimiter //  

CREATE TRIGGER netcenter_bc
before INSERT ON netcenter_duty
FOR EACH ROW
Begin   
 
     if (new.week='星期六')||(new.week='星期日')
           then
            set new.bc='2';
  else
      set new.bc='1';
     end if;
 
end;//  
delimiter ;
-- delimiter;