DROP TRIGGER IF EXISTS `update_limit_create_character`;
DELIMITER ;;
CREATE TRIGGER `update_limit_create_character` BEFORE UPDATE ON `limit_create_character` FOR EACH ROW IF new.count =2 THEN
SET new.count = 0;
END IF
;;
DELIMITER ;
创建角色限制触发器。查询即可
DELIMITER ;;
CREATE TRIGGER `update_limit_create_character` BEFORE UPDATE ON `limit_create_character` FOR EACH ROW IF new.count =2 THEN
SET new.count = 0;
END IF
;;
DELIMITER ;
创建角色限制触发器。查询即可
