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

Question

While I am trying to insert a row to my table, I'm getting the following errors:

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 ''filename')  VALUES ('san', 'ss', 1, 1, 1, 1, 2, 1, 1, 'sment', 'notes','sant' at line 1 

please help me out.

mysql> desc risks; +-----------------+--------------+------+-----+---------------------+----------------+ | Field           | Type         | Null | Key | Default             | Extra          | +-----------------+--------------+------+-----+---------------------+----------------+ | id              | int(11)      | NO   | PRI | NULL                | auto_increment | | status          | varchar(20)  | NO   |     | NULL                |                | | subject         | varchar(100) | NO   |     | NULL                |                | | reference_id    | varchar(20)  | NO   |     |                     |                | | location        | int(11)      | NO   |     | NULL                |                | | category        | int(11)      | NO   |     | NULL                |                | | team            | int(11)      | NO   |     | NULL                |                | | technology      | int(11)      | NO   |     | NULL                |                | | owner           | int(11)      | NO   |     | NULL                |                | | manager         | int(11)      | NO   |     | NULL                |                | | assessment      | longtext     | NO   |     | NULL                |                | | notes           | longtext     | NO   |     | NULL                |                | | submission_date | timestamp    | NO   |     | CURRENT_TIMESTAMP   |                | | last_update     | timestamp    | NO   |     | 0000-00-00 00:00:00 |                | | review_date     | timestamp    | NO   |     | 0000-00-00 00:00:00 |                | | mitigation_id   | int(11)      | NO   |     | NULL                |                | | mgmt_review     | int(11)      | NO   |     | NULL                |                | | project_id      | int(11)      | NO   |     | 0                   |                | | close_id        | int(11)      | NO   |     | NULL                |                | | submitted_by    | int(11)      | NO   |     | 1                   |                | | filename        | varchar(30)  | NO   |     | NULL                |                | +-----------------+--------------+------+-----+---------------------+----------------+ 21 rows in set (0.00 sec)  **mysql> INSERT INTO risks (`status`, `subject`, `reference_id`, `location`, `category`, `team`, `technology`, `owner`, `manager`, `assessment`, `notes`,'filename')     VALUES  ('san', 'ss', 1, 1, 1, 1, 2, 1, 1, 'sment', 'notes','santu');**  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 ''filename')  VALUES ('san', 'ss', 1, 1, 1, 1, 2, 1, 1, 'sment', 'notes','sant' at line 1 

Answer 1

There are two different types of quotation marks in MySQL. You need to use ` for column names and ' for strings. Since you have used ' for the filename column the query parser got confused. Either remove the quotation marks around all column names, or change 'filename' to `filename`. Then it should work.