创建MySQL Delete触发器错误

Question

我使用这个来防止任何从MySQL表user

删除

delimiter //
CREATE TRIGGER tr_no_del BEFORE DELETE on user
FOR EACH ROW SET
BEGIN
    UPDATE user SET a=0;
END;//
delimiter ;

但是mysql给出了一些语法错误，任何想法我在这里错过了什么?

谢谢!

Answer 1

试试这个

DELIMITER //
DROP TRIGGER IF EXISTS tr_no_del//
CREATE TRIGGER tr_no_del BEFORE DELETE ON `user`
FOR EACH ROW 
BEGIN
    UPDATE USER SET a=0;
END;//
DELIMITER ;