mysql 查询语句问题 set @Id := 9;select * from `table` WHERE `Id`=@Id;
set @Id := 9;select * from `table` WHERE `Id`=@Id;该句在mysql中执行正确。
但是用.net封装的数据库对象执行就出现异常:
cmd.commandtext = sql语句;
cmd.commandtype = commandtype.text;
cmd.ExecuteScalar();//这样的话在执行的时候会出错。
异常信息为:
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
ps,mssql类似的有变量的sql语句通过.net是可以执行成功的,但是mysql有变量的查询在.net中却不能执行成功,是不是.net不支持mysql包含变量的sql语句啊?!