MySQL DELIMITER语法错误 [英] MySQL DELIMITER syntax errors
问题描述
此MySQL脚本安装多个触发器.
This MySQL script installs multiple triggers.
它可以在一台运行MySQL 5.0.51b-community的机器上运行.在另一台运行MySQL 14.12 Distrib 5.0.45的计算机上,对于redhat-linux-gnu(i386),它会失败,并显示此错误消息,该错误消息似乎与DELIMITER // ... // DELIMITER
有关;语法:
It works on one machine running MySQL 5.0.51b-community. On another machine running MySQL 14.12 Distrib 5.0.45, for redhat-linux-gnu (i386) it fails, with this error message, which seems to be related to the DELIMITER // ... // DELIMITER
; syntax :
第272行的错误1064(42000):您的SQL语法有错误;检查与您的MySQL服务器版本相对应的手册,以在'DELIMITER附近使用正确的语法;如果存在触发器则触发触发器; DELIMITER"(第1行)
脚本语法(摘要)为:
DROP TRIGGER IF EXISTS trigger_name;
DELIMITER //
CREATE TRIGGER trigger_name BEFORE UPDATE ON table
FOR EACH ROW BEGIN
-- Trigger logic goes here
END //
DELIMITER;
-- More trigger drop/create statements follow
脚本有什么问题,我该如何纠正?
What is wrong with the script, and how can I correct it?
推荐答案
尝试
DELIMITER ;
不是
DELIMITER;
您实际上是将;
指定为DELIMITER
命令的参数,因此,如果没有空格,可能会造成混淆.
You're actually specifying ;
as an argument to the DELIMITER
command, so not having the space there may be confusing it.
这篇关于MySQL DELIMITER语法错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!