php - MySql 触发器不工作，语法错误

Question

我尝试创建以下触发器，但它不起作用:

delimiter //
CREATE TRIGGER DeleteFeature
AFTER DELETE ON Features
FOR EACH ROW BEGIN        
    IF (OLD.FeatureID IN (SELECT FeatureID FROM GroupFeatures)) THEN
      INSERT INTO DeletedFeatures VALUES (OLD.FeatureID, OLD.FeatureName, OLD.FeatureDescription);
    END IF;
END; 
//

出现以下错误:

“#1064 - 您的 SQL 语法有错误；请检查与您的 MySQL 服务器版本相对应的手册，了解第 8 行‘//’附近使用的正确语法”

知道问题可能是什么吗？

Answer 1

您是否通过删除分号并在 END 后添加 $$ 进行检查

DELIMITER $$
CREATE TRIGGER DeleteFeature
AFTER DELETE ON Features
FOR EACH ROW 
  BEGIN        
    IF (OLD.FeatureID IN (SELECT FeatureID FROM GroupFeatures)) THEN
      INSERT INTO DeletedFeatures VALUES (OLD.FeatureID, OLD.FeatureName OLD.FeatureDescription);
    END IF;
  END $$
DELIMITER ;