还有个办法就是用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 ;