mysql - MySQL 创建触发器时出错

Question

每次尝试在其中一个表中创建一个 UPDATE 触发器时，我都会遇到奇怪的错误...

触发器:

CREATE TRIGGER upd_data_nascimento BEFORE UPDATE ON pfi_pessoa_fisica
FOR EACH ROW
  BEGIN
     IF OLD.date_of_birth = '0000-00-00' THEN
     SET NEW.date_of_birth = NULL;
     END IF;
  END;

错误:

Error SQL (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 '' at line 5

有什么想法吗？

Answer 1

确保您使用分隔符

CREATE TRIGGER upd_data_nascimento BEFORE UPDATE ON abc_table
FOR EACH ROW
  BEGIN
     IF OLD.date_of_birth = '0000-00-00' THEN
        SET NEW.date_of_birth = NULL;
     END IF;
  END

如果您在 PHPMyAdmin 中执行它，请将分隔符设置为 # 或其他值。然后执行它就可以正常工作我已经用上面的代码测试了它。