在我的SQL中创建存储过程时收到错误 [英] While creating the stored procedure getting error in my SQL

问题描述

我是mysql的新手我已经创建了存储过程但是获得了＃1064 - 你的SQL语法有错误;检查与你的MySQL服务器版本相对应的手册，以便在第29行的''附近使用正确的语法。我在最后一行收到错误。我检查了这行代码检查器。但它显示代码看起来很好。我被困了以后昨天请帮帮我。

提前致谢。



我尝试了什么：

I'm new to mysql i have created stored procedure but getting #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 29.I am getting error in last line.I have checked this line code checker .But it showing code looks fine.I was stucked since yesterday Please help me on this.
Thanks in advance.

What I have tried:

  create procedure InsertOrgDetails(
 IN bbnk_Name varchar(100),
 IN bbnk_Sname varchar(5),
 IN bbnk_Adrsln1 varchar(80),
 IN bbnk_Adrsln2 varchar(80),
 IN bbnk_Adrsln3 varchar(80),
 IN bbnk_Adrscty varchar(50),
 IN bbnk_Adrspin varchar(6),
 IN bbnk_Adrstate varchar(50),
 IN bbnk_Tlphn1 varchar(20))
 BEGIN
Insert into Organization(bbnk_Name,
bbnk_Sname,
bbnk_Adrsln1,
bbnk_Adrsln2,
bbnk_Adrsln3,
bbnk_Adrscty,
bbnk_Adrsp,
bbnk_Adrstate,
bbnk_Tlphn1)
VALUES(bbnk_Name,
bbnk_Sname,
bbnk_Adrsln1,
bbnk_Adrsln2,
bbnk_Adrsln3,
bbnk_Adrscty,
bbnk_Adrsp,
bbnk_Adrstate,
bbnk_Tlphn1);
END

推荐答案

更改名称您的参数或表格列不匹配。

目前，您正在做的说法是：

Change the names of your parameters or table columns so that they don't match.
At the moment, you are doing the equivelant of saying:

INSERT INTO Tab (X) VALUES (X);

因此系统无法判断您要执行的操作。你需要更接近的东西：

So the system can't tell what you are trying to do. You need something closer to:

INSERT INTO Tab (X) VALUES (paramX);

这篇关于在我的SQL中创建存储过程时收到错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！