Excepion with MysqlCommand and "SET @q:" variable C#?

Question

i have this code:

using (MySql.Data.MySqlClient.MySqlConnection cn = new   
MySql.Data.MySqlClient.MySqlConnection(
            Properties.Settings.Default.CONNNConnectionString))
        {
            cn.Open();
            MySql.Data.MySqlClient.MySqlCommand cm = new 
            MySql.Data.MySqlClient.MySqlCommand();
            cm.CommandType = CommandType.Text;
            cm.Connection = cn;
cm.CommandText="CREATE  PROCEDURE `GetMovement`(RefArtt vARCHAR(20),idos INTEGER) "+
"BEGIN "+
"SET @Qt=0; "SELECT * ,@Qt:=@Qt+qteliv-qtesor as stock FROM tableInOut;"+
"End";
cm.ExecuteNonQuery();}

Exception : 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 ''@Qt'=0; SELECT * ...

have you declared @Qt?

DidIReallyWriteThat
– DidIReallyWriteThat

2014-10-07 13:22:21 +00:00
Commented Oct 7, 2014 at 13:22 — DidIReallyWriteThat
– DidIReallyWriteThat, Commented Oct 7, 2014 at 13:22

nesreen · Accepted Answer · 2014-10-07 13:39:46Z

0

Union should to write the same names or alias So, you can modify the alias to be the same in two select statement

answered Oct 7, 2014 at 13:39

nesreen

2012 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Boubaker Bousbia Brahim Over a year ago

i added the query as procedure and then call it from c# code it work.

Collectives™ on Stack Overflow

Excepion with MysqlCommand and "SET @q:" variable C#?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related