欧美bbbwbbbw肥妇,免费乱码人妻系列日韩,一级黄片

mysql中的json處理方案

 更新時(shí)間：2023年08月01日 10:32:21   作者：一戶董  
這篇文章主要介紹了mysql中的json處理方案,本文通過(guò)實(shí)例代碼給大家介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或工作具有一定的參考借鑒價(jià)值，需要的朋友可以參考下

寫在前面

需要注意，5.7以上版本才支持，但如果是生產(chǎn)環(huán)境需要使用的話，盡量使用8.0版本，因?yàn)?.0版本對(duì)json處理做了比較大的性能優(yōu)化。你你可以使用select version();來(lái)查看版本信息。

本文看下MySQL的json處理。在正式開始讓我們先來(lái)準(zhǔn)備一些測(cè)試數(shù)據(jù)：

CREATE TABLE `dept` (
  `id` int(11) NOT NULL,
  `dept` varchar(255) DEFAULT NULL,
  `json_value` json DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into dept VALUES(1,'部門1','{"deptName": "部門1", "deptId": "1", "deptLeaderId": "3"}');
insert into dept VALUES(2,'部門2','{"deptName": "部門2", "deptId": "2", "deptLeaderId": "4"}');
insert into dept VALUES(3,'部門3','{"deptName": "部門3", "deptId": "3", "deptLeaderId": "5"}');
insert into dept VALUES(4,'部門4','{"deptName": "部門4", "deptId": "4", "deptLeaderId": "5"}');
insert into dept VALUES(5,'部門5','{"deptName": "部門5", "deptId": "5", "deptLeaderId": "5"}');

1：json字段名->’$.json屬性’

通過(guò)json字段名->’$.json屬性’語(yǔ)法格式可以訪問到j(luò)son中某個(gè)key的值，以如下查詢方式看下。

1.1：用在DQL查詢結(jié)果中

mysql> select id,json_value->'$.deptLeaderId' from dept where id=2;
+----+------------------------------+
| id | json_value->'$.deptLeaderId' |
+----+------------------------------+
|  2 | "4"                          |
+----+------------------------------+
1 row in set (0.01 sec)

1.2：用在DQL條件中

單條件

mysql> select id from dept where json_value->'$.deptLeaderId'='4';
+----+
| id |
+----+
|  2 |
+----+
1 row in set (0.01 sec)

和普通字段組合查詢

mysql> select id from dept where json_value->'$.deptLeaderId'='4' and id>1;
+----+
| id |
+----+
|  2 |
+----+
1 row in set (0.01 sec)

json多條件

mysql> select id from dept where json_value->'$.deptLeaderId'='4' and json_value->'$.deptName' like '%部門%';
+----+
| id |
+----+
|  2 |
+----+
1 row in set (0.00 sec)

1.3：用在DQL關(guān)聯(lián)查詢中

先準(zhǔn)備數(shù)據(jù)：

CREATE TABLE `dept_leader` (
  `id` int(11) NOT NULL,
  `leaderName` varchar(255) DEFAULT NULL,
  `json_value` json DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into dept_leader VALUES(1,'leader1','{"name": "王一", "id": "1", "leaderId": "1"}');
insert into dept_leader VALUES(2,'leader2','{"name": "王二", "id": "2", "leaderId": "3"}');
insert into dept_leader VALUES(3,'leader3','{"name": "王三", "id": "3", "leaderId": "4"}');
insert into dept_leader VALUES(4,'leader4','{"name": "王四", "id": "4", "leaderId": "5"}');
insert into dept_leader VALUES(5,'leader5','{"name": "王五", "id": "5", "leaderId": "5"}');

關(guān)聯(lián)查詢

mysql> SELECT dept.id,dept_leader.id from dept,dept_leader WHERE dept.json_value->'$.deptLeaderId'=dept_leader.json_value->'$.id' ;
+----+----+
| id | id |
+----+----+
|  1 |  3 |
|  2 |  4 |
|  3 |  5 |
|  4 |  5 |
|  5 |  5 |
|  6 |  5 |
|  7 |  5 |
|  8 |  5 |
+----+----+
8 rows in set (0.00 sec)

2：json_extract

語(yǔ)法格式json_extract(字段名,$.json字段名),用來(lái)從json字段中提取值，如下：

mysql> select id,json_extract(json_value,'$.deptName') as deptName from dept;
+----+------------------------------+
| id | deptName                     |
+----+------------------------------+
|  1 | "部門1"                      |
...
mysql> SELECT * FROM dept WHERE JSON_EXTRACT(json_value,'$.deptName') like '%部門%'\G
*************************** 1. row ***************************
        id: 1
      dept: 部門1
json_value: {"deptId": "1", "deptName": "部門1", "deptLeaderId": "3"}
*************************** 2. row ***************************
        id: 2
      dept: 部門2
json_value: {"deptId": "2", "newData": "新增的數(shù)據(jù)", "deptName": "新增的部門1111", "deptLeaderId": "4"}
...cx

3：JSON_OBJECT()

語(yǔ)法格式JSON_OBJECT(k,v[,k,v]),用來(lái)轉(zhuǎn)換指定數(shù)據(jù)為json object,如下：

mysql> select json_object("name", "張三", "age", 99);
+------------------------------------------+
| json_object("name", "張三", "age", 99)   |
+------------------------------------------+
| {"age": 99, "name": "張三"}              |
+------------------------------------------+
1 row in set (0.01 sec)

4：JSON_CONTAINS()

語(yǔ)法JSON_CONTAINS(target, candidate[, path])，用來(lái)判斷json格式中是否包含指定子對(duì)象，其中子對(duì)象需要通過(guò)json_object()生成，如下：

mysql> select * from dept WHERE JSON_CONTAINS(json_value, JSON_OBJECT("deptName","部門5"))
    -> ;
+----+---------+-------------------------------------------------------------+
| id | dept    | json_value                                                  |
+----+---------+-------------------------------------------------------------+
|  5 | 部門5   | {"deptId": "5", "deptName": "部門5", "deptLeaderId": "5"}   |
+----+---------+-------------------------------------------------------------+
1 row in set (0.01 sec)

注意需要使用json_object轉(zhuǎn)換為object。

添加如下數(shù)據(jù)，看一個(gè)嵌套json對(duì)象的例子：

insert into dept VALUES(6,'部門9','{"deptName": {"dept":"de","depp":"dd"}, "deptId": "5", "deptLeaderId": "5"}');

判斷嵌套對(duì)象是否存在：

mysql> SELECT * from dept WHERE JSON_CONTAINS(json_value->'$.deptName',JSON_OBJECT("depp","dd"));
+----+---------+--------------------------------------------------------------------------------+
| id | dept    | json_value                                                                     |
+----+---------+--------------------------------------------------------------------------------+
|  6 | 部門9   | {"deptId": "5", "deptName": {"depp": "dd", "dept": "de"}, "deptLeaderId": "5"} |
+----+---------+--------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT * from ( SELECT *,json_value->'$.deptName' as deptName FROM dept ) t WHERE JSON_CONTAINS(deptName,JSON_OBJECT("depp","dd"));
...

5：JSON_ARRAY()

創(chuàng)建json數(shù)組，如下：

mysql> select json_array("pingpong","羽毛球","籃球");
+---------------------------------------------+
| json_array("pingpong","羽毛球","籃球")      |
+---------------------------------------------+
| ["pingpong", "羽毛球", "籃球"]              |
+---------------------------------------------+
mysql> select json_array(json_object("name", "張三"), "籃球", json_object("name", "李四"));
+------------------------------------------------------------------------------------+
| json_array(json_object("name", "張三"), "籃球", json_object("name", "李四"))       |
+------------------------------------------------------------------------------------+
| [{"name": "張三"}, "籃球", {"name": "李四"}]                                       |
+------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

json格式化看下：

在這里插入圖片描述

5.1：判斷數(shù)組是否是否包含某子數(shù)組

準(zhǔn)備數(shù)據(jù)：

insert into dept VALUES(7,'部門9','{"deptName": ["1","2","3"], "deptId": "5", "deptLeaderId": "5"}');
insert into dept VALUES(7,'部門9','{"deptName": ["5","6","7"], "deptId": "5", "deptLeaderId": "5"}');
mysql> SELECT * from dept WHERE JSON_CONTAINS(json_value->'$.deptName',JSON_ARRAY("1"));
+----+---------+-------------------------------------------------------------------+
| id | dept    | json_value                                                        |
+----+---------+-------------------------------------------------------------------+
|  7 | 部門9   | {"deptId": "5", "deptName": ["1", "2", "3"], "deptLeaderId": "5"} |
+----+---------+-------------------------------------------------------------------+
1 row in set (0.05 sec)

6：JSON_TYPE()

獲取類型：

mysql> SELECT json_value->'$.deptName' ,JSON_TYPE(json_value->'$.deptName') as type from dept;  
+------------------------------+--------+
| json_value->'$.deptName'     | type   |
+------------------------------+--------+
| "部門1"                      | STRING |
| "新增的部門1111"             | STRING |
| "部門3"                      | STRING |
| "部門4"                      | STRING |
| "部門5"                      | STRING |
| {"depp": "dd", "dept": "de"} | OBJECT |
| ["1", "2", "3"]              | ARRAY  |
| ["5", "6", "7"]              | ARRAY  |
+------------------------------+--------+

7：JSON_KEYS()

獲取文檔中所有的key，如下：

mysql> SELECT JSON_KEYS(json_value),json_value FROM dept where id=2\G
*************************** 1. row ***************************
JSON_KEYS(json_value): ["deptId", "newData", "deptName", "deptLeaderId"]
           json_value: {"deptId": "2", "newData": "新增的數(shù)據(jù)", "deptName": "新增的部門1111", "deptLeaderId": "4"}
1 row in set (0.01 sec)

8：JSON_SET()

更新或者是添加kv，無(wú)責(zé)插入，有則更新，語(yǔ)法格式JSON_SET(json_doc, path, val[, path, val] …),如下：

key存在時(shí)更新

mysql> select * from dept where id=1;
+----+---------+-------------------------------------------------------------+
| id | dept    | json_value                                                  |
+----+---------+-------------------------------------------------------------+
|  1 | 部門1   | {"deptId": "1", "deptName": "部門1", "deptLeaderId": "3"}   |
+----+---------+-------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> update dept set json_value=JSON_SET(json_value, '$.deptName', '部門1_更新后') where id=1;
Query OK, 1 row affected (0.02 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> select * from dept where id=1;
+----+---------+-----------------------------------------------------------------------+
| id | dept    | json_value                                                            |
+----+---------+-----------------------------------------------------------------------+
|  1 | 部門1   | {"deptId": "1", "deptName": "部門1_更新后", "deptLeaderId": "3"}      |
+----+---------+-----------------------------------------------------------------------+
1 row in set (0.00 sec)

key不存在時(shí)插入

mysql> select * from dept where id=1;
+----+---------+-----------------------------------------------------------------------+
| id | dept    | json_value                                                            |
+----+---------+-----------------------------------------------------------------------+
|  1 | 部門1   | {"deptId": "1", "deptName": "部門1_更新后", "deptLeaderId": "3"}      |
+----+---------+-----------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> update dept set json_value=JSON_SET(json_value, '$.deptAddr', '贏創(chuàng)動(dòng)力4樓') where id=1;
Query OK, 1 row affected (0.03 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> select * from dept where id=1;
+----+---------+-------------------------------------------------------------------------------------------------------+
| id | dept    | json_value                                                                                            |
+----+---------+-------------------------------------------------------------------------------------------------------+
|  1 | 部門1   | {"deptId": "1", "deptAddr": "贏創(chuàng)動(dòng)力4樓", "deptName": "部門1_更新后", "deptLeaderId": "3"}           |
+----+---------+-------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

一個(gè)key不存在，一個(gè)key存在

mysql> select * from dept where id=1;
+----+---------+-------------------------------------------------------------------------------------------------------+
| id | dept    | json_value                                                                                            |
+----+---------+-------------------------------------------------------------------------------------------------------+
|  1 | 部門1   | {"deptId": "1", "deptAddr": "贏創(chuàng)動(dòng)力4樓", "deptName": "部門1_更新后", "deptLeaderId": "3"}           |
+----+---------+-------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> update dept set json_value=JSON_SET(json_value, '$.deptAddr', '八維學(xué)院', '$.newKey', 'newKey的value') where id=1;
Query OK, 1 row affected (0.04 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> select * from dept where id=1;                                                                      +----+---------+-------------------------------------------------------------------------------------------------------------------------------+
| id | dept    | json_value                                                                                                                    |
+----+---------+-------------------------------------------------------------------------------------------------------------------------------+
|  1 | 部門1   | {"deptId": "1", "newKey": "newKey的value", "deptAddr": "八維學(xué)院", "deptName": "部門1_更新后", "deptLeaderId": "3"}           |
+----+---------+-------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

9：JSON_INSERT()

語(yǔ)法格式JSON_INSERT(json_doc, path, val[, path, val] …),插入文檔，當(dāng)值已經(jīng)存在時(shí)忽略，如下：

mysql> select * from dept where id=2;
+----+---------+-------------------------------------------------------------+
| id | dept    | json_value                                                  |
+----+---------+-------------------------------------------------------------+
|  2 | 部門2   | {"deptId": "2", "deptName": "部門2", "deptLeaderId": "4"}   |
+----+---------+-------------------------------------------------------------+
1 row in set (0.01 sec)
mysql> update dept set json_value=JSON_INSERT(json_value, '$.deptId', '已存在不更新', '$.addr', '西二旗') where id=2;
Query OK, 1 row affected (0.02 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> select * from dept where id=2;                                                                      +----+---------+----------------------------------------------------------------------------------+
| id | dept    | json_value                                                                       |
+----+---------+----------------------------------------------------------------------------------+
|  2 | 部門2   | {"addr": "西二旗", "deptId": "2", "deptName": "部門2", "deptLeaderId": "4"}      |
+----+---------+----------------------------------------------------------------------------------+
1 row in set (0.00 sec)

10：JSON_REPLACE()

語(yǔ)法格式JSON_REPLACE(json_doc, path, val[, path, val] …)，更新而不新增文檔，如下：

mysql> update dept set json_value=JSON_REPLACE(json_value, '$.deptName', '部門2_新名稱', '$.notExitsKey', '不會(huì)替換，因?yàn)椴淮嬖?) where id=2;
Query OK, 1 row affected (0.02 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> select * from dept where id=2;                                                                      +----+---------+--------------------------------------------------------------------------------------------+
| id | dept    | json_value                                                                                 |
+----+---------+--------------------------------------------------------------------------------------------+
|  2 | 部門2   | {"addr": "西二旗", "deptId": "2", "deptName": "部門2_新名稱", "deptLeaderId": "4"}         |
+----+---------+--------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

11：JSON_REMOVE()

語(yǔ)法格式JSON_REMOVE(json_doc, path[, path] …),刪除文檔：

mysql> select * from dept where id=3;
+----+---------+-------------------------------------------------------------+
| id | dept    | json_value                                                  |
+----+---------+-------------------------------------------------------------+
|  3 | 部門3   | {"deptId": "3", "deptName": "部門3", "deptLeaderId": "5"}   |
+----+---------+-------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> update dept set json_value=JSON_REMOVE(json_value, '$.depeName', '$.deptLeaderId') where id=3;
Query OK, 1 row affected (0.04 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> select * from dept where id=3;
+----+---------+----------------------------------------+
| id | dept    | json_value                             |
+----+---------+----------------------------------------+
|  3 | 部門3   | {"deptId": "3", "deptName": "部門3"}   |
+----+---------+----------------------------------------+
1 row in set (0.00 sec)

12：JSON_SEARCH

在這里插入圖片描述

語(yǔ)法格式JSON_SEARCH(json_doc，one_or_all，search_str [，escape_char [，path] ...]),
獲取指定文檔出現(xiàn)的位置，如果沒有則返回NULL。

12.1：官方例子

  • 準(zhǔn)備數(shù)據(jù)
mysql> SET @j = '["abc", [{"k": "10"}, "def"], {"x":"abc"}, {"y":"bcd"}]';
Query OK, 0 rows affected (0.00 sec)
mysql> select @j;
+---------------------------------------------------------+
| @j                                                      |
+---------------------------------------------------------+
| ["abc", [{"k": "10"}, "def"], {"x":"abc"}, {"y":"bcd"}] |
+---------------------------------------------------------+
1 row in set (0.01 sec)

查詢

mysql> SELECT JSON_SEARCH(@j, 'one', 'abc'); // 第二參數(shù)查詢終止條件，設(shè)置為one，即只查詢一個(gè)
+-------------------------------+
| JSON_SEARCH(@j, 'one', 'abc') |
+-------------------------------+
| "$[0]"                        |
+-------------------------------+
1 row in set (0.01 sec)
mysql> SELECT JSON_SEARCH(@j, 'all', 'abc'); // 第二個(gè)參數(shù)查詢終止條件，設(shè)置為all，即查詢所有匹配的
+-------------------------------+
| JSON_SEARCH(@j, 'all', 'abc') |
+-------------------------------+
| ["$[0]", "$[2].x"]            |
+-------------------------------+
1 row in set (0.01 sec)
mysql> SELECT JSON_SEARCH(@j, 'all', 'ghi'); // 全局匹配不存在的，會(huì)返回NULL
+-------------------------------+
| JSON_SEARCH(@j, 'all', 'ghi') |
+-------------------------------+
| NULL                          |
+-------------------------------+
1 row in set (0.00 sec)
mysql> SELECT JSON_SEARCH(@j, 'all', '10'); // 全局匹配10，返回具體位置的具體key
+------------------------------+
| JSON_SEARCH(@j, 'all', '10') |
+------------------------------+
| "$[1][0].k"                  |
+------------------------------+
1 row in set (0.01 sec)

指定路徑搜索

mysql> SELECT JSON_SEARCH(@j, 'all', '10', NULL, '$');
+-----------------------------------------+
| JSON_SEARCH(@j, 'all', '10', NULL, '$') |
+-----------------------------------------+
| "$[1][0].k"                             |
+-----------------------------------------+
mysql> SELECT JSON_SEARCH(@j, 'all', '10', NULL, '$[*]');
+--------------------------------------------+
| JSON_SEARCH(@j, 'all', '10', NULL, '$[*]') |
+--------------------------------------------+
| "$[1][0].k"                                |
+--------------------------------------------+
mysql> SELECT JSON_SEARCH(@j, 'all', '10', NULL, '$**.k');
+---------------------------------------------+
| JSON_SEARCH(@j, 'all', '10', NULL, '$**.k') |
+---------------------------------------------+
| "$[1][0].k"                                 |
+---------------------------------------------+
mysql> SELECT JSON_SEARCH(@j, 'all', '10', NULL, '$[*][0].k');
+-------------------------------------------------+
| JSON_SEARCH(@j, 'all', '10', NULL, '$[*][0].k') |
+-------------------------------------------------+
| "$[1][0].k"                                     |
+-------------------------------------------------+
mysql> SELECT JSON_SEARCH(@j, 'all', '10', NULL, '$[1]');
+--------------------------------------------+
| JSON_SEARCH(@j, 'all', '10', NULL, '$[1]') |
+--------------------------------------------+
| "$[1][0].k"                                |
+--------------------------------------------+
#指定搜索路徑為數(shù)組中第二個(gè)元素內(nèi)的第一個(gè)元素
mysql> SELECT JSON_SEARCH(@j, 'all', '10', NULL, '$[1][0]');
+-----------------------------------------------+
| JSON_SEARCH(@j, 'all', '10', NULL, '$[1][0]') |
+-----------------------------------------------+
| "$[1][0].k"                                   |
+-----------------------------------------------+
mysql> SELECT JSON_SEARCH(@j, 'all', 'abc', NULL, '$[2]');
+---------------------------------------------+
| JSON_SEARCH(@j, 'all', 'abc', NULL, '$[2]') |
+---------------------------------------------+
| "$[2].x"                                    |
+---------------------------------------------+

模糊匹配

mysql> SELECT JSON_SEARCH(@j, 'all', '%a%');
+-------------------------------+
| JSON_SEARCH(@j, 'all', '%a%') |
+-------------------------------+
| ["$[0]", "$[2].x"]            |
+-------------------------------+
mysql> SELECT JSON_SEARCH(@j, 'all', '%b%');
+-------------------------------+
| JSON_SEARCH(@j, 'all', '%b%') |
+-------------------------------+
| ["$[0]", "$[2].x", "$[3].y"]  |
+-------------------------------+
# 指定搜索路徑，$[0] = "abc"
mysql> SELECT JSON_SEARCH(@j, 'all', '%b%', NULL, '$[0]');
+---------------------------------------------+
| JSON_SEARCH(@j, 'all', '%b%', NULL, '$[0]') |
+---------------------------------------------+
| "$[0]"                                      |
+---------------------------------------------+
# $[2] = {"x":"abc"}
mysql> SELECT JSON_SEARCH(@j, 'all', '%b%', NULL, '$[2]');
+---------------------------------------------+
| JSON_SEARCH(@j, 'all', '%b%', NULL, '$[2]') |
+---------------------------------------------+
| "$[2].x"                                    |
+---------------------------------------------+
# $[1] = [{"k": "10"}, "def"] 模糊匹配無(wú)結(jié)果
mysql> SELECT JSON_SEARCH(@j, 'all', '%b%', NULL, '$[1]');
+---------------------------------------------+
| JSON_SEARCH(@j, 'all', '%b%', NULL, '$[1]') |
+---------------------------------------------+
| NULL                                        |
+---------------------------------------------+
mysql> SELECT JSON_SEARCH(@j, 'all', '%b%', '', '$[1]');
+-------------------------------------------+
| JSON_SEARCH(@j, 'all', '%b%', '', '$[1]') |
+-------------------------------------------+
| NULL                                      |
+-------------------------------------------+
mysql> SELECT JSON_SEARCH(@j, 'all', '%b%', '', '$[3]');
+-------------------------------------------+
| JSON_SEARCH(@j, 'all', '%b%', '', '$[3]') |
+-------------------------------------------+
| "$[3].y"                                  |
+-------------------------------------------+

12.2：實(shí)際例子

在日常開發(fā)過(guò)程中如果需要使用JSON_SEARCH查詢的話，需要搭配IS NOT NULL來(lái)獲取符合條件的數(shù)據(jù)，如果是返回是NULL則說(shuō)明不存在，反之存在，所以，對(duì)于返回的具體位置信息我們一般是使用不到的，準(zhǔn)備數(shù)據(jù)如下：

Create Table: CREATE TABLE `user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL COMMENT '名字',
  `age` int(4) unsigned NOT NULL COMMENT '年齡',
  `info` text COMMENT '補(bǔ)充信息',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用戶表'
INSERT INTO `user` (`name`, `age`, `info`) VALUES ('suhw', '23', '{"phone":"12312123434","language":["c++","java","go"]}');
INSERT INTO `user` (`name`, `age`, `info`) VALUES ('bob', '20', '{"phone":"18912123434","language":["c++","c","go","php"]}');

查詢會(huì)java和go語(yǔ)言的數(shù)據(jù)：

mysql> select * from user where json_search(info, 'all', 'go') is not null and json_search(info, 'all', 'java') is not null;
+----+------+-----+--------------------------------------------------------+
| id | name | age | info                                                   |
+----+------+-----+--------------------------------------------------------+
|  1 | suhw |  23 | {"phone":"12312123434","language":["c++","java","go"]} |
+----+------+-----+--------------------------------------------------------+
1 row in set (0.00 sec)

寫在后面

參考文章列表

【MySQL】對(duì)JSON數(shù)據(jù)操作（全網(wǎng)最全） 。

MySQL - json_search 小結(jié) 。

到此這篇關(guān)于mysql中的json處理方案的文章就介紹到這了,更多相關(guān)mysql json處理內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！

相關(guān)文章

  • MySQL隱式轉(zhuǎn)換造成索引失效的解決辦法

    MySQL隱式轉(zhuǎn)換造成索引失效的解決辦法

    數(shù)據(jù)庫(kù)優(yōu)化是一個(gè)任重而道遠(yuǎn)的任務(wù),想要做優(yōu)化必須深入理解數(shù)據(jù)庫(kù)的各種特性,在開發(fā)過(guò)程中我們經(jīng)常會(huì)遇到一些原因很簡(jiǎn)單但造成的后果卻很嚴(yán)重的疑難雜癥,這類問題往往還不容易定位,本文將給大家介紹MySQL隱式轉(zhuǎn)換造成索引失效的解決辦法,需要的朋友可以參考下
    2025-02-02
  • 通過(guò)yum方式安裝mySql數(shù)據(jù)庫(kù)的全過(guò)程

    通過(guò)yum方式安裝mySql數(shù)據(jù)庫(kù)的全過(guò)程

    當(dāng)工作需要部署mysql時(shí),通過(guò)手動(dòng)上傳安裝包以及依賴包的方式安裝mysql會(huì)比較麻煩,可以添加官方y(tǒng)um源,來(lái)實(shí)現(xiàn)自動(dòng)安裝依賴,方便快捷,下面這篇文章主要給大家介紹了關(guān)于通過(guò)yum方式安裝mySql數(shù)據(jù)庫(kù)的相關(guān)資料,需要的朋友可以參考下
    2022-07-07
  • mysql8.0.19忘記密碼處理方法詳解

    mysql8.0.19忘記密碼處理方法詳解

    這篇文章主要介紹了mysql8.0.19忘記密碼處理方法詳解，文章圍繞主題展開詳細(xì)的內(nèi)容介紹，具有一定的參考價(jià)值，需要的小伙伴可以參考一下
    2022-07-07
  • 云服務(wù)器Ubuntu_Server_16.04.1安裝MySQL并開啟遠(yuǎn)程連接的方法

    云服務(wù)器Ubuntu_Server_16.04.1安裝MySQL并開啟遠(yuǎn)程連接的方法

    這篇文章主要介紹了云服務(wù)器Ubuntu_Server_16.04.1安裝MySQL并開啟遠(yuǎn)程連接的方法，非常不錯(cuò)，具有參考借鑒價(jià)值,需要的朋友可以參考下
    2018-02-02
  • mysql查詢的控制語(yǔ)句圖文詳解

    mysql查詢的控制語(yǔ)句圖文詳解

    這篇文章主要給大家介紹了關(guān)于mysql查詢控制語(yǔ)句的相關(guān)資料，文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧
    2021-04-04
  • MySQL運(yùn)維實(shí)戰(zhàn)使用RPM進(jìn)行安裝部署

    MySQL運(yùn)維實(shí)戰(zhàn)使用RPM進(jìn)行安裝部署

    這篇文章主要為大家介紹了MySQL運(yùn)維實(shí)戰(zhàn)使用RPM進(jìn)行安裝部署實(shí)現(xiàn)示例詳解,有需要的朋友可以借鑒參考下,希望能夠有所幫助,祝大家多多進(jìn)步,早日升職加薪
    2023-12-12
  • MySQL的常用命令集錦

    MySQL的常用命令集錦

    這篇文章主要介紹了MySQL的常用命令集錦,堪稱初學(xué)者需要掌握的MySQL命令大全,其中系統(tǒng)命令行環(huán)境是基于類Unix系統(tǒng)來(lái)作例子的,需要的朋友可以參考下
    2015-11-11
  • 淺談mysql哪些情況會(huì)導(dǎo)致索引失效

    淺談mysql哪些情況會(huì)導(dǎo)致索引失效

    索引在我們使用MySQL數(shù)據(jù)庫(kù)時(shí)可以極大的提高查詢效率,然而,有時(shí)候因?yàn)槭褂蒙系囊恍╄Υ镁蜁?huì)導(dǎo)致索引的失效,無(wú)法達(dá)到我們使用索引的預(yù)期效果，本文就介紹一下幾種索引失效的方法
    2021-11-11
  • mysql表名忽略大小寫配置方法詳解

    mysql表名忽略大小寫配置方法詳解

    下面小編就為大家?guī)?lái)一篇mysql表名忽略大小寫配置方法詳解。小編覺得挺不錯(cuò)的，現(xiàn)在就分享給大家，也給大家做個(gè)參考。一起跟隨小編過(guò)來(lái)看看吧
    2017-03-03
  • MySQL 在線解密的實(shí)現(xiàn)

    MySQL 在線解密的實(shí)現(xiàn)

    本文主要介紹了MySQL在線解密的實(shí)現(xiàn),通過(guò)使用MySQL提供的加密函數(shù)和自定義解密函數(shù),我們可以在數(shù)據(jù)庫(kù)中進(jìn)行在線解密操作,下面就來(lái)具體介紹一下,感興趣的可以了解一下
    2024-08-08

最新評(píng)論