Is there a way to use the @ character in a MySQL query from a C# .net program without using parametrised queries?

Question

So for example in the following program

String s = 
@"LOAD DATA LOCAL INFILE C:\foo.txt'  
INTO TABLE Bar
(idFoo, @baa)
SET  
baa = nullif(@baa,'')
";
MySqlCommand myCommand = new MySqlCommand(s, myConnection);
MySqlDataReader myReader = myCommand.ExecuteReader();

@baa is treated like a parameter. ie: as one would use when calling

myCommand.Parameters.Add("@baa", SqlDbType.VarChar );

However in this case I do not want @baa to be a parameter. How do I write this?

just dont add the parameter, it will be treated as normal text! — Parimal Raj
– Parimal Raj, Commented Apr 26, 2013 at 1:36
I think last time I didn't provide the parameter I got an error.. — Ruly
– Ruly, Commented Apr 26, 2013 at 1:38
try @@ or \@ one of them must escape it. i do not have mysql installed that i can test. — Parimal Raj
– Parimal Raj, Commented Apr 26, 2013 at 1:39
Just figured it out now, I needed to add "allow user variables" to the connection string — sav
– sav, Commented Apr 26, 2013 at 1:48
although, as I have framed my question, you have given the correct answer — sav
– sav, Commented Apr 26, 2013 at 1:50

Corey · Accepted Answer · 2013-04-26 01:52:17Z

1

MySQL uses the back-tick character to quote tokens with spaces or other special characters. This is used for example to handle field names with spaces, etc.

So in your code, where you want @baa to refer to a field name, place back-tick characters around the name like so: `@baa`

answered Apr 26, 2013 at 1:52

Corey

16.6k2 gold badges38 silver badges76 bronze badges

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

4 Comments

sav Over a year ago

already tried that, I needed to add allow user variables to the connection string

Corey Over a year ago

That wasn't clear from the question. What exactly are you trying to achieve?

sav Over a year ago

Loading the data into a table, was originally doing this with insert statements except it took too long (about an hour). It only takes a few seconds now.

Corey Over a year ago

@sav Have you tried the SqlBulkCopy class? I've used it to insert thousands of records in well under a second. Check out this blog: adathedev.co.uk/2010/02/…

Collectives™ on Stack Overflow

Is there a way to use the @ character in a MySQL query from a C# .net program without using parametrised queries?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related