mysql jdbc 创建触发器的问题
想用mysql 的jdbc创建一个触发器,结果报错。不知道哪里错了,请各位大神指点一下吧
以下是错误信息:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'DELIMITER $$
DROP TRIGGER IF EXISTS INSERTMYTRIPLES2LOG;
CREATE TRIGGER INSERTMY' at line 1
下面是要执行的sql语句
DELIMITER $$
DROP TRIGGER IF EXISTS INSERTMYTRIPLES2LOG;
CREATE TRIGGER INSERTMYTRIPLES2LOG
BEFORE INSERT ON MYTRIPLES
FOR EACH ROW
BEGIN
... // 省略
END;$$
DELIMITER ;