centos7 mysql 1064_【mysql报错】1064 - You have an error in your SQL syntax;

mysql 报错1064 - You have an error in your SQL syntax;https://www.cndba.cn/debimeng/article/3198

数据库版本：mysql5.7;系统版本：CentOS Linux7.5

https://www.cndba.cn/debimeng/article/3198

https://www.cndba.cn/debimeng/article/3198https://www.cndba.cn/debimeng/article/3198https://www.cndba.cn/debimeng/article/3198https://www.cndba.cn/debimeng/article/3198

CREATE PROCEDURE pro_dw_gs()

BEGIN

select * from ods_ban_nnn;

END

报错如下：

CREATE PROCEDURE pro_dw_gs()

BEGIN

select * from ods_ban_nnn

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 3

时间: 0.001shttps://www.cndba.cn/debimeng/article/3198

解决：

在存储过程前后添加DELIMITER //和// DELIMITER ;

https://www.cndba.cn/debimeng/article/3198

正确的存储过程为：

https://www.cndba.cn/debimeng/article/3198

DELIMITER //

CREATE PROCEDURE pro_test_nnn()

BEGIN

select * from ods_ban_nnn;

END

//

DELIMITER ;

版权声明：本文为博主原创文章，未经博主允许不得转载。

1064,delimiter