mysql+json+检索_如何从MySQL检索JSON数据？

我有以下表格及其关系。我将JSON数据存储在client_services表中。它们是使用MySQL查询来检索JSON值的任何方式，如下所示：

SELECT getJson("quota") as quota,

client_id

FROM client_services

WHERE service_id = 1;

还是可以进一步规范化client_services表？

表Services：

+----+-----------------------+--------------------------------------------------------+

| id | name | description |

+----+-----------------------+--------------------------------------------------------+

| 1 | MailBox | |

| 2 | SMS | |

| 3 | FTP | |

+----+-----------------------+--------------------------------------------------------+

表service_features：

+----+------------+----------------------------------+------------------------+

| id | service_id | name | description |

+----+------------+----------------------------------+------------------------+

| 10 | 1 | Forwarding | Forward Mail |

| 11 | 1 | Archive | Archive Mail |

| 12 | 1 | WebMail | NULL |

| 13 | 1 | IMAP | NULL |

| 14 | 2 | Web SMS | NULL |

+----+------------+----------------------------------+------------------------+

表client_services：

+-----+-----------+------------+-------------------------------------------------------------------------------------------+

| id | client_id | service_id | service_values |

+-----+-----------+------------+-------------------------------------------------------------------------------------------+

| 100 | 1000 | 1 |{ "quota": 100000,"free_quota":20000,"total_accounts":200,"data_transfer":1000000} |

| 101 | 1000 | 2 |{ "quota": 200 } |

| 102 | 1000 | 3 |{ "data_transfer":1000000} |

| 103 | 1001 | 1 |{ "quota": 1000000,"free_quota":2000,"total_accounts":200,"data_transfer":1000000} |

| 104 | 1001 | 2 |{ "quota": 500 } |

| 105 | 1002 | 2 |{ "quota": 600 } |

+-----+-----------+------------+-------------------------------------------------------------------------------------------+

表client_feature_mappers：

+-----+-------------------+--------------------+-----------+

| id | client_service_id | service_feature_id | client_id |

+-----+-------------------+--------------------+-----------+

|10000| 100| 10 | 1000|

|10001| 100| 11 | 1000|

|10002| 100| 12 | 1000|

|10003| 100| 13 | 1000|

|10004| 101| 14 | 1000|

|10005| 103| 10 | 1001|

|10006| 101| 11 | 1001|

|10007| 101| 12 | 1001|

|10008| 101| 13 | 1001|

|10009| 105| 14 | 1002|

+-----+-------------------+--------------------+-----------+