MYSQL - Insert statement with syntax Error

Question

I have following table setup.

+-------------+---------+------+-----+---------+----------------+
| Field       | Type    | Null | Key | Default | Extra          |
+-------------+---------+------+-----+---------+----------------+
| id          | int(11) | NO   | PRI | NULL    | auto_increment |
| date        | date    | YES  |     | NULL    |                |
| limit       | int(11) | YES  |     | NULL    |                |
| contract_id | int(11) | YES  |     | NULL    |                |
+-------------+---------+------+-----+---------+----------------+

And this insert query

INSERT INTO userlimit (date, limit, contract_id) VALUES (now(), 10, 1);

Always when I want to execute it I receive following error

ERROR 1064 (42000): 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 'limit, contract_id) VALUES (now(), 10, 1)' at line 1

My syntax looks perfectly fine to me. Why do I get this Error?

`LIMIT` is a [MySQL reserved keyword](https://dev.mysql.com/doc/refman/5.5/en/reserved-words.html). When using it as a table/column name you must quote it with backticks. — Michael Berkowski, Apr 17 '15 at 14:22
Note that `date` is _not_ reserved. `limit` is though. Requires quoting as `\`limit\`` — Michael Berkowski, Apr 17 '15 at 14:23

score 2 · Accepted Answer · answered Apr 17 '15 at 14:22

2

You need to quote field names with backticks

INSERT INTO userlimit (`date`, `limit`, `contract_id`) VALUES (now(), 10, 1)

answered Apr 17 '15 at 14:22

Ivan Solntsev

2,081
2
31
40

3

Note that it is not needed for all fields, but only for the limit which ia reserved keywords. – Jean-François Savard Apr 17 '15 at 14:22
4

^^ And `date` isn't actually reserved. – Michael Berkowski Apr 17 '15 at 14:23
@Jean-FrançoisSavard, yes, only reserved words require quotes, but for uniformity I quoted all – Ivan Solntsev Apr 17 '15 at 14:25
@IbrahimApachi better late than never :) – Ivan Solntsev Nov 30 '15 at 09:18

MYSQL - Insert statement with syntax Error

1 Answers1