What's wrong with my syntax inserting JSON into mysql table?

Question

I have a JSON column and i am using the following syntax...

INSERT INTO myTable (myJSONColumn) VALUES (["test1", "test2", "test3"])

Every resource i can find seems to say the above should be correct. What am i missing?

What makes you think it is wrong? Are you getting an error? If so, it might be helpful if you shared that error with us — CraigR8806
– CraigR8806, Commented May 9, 2017 at 18:59
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 '["string1","string2","string3"])' at line 1 — Ben Arnao
– Ben Arnao, Commented May 9, 2017 at 19:01
Every resource? The offical doc doesn't show this syntax: dev.mysql.com/doc/refman/5.7/en/json.html — arvymetal
– arvymetal, Commented May 9, 2017 at 19:06

maszter · Accepted Answer · 2017-05-09 19:05:01Z

2

You want to insert single value (one column), so put everything in '' like:

INSERT INTO myTable (myJSONColumn) VALUES ('["test1", "test2", "test3"]')

answered May 9, 2017 at 19:05

maszter

3,7206 gold badges40 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks, could have sworn i tried that but now it seems to work.