delimiter $
use d_taiwan;
DROP trigger IF EXISTS `update_limit_create_character`;
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 ;
use d_taiwan;
DROP trigger IF EXISTS `update_limit_create_character`;
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 ;
2楼2020-02-01 10:58收起回复
