MySQL: Error in MySQL Insert Query

Question

I am new to MySQL. Here is my query:

insert into 'JsonData' values(1,'Article_Type', 'Obama Care', 'Obama care is a system', '2014-2-18', 'www.cnn.com', 'a12as%6adj*&^asah*^')

This generates the below error:

     #1064 - 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 ''JsonData' 
values(1,'Article_Type', 'Obama Care', 'Obama care is a system', '201' at line 1

Following is the table structure:

enter image description here

What is wrong with my query?

You should not be sinlge-quoting the table name `JsonData`. – Michael Berkowski Feb 18 '14 at 18:34 — Michael Berkowski, Feb 18 '14 at 18:34

score 2 · Accepted Answer · answered Feb 18 '14 at 18:34

2

No need for quotes:

insert into JsonData values(1,'Article_Type', 'Obama Care', 'Obama care is a system', '2014-2-18', 'www.cnn.com', 'a12as%6adj*&^asah*^')

However, you can use back ticks if you want (Useful if the table name is some sort of reserved keyword):

insert into `JsonData` values(1,'Article_Type', 'Obama Care', 'Obama care is a system', '2014-2-18', 'www.cnn.com', 'a12as%6adj*&^asah*^')

answered Feb 18 '14 at 18:34

Mike Christensen

82,887
49
201
310

Thanks! This is the answer!!! – PeakGen Feb 18 '14 at 18:36

MySQL: Error in MySQL Insert Query

1 Answers1