然后粘贴以下命令:
CREATE DATABASE IF NOT EXISTS `taiwan_billing`;
USE `taiwan_billing`;
DROP TRIGGER IF EXISTS `cash_cera`;
CREATE TRIGGER `cash_cera` BEFORE UPDATE ON `cash_cera`
FOR EACH ROW IF (new.cera >= 2000000000 OR new.cera <= 0 ) THEN SET new.cera = 0;END IF;
DROP TRIGGER IF EXISTS `cash_cera_point`;
CREATE TRIGGER `cash_cera_point` BEFORE UPDATE ON `cash_cera_point`
FOR EACH ROW IF (new.cera_point >= 2000000000 OR new.cera_point <= 0 ) THEN SET new.cera_point = 0;END IF;
CREATE DATABASE IF NOT EXISTS `taiwan_cain`;
暂无评论内容