mysql操作json优点和缺点_MYSQL 5.7中的原生JSON支持：MYSQL中JSON数据类型的优缺点是什么？...

以下从

MySQL 5.7 brings sexy back with JSON对我来说听起来不错：

Using the JSON Data Type in MySQL comes with two advantages over

storing JSON strings in a text field:

Data validation. JSON documents will be automatically validated and

invalid documents will produce an error. Improved internal storage

format. The JSON data is converted to a format that allows quick read

access to the data in a structured format. The server is able to

lookup subobjects or nested values by key or index, allowing added

flexibility and performance.

… …

Specialised flavours of NoSQL stores

(Document DBs, Key-value stores and Graph DBs) are probably better

options for their specific use cases, but the addition of this

datatype might allow you to reduce complexity of your technology

stack. The price is coupling to MySQL (or compatible) databases. But

that is a non-issue for many users.

注意文档验证的语言，因为它是一个重要因素。我猜想需要进行一系列的测试来比较这两种方法。这两个是：

>使用JSON数据类型的Mysql

> Mysql没有

从现在起，我看到的是mysql / json / performance的话题。

也许你的帖子可以成为它的中心。或者表演是一个后来的想法，不确定，你只是兴奋不要创建一堆桌子。