How to define a table to store JSON objects in MySQL database?

Question

I want to store a JSON object in MySQL database(using xampp with mariadb). What should be the data type to store? It gives error if 'json' is used as data type.

There is no such thing as a "json object". JSON is a string, it is a format that represents arbitrary data as a string. Therefore you simply use a varchar or text type in a relational database. — arkascha
– arkascha, Commented Jan 26, 2017 at 14:55
Hi @arkascha you might want to look at dev.mysql.com/doc/refman/5.7/en/json.html — RiggsFolly
– RiggsFolly, Commented Jan 26, 2017 at 15:03
But yes, as arkascha said, JSON data type is not a thing in MariaDB yet, but MySQL supports that as RiggsFolly mentioned — Balazs Vago
– Balazs Vago, Commented Jan 26, 2017 at 15:06
"As of MySQL 5.7.8, MySQL supports a native JSON data type": dev.mysql.com/doc/refman/5.7/en/json.html — DivergentSpaceTimeWanderer
– DivergentSpaceTimeWanderer, Commented Jul 19, 2017 at 10:49

Sidath Munasinghe · Accepted Answer · 2017-01-26 15:47:01Z

7

Solution is to convert json to string and save as text and re-convert to json after retrieving from database

answered Jan 26, 2017 at 15:47

Sidath Munasinghe

3595 silver badges19 bronze badges

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

Comments

Kunal · Accepted Answer · 2017-01-26 14:56:52Z

0

Refer this ... this might help!

https://www.sitepoint.com/use-json-data-fields-mysql-databases/

P.S: Postgres have better features to store json data compared to mysql or mariaDB

answered Jan 26, 2017 at 14:56

Kunal

314 bronze badges

Collectives™ on Stack Overflow

How to define a table to store JSON objects in MySQL database?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related