Why inserting DateTime to MySQL in C# is getting an error?

Question

I Try to insert to MySQL database in C#, but what i got is this error

"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 "insert (NoNota, Nama, Tanggal, Tipe, Keterangan) VALUES ('1111', 'Kickass', '201" at line 1

i think the problem is the DateTime, in my database datatype i set it to DATETIME, Here is my code

        string sqlQuery;

        sqlQuery = "INSERT INTO insert (id, Name, Date, Type, Notes) VALUES ('1111', 'Kickass', '2013-09-09', 'Cash', 'Nothing')";


        if (this.OpenConnection() == true)
        {
            cmd = new MySqlCommand(sqlQuery, connect);
            cmd.ExecuteNonQuery();
            CloseConnection();
            MessageBox.Show("Operation INSERT is SUCCESS!!");
        }

What's wrong with it? i try excute my SQL Queries it work very FINE in MySQL Workbench, it automatically convert the DateTime and insert it into the table. Any clue?

Kevin Seifert · Accepted Answer · 2013-12-22 01:56:06Z

3

insert is a reserved word (INSERT INTO insert). Rename the table or escape with backticks. I'd highly recommend renaming.

answered Dec 22, 2013 at 1:56

Kevin Seifert

3,5921 gold badge21 silver badges14 bronze badges

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

1 Comment

Ke Vin Over a year ago

Ooh! god! ty! Where i can find restricted word for mysql Syntax?

juergen d · Accepted Answer · 2013-12-22 08:13:33Z

0

You need to escape reserved words in MySQL like INSERT with backticks

INSERT INTO `insert` (id, Name, ...
            ^------^---------------------here

But it would be way better to rename your table. insert does not say anything about your data. Try to think of its content. When you have hundreds of tables in a database you need to name every one very carefully to keep track what it contains.

When you name your column, name it after the single word that finishes this sentance:

The data of my table holds ...

answered Dec 22, 2013 at 8:13

juergen d

205k40 gold badges303 silver badges377 bronze badges

Collectives™ on Stack Overflow

Why inserting DateTime to MySQL in C# is getting an error?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related