MySQL insert json problem

MySQL 5.7.8 and later began to support a native JSON type that can efficiently obtain data in JSON text. This type has the following advantages:

• Automatic verification during storage, error reporting if verification fails
• Better storage structure. An internal structure is used to store JSON text elements that can be read quickly. The new server reads a JSON text in binary format, rather than reading it as a string and then converting it. This binary format allows the server to retrieve sub-objects (nested arrays) by key or array index in text without having to read the entire value.
  

In addition, the system has some restrictions on the JSON format:

• The maximum length of the JSON text depends on the system constant: max_allowed_packet. This value is limited only when the server is storing data. It is allowed to exceed this value when calculating in memory.
• JSON columns cannot have default values
• Like other binary columns, JSON columns cannot be indexed. However, you can create indexes on certain table column values ​​from the text stored in the JSON column. The MySQL optimal controller also queries the index created using the JSON representation.
  

Problems encountered when inserting json data

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 '{

Insert code

insert into `players` (`id`,`player_and_games`) values(1,{
  "id":1,
  "name":"aaa",
  "games_played":{
    "Battlefieldld":{
      "weapon":"adsf",
      "level":20
    },
    "Crazy":{
      "weapon":"adsf",
      "level":20
    }
  }
})

There is a problem, json does not use quotes, the correct way is as follows

insert into `players` (`id`,`player_and_games`) values(1,'{
  "id":1,
  "name":"aaa",
  "games_played":{
    "Battlefieldld":{
      "weapon":"adsf",
      "level":20
    },
    "Crazy":{
      "weapon":"adsf",
      "level":20
    }
  }
}')

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. Thank you for your support of 123WORDPRESS.COM. If you want to learn more about this, please check out the following links