长春网站建设长春电梯公司,网站策划与设计(,深圳深一互联科技有限公司,上海搭建商我有以下表格和他们的关系.我将json数据存储在client_services表中.他们是否可以使用mysql查询检索JSON值.喜欢#xff1a;select getJson(quota) as quota, client_id from client_services where service_id 1;要么我可以进一步规范化client_services表吗#…我有以下表格和他们的关系.我将json数据存储在client_services表中.他们是否可以使用mysql查询检索JSON值.喜欢select getJson(quota) as quota, client_id from client_services where service_id 1;要么我可以进一步规范化client_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|-------------------------------------------------------
