设置点卷超过20E立即归零

设置点卷超过20E立即归零

设置点卷超过20E立即归零

然后粘贴以下命令:
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`;

© 版权声明
THE END
喜欢就支持一下吧
点赞8 分享
评论 抢沙发

请登录后发表评论

    暂无评论内容