mysql中,通過json_insert函數向json欄位插入索引值?json_insert函數的使用?

標籤：where   set   change   ike   索引值   query   address   from   update   

需求描述:

　　通過json_insert向json欄位中插入值,在此進行實驗,記錄下.

操作過程:

1.查看已經有的包含json資料類型的表

mysql> select * from tab_json;+----+------------------------------------------------------------------------------------------------+| id | data                                                                                           |+----+------------------------------------------------------------------------------------------------+|  1 | {"age": "33", "tel": 13249872314, "name": "Mike", "address": "Shenzhen", "passcode": "654567"} ||  2 | {"age": "33", "tel": 189776542, "name": "David", "olds": "12", "address": "Hangzhou"}          |+----+------------------------------------------------------------------------------------------------+2 rows in set (0.00 sec)

2.通過json_insert來插入值

mysql> update tab_json set data = json_insert(data,"$.age","22") where id = 1;  #對一個已經存在的key進行操作,值沒有變化Query OK, 0 rows affected (0.00 sec)Rows matched: 1  Changed: 0  Warnings: 0mysql> select * from tab_json;+----+------------------------------------------------------------------------------------------------+| id | data                                                                                           |+----+------------------------------------------------------------------------------------------------+|  1 | {"age": "33", "tel": 13249872314, "name": "Mike", "address": "Shenzhen", "passcode": "654567"} ||  2 | {"age": "33", "tel": 189776542, "name": "David", "olds": "12", "address": "Hangzhou"}          |+----+------------------------------------------------------------------------------------------------+2 rows in set (0.00 sec)mysql> update tab_json set data = json_insert(data,"$.CARD","1989833333") where id = 1;  #對不存在的key進行操作,結果是增加了key-value值Query OK, 1 row affected (0.01 sec)Rows matched: 1  Changed: 1  Warnings: 0mysql> select * from tab_json;+----+----------------------------------------------------------------------------------------------------------------------+| id | data                                                                                                                 |+----+----------------------------------------------------------------------------------------------------------------------+|  1 | {"age": "33", "tel": 13249872314, "CARD": "1989833333", "name": "Mike", "address": "Shenzhen", "passcode": "654567"} ||  2 | {"age": "33", "tel": 189776542, "name": "David", "olds": "12", "address": "Hangzhou"}                                |+----+----------------------------------------------------------------------------------------------------------------------+2 rows in set (0.00 sec)

備忘:所以json_insert函數的作用就是插入,插入不存在的索引值對,如果對於一個已經存在的key進行操作是沒有變化的

 

文檔建立時間:2018年6月5日22:06:43

mysql中,通過json_insert函數向json欄位插入索引值?json_insert函數的使用?