触发器仍在工作，甚至输入了错误的输入

发布于 2025-02-04 04:37:39 字数 537 浏览 3 评论 0原文

我的问题是，即使我放了错误的字母，除了“ F”或“ M”外，触发器仍然更新。另外，即使我将“ F”或“ M”字母放在小写中，触发器仍然可以正常工作。如果输入不正确，我要如何使触发器不起作用？例如将错误的字母放在小写字母中。

这是我的代码：

CREATE TRIGGER trgAllowance -- trigger name
    BEFORE UPDATE
    ON tab_employee FOR EACH ROW
    BEGIN
        IF new.EmpGender = 'F' THEN
            SET new.SpecialAllowance = (new.Salary*0.2); /* Count the amount of Salary times by specific amount */
        ELSEIF new.EmpGender = 'M' THEN
            SET new.SpecialAllowance = (new.Salary*0.05);
        END IF;
    END

原文

My problem is, even i put the wrong alphabet other than 'F' or 'M', the trigger still updated. Also, even i put the 'F' or 'M' alphabet in lowercase, the trigger still function. how i want to make the trigger not function if the input is not correct? such as putting the wrong alphabet with lowercase.

here is my code :

CREATE TRIGGER trgAllowance -- trigger name
    BEFORE UPDATE
    ON tab_employee FOR EACH ROW
    BEGIN
        IF new.EmpGender = 'F' THEN
            SET new.SpecialAllowance = (new.Salary*0.2); /* Count the amount of Salary times by specific amount */
        ELSEIF new.EmpGender = 'M' THEN
            SET new.SpecialAllowance = (new.Salary*0.05);
        END IF;
    END

分享到QQ

分享到微博