Insert a simple JSON

suggest change
INSERT INTO
    table_name (json_col) 
VALUES
    ('{"City": "Galle", "Description": "Best damn city in the world"}');

That’s simple as it can get but note that because JSON dictionary keys have to be surrounded by double quotes the entire thing should be wrapped in single quotes. If the query succeeds, the data will be stored in a binary format.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:



Table Of Contents