用Navicat连接数据库,然后找到d_taiwan,右键,命令列介面,复制粘贴过去,回车就完了! 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 ; 解除创建上限