MySql user variable ignored

Question

The following SQL runs as expected in the workbench, but generates an error "parameter @search must be defined" when I fire it in from a C# application. Can anyone explain this?

set @search = 'b%';
select * from country where Name like @search

How do you "fire it in from a C# application"? Can you show your code please. — PaulF
– PaulF, Commented Nov 8, 2016 at 14:49

Shadow · Accepted Answer · 2016-11-08 14:55:18Z

2

MySQL use the @variable_name expression as a user defined variable. C# (or the provider - not really sure which) on the other hand uses the @parameter_name to annotate parameter placeholder in the query.

If you want to use sql user defined variables, then add the following parameter to the connection string of your .Net connector connection:

Allow User Variables=True

or

AllowUserVariables=True

This option was added to connector v5.2.2

answered Nov 8, 2016 at 14:55

Shadow

34.5k10 gold badges67 silver badges76 bronze badges

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

2 Comments

bbsimonbb Over a year ago

Cool. Is there any reason to not do this? Why is it switched off by default?

Shadow Over a year ago

Since I'm not a developer of MySQL's .net connector, I can only guess that more developers use parameters in the old fashioned @parameter_name convention, than MySQL user defined variables.

Collectives™ on Stack Overflow

MySql user variable ignored

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related