MySql存储过程中的错误 [英] error in MySql Stored procedure
本文介绍了MySql存储过程中的错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
ERROR [42000] [MySQL] [ODBC 5.1驱动程序] [mysqld-5.0.77-log] SQL语法中有错误;检查与MySQL服务器版本对应的手册,以便在第1行的InsertProcedure附近使用正确的语法
存储过程:
< pre lang =sql> drop procedure if 存在 insert_pdf_data;
分隔符#
创建 procedure insert_pdf_data
(
BatchName varchar ( 20 ),
ClientNm varchar ( 30 )
)
开始
insert into PdfEntry
(BatchName,ClientNm) values
(BatchName,ClientNm);
end#
delimiter;
c#code:
尝试
{
con = new OdbcConnection( DRIVER = {MySQL ODBC 5.1 Driver}; SERVER = 192.168.0.10; DATABASE = PDF_Data; UID = heman; PASSWORD = harjeet; OPTION = 3) ;
con.Open();
cmd = new OdbcCommand( insert_pdf_data ,con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue( @ BatchName,DDBatch.SelectedValue的ToString());
cmd.Parameters.AddWithValue( @ ClientNm,DDClient.SelectedValue.ToString() );
cmd.ExecuteNonQuery();
con.Close();
Response.Write( < Script> alert('Data added successfully')< ; / SCRIPT>中跨度>);
}
catch (异常错误)
{
}
最后
{
con.Close();
}
解决方案
hi
请使用此lnik我想这会帮助您
www.mysqltutorial.org/stored-procedures-parameters.aspx [ ^ ]
>
http://stackoverflow.com/questions/4391573/mysql-asp-net-存储过程 [ ^ 一>
ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.77-log]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 'InsertProcedure' at line 1
Stored Procedure :
drop procedure if exists insert_pdf_data;
delimiter #
create procedure insert_pdf_data
(
in BatchName varchar(20),
in ClientNm varchar(30)
)
begin
insert into PdfEntry
(BatchName,ClientNm) values
(BatchName,ClientNm);
end#
delimiter ;
c# code :
try
{
con = new OdbcConnection("DRIVER={MySQL ODBC 5.1 Driver};SERVER=192.168.0.10;DATABASE=PDF_Data;UID=heman;PASSWORD=harjeet;OPTION=3");
con.Open();
cmd = new OdbcCommand("insert_pdf_data", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BatchName", DDBatch.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@ClientNm", DDClient.SelectedValue.ToString());
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<Script>alert('Data added successfully')</Script>");
}
catch (Exception err)
{
}
finally
{
con.Close();
}
解决方案
hi
please use this lnik i think this will help you
www.mysqltutorial.org/stored-procedures-parameters.aspx[^]
http://stackoverflow.com/questions/4391573/mysql-asp-net-stored-procedures[^]
这篇关于MySql存储过程中的错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文