MySql 中的 DELIMITER 错误

2021-11-11 00:00:00 delimiter mysql ant

我正在使用以下 sql:

I am using the following sql:

DELIMITER $$

DROP PROCEDURE IF EXISTS `get_auto_increment_settings`$$

CREATE PROCEDURE `get_auto_increment_settings`()
BEGIN   
    select @@global.auto_increment_offset as 'offset', @@global.auto_increment_increment as 'increment' ;

END $$
DELIMITER ;

我将它存储在 db_auto_increment_settings_procedure.sql 中，当我尝试从 ant 执行它时，我面临以下错误:

I stored this in db_auto_increment_settings_procedure.sql and when I am trying to execute this from ant, I am facing the following error:

[sql] Executing resource: /mysql/install/db_auto_increment_settings_procedure.sql
[sql] Failed to execute:  DELIMITER
[sql] com.mysql.jdbc.exceptions.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' at line 1
[sql] Failed to execute:  DELIMITER ;
[sql] com.mysql.jdbc.exceptions.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' at line 1

推荐答案

分隔符仅用于 mysql 客户端(不适用于 API、驱动程序等).
所以，这行不通.

The delimiter is used only by mysql client (not on API, driver ... etc).
So, it won't work.

查看您的错误消息:-

[sql] Executing resource: /mysql/install/db_auto_increment_settings_procedure.sql  
[sql] Failed to execute:  DELIMITER

很确定这将在 linux 系统中工作

Pretty sure this will work in linux system

mysql -u root -pxxx -h yyy < YOUR_SQL.sql

如果适用，您只需使用 mysql 客户端手动创建存储过程，
并且是一个没有汗水的解决方案.

If applicable, you just manually create the stored procedure using mysql client,
and is a no-sweat solution.

如果你需要动态创建这个，
该文档可能会提供一些见解信息
http://dev.mysql.com/doc/refman/5.0/en/connector-j-usagenotes-basic.html

If you need to create this dynamically,
this doc might provide some insight information
http://dev.mysql.com/doc/refman/5.0/en/connector-j-usagenotes-basic.html

相关文章