umcommentsumcomment=sumcomment-1,
sumconsumesumconsume=sumconsume-NEW.consume,sumservicesumservice=sumservice-NEW.service,
sumroomsumroom=sumroom-NEW.room,sumentironsumentiron=sumentiron-NEW.entironment,
totaltotal=total-(NEW.service+NEW.room+NEW.entironment) WHERE hotel_id=NEW.hotel_id;
END IF;
END;//
delimiter ;
以上的相关内容就是对MySQL触发器的使用的介绍，望你能有所收获。