我在.Net下写的程序.现在要用 放在Liunk下的MySQL5.0的存贮过程.现存贮过程不能执行.提示错误:
"ERROR [HY000] [MySQL][MyODBC 05.00.0000][MySQL] 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 'InsterNo' at line 1".
请用过MySQL数据库的高手给看一下是什么原因.解决给分!谢了
我的代码如下:
try
{
OdbcCommand myCommand = new OdbcCommand("InsterNo",odb);
odb.Open();
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.ExecuteNonQuery();
}
catch(Exception MySql)
{
MessageBox.Show(MySql.Message);
}
finally
{
odb.Close();
}
"ERROR [HY000] [MySQL][MyODBC 05.00.0000][MySQL] 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 'InsterNo' at line 1".
请用过MySQL数据库的高手给看一下是什么原因.解决给分!谢了
我的代码如下:
try
{
OdbcCommand myCommand = new OdbcCommand("InsterNo",odb);
odb.Open();
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.ExecuteNonQuery();
}
catch(Exception MySql)
{
MessageBox.Show(MySql.Message);
}
finally
{
odb.Close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货