c＃连接器问题中的赋值运算符 [英] Assignment Operators in c# connector problem

问题描述

如果我在Query Brower中运行查询是好的

 选择 @ var1：= @ var1 + 1 RANK， @ var2  TEST，
 a.COD，A.NAME 来自 arts a，
（ SELECT  @ var1：= 0，@ var2：= '   TEST'）r 

但在c＃我得到了...

命令执行期间遇到致命错误。

我认为这被解释为参数而不是作为赋值运算符

http://dev.mysql.com/doc/refman/5.1/en/assignment-operators.html [ ^ ]



怎么能我解决了吗？

解决方案

使用允许用户变量= true;在连接字符串:)

由我解决！

if i run the query in Query Brower is OK

select @var1:=@var1+1 RANK,@var2 TEST,
a.COD,A.NAME from arts a,
(SELECT @var1:=0 , @var2:='TEST') r

but in c# i got...

Fatal error encountered during command execution.

I think that is interpreted as parameters and not as Assignment Operators
http://dev.mysql.com/doc/refman/5.1/en/assignment-operators.html[^]

how can I fix that?

解决方案

Use "Allow User Variables=true;" in connection strings :)
Solved by me!

这篇关于c＃连接器问题中的赋值运算符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！