SQL error

Hi folks,

Can anyone please tellme why I get this error:

Could not enter data: 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 ')' at line 1

Using this statement:

Code:

---

INSERT INTO events (start, end) values('2012-12-18 00:00:00','2012-12-20 00:00:00')

---

It enters fine if I insert it using the query panel in MySQL.

Can anyone help?

Many thanks

Just a hunch: try quoting the column names with "back-tick" quotes, in case they are being interpreted as reserved words, e.g.:

Code:

---

INSERT INTO `events` (`start`, `end`) values('2012-12-18 00:00:00','2012-12-20 00:00:00')

---

Quote:

---

Originally Posted by mattastic

It enters fine if I insert it using the query panel in MySQL.

---

Can I ask how / where you are entering it that it is not working? If in an app of some kind (java, php, etc) possibly show the code around where you are executing it and add the query itself to the error message so that you can determine its formatted exactly as you expect it to be.