mysql - 我的 mysql 触发器代码存在语法错误。错误 1064 (42000) :

Question

我有以下触发代码，但它给了我错误。我无法弄清楚我的代码出了什么问题。

    DROP TRIGGER IF EXISTS `user_has_voice_queues_rt_update`;
    CREATE DEFINER=`root`@`localhost` 
    TRIGGER `user_has_voice_queues_rt_update` 
    BEFORE UPDATE ON `user_has_voice_queues_rt` 
    FOR EACH ROW begin 
    if(new.pause='0') then  
    Set new.penalty = (select max(penalty) from user_has_voice_queues_rt) + 1; 
    end if;

Answer 1

试试这个:

DROP TRIGGER IF EXISTS `user_has_voice_queues_rt_update`;
DELIMITER $$

CREATE DEFINER=`root`@`localhost` 
TRIGGER `user_has_voice_queues_rt_update` 
BEFORE UPDATE ON `user_has_voice_queues_rt` 
FOR EACH ROW begin 
if(new.pause='0') then  
Set new.penalty = (select max(penalty) from user_has_voice_queues_rt) + 1; 
end if;

END $$
DELIMITER ;