请问这个简短的MySQL触发器语法错在哪里？为何创建时提示出错？

问题描述

问 题

DELIMITER $$

CREATE TRIGGER ad_user AFTER DELETE

ON `user`
FOR EACH ROW BEGIN
    DECLARE max_id INT;
    DECLARE new_id INT;

    SELECT MAX(`id`) INTO max_id FROM `user`;
    IF max_id = NULL THEN
        SET max_id = 0;
    END IF

    SELECT `new_id` INTO new_id FROM `conf` WHERE `table` = 'user';

    IF max_id < new_id THEN
        UPDATE `conf` SET `new_id` = max_id WHERE `table` = 'user';
    END IF
END$$

DELIMITER ;

创建时报错：
Error Code: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT new_id INTO new_id FROM conf WHERE table = 'fact';

    IF max_id < new_id THEN

' at line 12

解决方案

end if;

这篇关于请问这个简短的MySQL触发器语法错在哪里？为何创建时提示出错？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！