ERROR 1064 (42000): You have an error in your SQL - When trying to insert a response json into my mysql

Asked Aug 14 '18 at 08:01

Active Aug 14 '18 at 08:47

Viewed 373 times

Im trying to insert a response object into MySQL Database, but it fails every time.

INSERT INTO response(`debug_response`) 
VALUES ('
   {
    "STATUS": {"code": 200}, 
    "REQUEST": {"q": "The ABC Murders", "resource": "/sherlock/stores/search.flipkart.com/redirection-store"}, 
    "RESPONSE": {"payloadId": "ca1ef0cb-26fc-44d3-9455-a7c4d093caa9", 
    "metadata": {}, 
    "redirectionStore": "search.flipkart.com", "isRedirection": false}
   }
');

My column debug_response is of type longText.

This is the error I am getting :

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 "REQUEST": {"q": "The ABC Murders", "resource": "/sher' at line 1

edited Aug 14 '18 at 08:47

gil

1,318
12
19

asked Aug 14 '18 at 08:01

Archie

try using NVARCHAR datatype – Derrick Aug 14 '18 at 08:12
1

Are you sure that this exact query goes to MySQL? This one looks totally correct. Could you double check please? Especially, the quote characters. – Ildar Akhmetov Aug 14 '18 at 08:18
1

The query you mentioned should work fine. Have a look :: http://sqlfiddle.com/#!9/ee554f/1. – skelwa Aug 14 '18 at 08:20
Why are you not using the MySQL JSON data type? – Dave Stokes Aug 14 '18 at 13:36

ERROR 1064 (42000): You have an error in your SQL - When trying to insert a response json into my mysql

0 Answers0