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