MYSQL SQL syntax error c#

Question

I have an error in my SQL statement. This is the query:

 MySqlCommand cmd = new MySqlCommand("insert into bills (bill_Number,bill_Date,bill_From,bill_Note,bill_TaxRate,bill_DisRate,bill_EntryDate,cus_Sup,by,archived) values(" + txbBillNumber.Text + ",'" + DateTime.Parse(txbBillDate.Text).Year + "-" + DateTime.Parse(txbBillDate.Text).Month + "-" + DateTime.Parse(txbBillDate.Text).Day + "'," + sup_Id + ",'" + txb_Note.Text + "'," + taxRate + "," + disRate + ",'" + DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day + "'," + Bills.cus_Sup + ",0,0)", objConn);
                        cmd.ExecuteNonQuery();

And in this image the error and the bills table structure: Screebshot1

Community · Accepted Answer · 2017-05-23 12:24:20Z

4

One problem is that the word by that you use as a column is a reserved keyword (both in MySQL and the SQL standard in general). To use it you have to enclose it in backticks `` or double-quotes " ".

Also, the string values need to be between single-quotes where applicable, but I think you got that.

On a side note you should look into using parametrized queries instead of concatenating. See this question for an example: C# with MySQL INSERT parameters

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered Jul 2, 2015 at 0:54

jpw

45k6 gold badges71 silver badges90 bronze badges

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

Comments

bluemax · Accepted Answer · 2015-07-02 00:54:25Z

1

Your string values must be enclosed in quotes in the SQL statement, like this: MySqlCommand cmd = new MySqlCommand("insert into bills (bill_Number,bill_Date,bill_From,bill_Note,bill_TaxRate,bill_DisRate,bill_EntryDate,cus_Sup,by,archived) values(\"" + txbBillNumber.Text + "\"...

answered Jul 2, 2015 at 0:54

bluemax

512 bronze badges

Comments

jmcclure · Accepted Answer · 2015-07-02 00:59:48Z

0

My first thoughts is that "by" is a reserved word, and "by" needs to be encapsulated in single/double quotes...whatever mysql requires. This is from sql server experience.

answered Jul 2, 2015 at 0:59

jmcclure

12211 bronze badges

Collectives™ on Stack Overflow

MYSQL SQL syntax error c#

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related