首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >在插入时,mysql8 json类型中是否存在错误?

在插入时,mysql8 json类型中是否存在错误?
EN

Stack Overflow用户
提问于 2021-07-23 12:08:18
回答 1查看 40关注 0票数 1

下面是DDL:

代码语言:javascript
运行
复制
 CREATE TABLE `list_search_test` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `info` json DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

当我插入数据时:

代码语言:javascript
运行
复制
    INSERT INTO list_search_test
(id, name, info)
VALUES(4, 'jsonTest', 
'{"apis": [{"name": "BenefitService", "assetRef": false, "operations": [{"name": "createBenefit", "inputs": [{"name": "benefitid", "nameCn": "", "assetRef": false, "dataType": "Integer", "required": false}, {"name": "userid", "nameCn": "", "assetRef": false, "dataType": "Long", "required": true}], "outputs": [{"name": "result", "intro": "", "assetRef": false, "dataType": "Long", "required": false}], "assetRef": false, "displayName": "", "dependencies": {"assetRef": false, "applicationServiceOperations": [{"bizCode": "http://www.103573587971.com/bizgo-ep/MODULE_CENTER/CampaignDomain/application-service|BenefitMgt|createUserBenefit", "version": "1.0.0"}]}, "requestMethod": "POST", "requestProtocol": "HTTP"}], "displayName": "", "targetNamespace": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter/business-capability-api"}], "name": "BenefitCenter", "appInfo": {"code": "benefitcenter", "version": "v1.0.0", "assetRef": false}, "bizCode": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter|BenefitCenter", "assetRef": false, "diagrams": [{"assetRef": false, "activities": [{"name": "createTest", "binding": {"assetRef": false, "apiOperations": [{"name": "BenefitService", "assetRef": false, "operations": [{"name": "createBenefit", "inputs": [{"name": "benefitid", "nameCn": "", "assetRef": false, "dataType": "Integer"}, {"name": "userid", "nameCn": "用户ID", "assetRef": false, "dataType": "Long", "required": true}], "outputs": [{"name": "result", "intro": "", "assetRef": false, "dataType": "Long"}], "assetRef": false, "displayName": "", "dependencies": {"assetRef": false, "applicationServiceOperations": [{"bizCode": "http://www.103573587971.com/bizgo-ep/MODULE_CENTER/CampaignDomain/application-service|BenefitMgt|createUserBenefit", "version": "1.0.0"}]}, "requestMethod": "POST", "requestProtocol": "HTTP"}], "displayName": "b", "targetNamespace": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter/business-capability-api"}]}, "assetRef": false, "displayName": ""}], "designerData": "{\"id\":\"s\"}"}], "sdkInfos": [{"id": "BenefitCenter", "bizCode": "BenefitCenter", "assetRef": true, "endpoint": "bw.app.bizworks.cn", "bizVersion": "V1.0.0", "downloadLink": "http://bw-paas.qa.console.aliyun.test/cloudapi-gateway-lite?Version=2016-07-14&Action=SdkGenerateForBizworks&RegionId=bizworks-premeses&ProjectCode=bizgo-ep&BizCode=BenefitCenter"}], "assetType": "BusinessCapability", "bizVersion": "V1.0.0", "displayName": "AI+】", "targetNamespace": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter"}');

bug mysql告诉我:

代码语言:javascript
运行
复制
Data truncation: Invalid JSON text: "Missing a comma or '}' after an object member." at position 2177 in value for column 'list_search_test.info'.

我该怎么解决它呢?

EN

回答 1

Stack Overflow用户

发布于 2021-07-23 12:22:04

问题出在内部json上。

designerData -为此,您提供的是json字符串,而不是实际的json。

工作中:

代码语言:javascript
运行
复制
    INSERT INTO list_search_test
( name, info)
VALUES( 'jsonTest', 
'{"apis": [{"name": "BenefitService", "assetRef": false, "operations": [{"name": "createBenefit", "inputs": [{"name": "benefitid", "nameCn": "", "assetRef": false, "dataType": "Integer", "required": false}, {"name": "userid", "nameCn": "", "assetRef": false, "dataType": "Long", "required": true}], "outputs": [{"name": "result", "intro": "", "assetRef": false, "dataType": "Long", "required": false}], "assetRef": false, "displayName": "", "dependencies": {"assetRef": false, "applicationServiceOperations": [{"bizCode": "http://www.103573587971.com/bizgo-ep/MODULE_CENTER/CampaignDomain/application-service|BenefitMgt|createUserBenefit", "version": "1.0.0"}]}, "requestMethod": "POST", "requestProtocol": "HTTP"}], "displayName": "", "targetNamespace": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter/business-capability-api"}], "name": "BenefitCenter", "appInfo": {"code": "benefitcenter", "version": "v1.0.0", "assetRef": false}, "bizCode": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter|BenefitCenter", "assetRef": false, "diagrams": [{"assetRef": false, "activities": [{"name": "createTest", "binding": {"assetRef": false, "apiOperations": [{"name": "BenefitService", "assetRef": false, "operations": [{"name": "createBenefit", "inputs": [{"name": "benefitid", "nameCn": "", "assetRef": false, "dataType": "Integer"}, {"name": "userid", "nameCn": "用户ID", "assetRef": false, "dataType": "Long", "required": true}], "outputs": [{"name": "result", "intro": "", "assetRef": false, "dataType": "Long"}], "assetRef": false, "displayName": "", "dependencies": {"assetRef": false, "applicationServiceOperations": [{"bizCode": "http://www.103573587971.com/bizgo-ep/MODULE_CENTER/CampaignDomain/application-service|BenefitMgt|createUserBenefit", "version": "1.0.0"}]}, "requestMethod": "POST", "requestProtocol": "HTTP"}], "displayName": "b", "targetNamespace": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter/business-capability-api"}]}, "assetRef": false, "displayName": ""}], "designerData": {"id":"s"}}], "sdkInfos": [{"id": "BenefitCenter", "bizCode": "BenefitCenter", "assetRef": true, "endpoint": "bw.app.bizworks.cn", "bizVersion": "V1.0.0", "downloadLink": "http://bw-paas.qa.console.aliyun.test/cloudapi-gateway-lite?Version=2016-07-14&Action=SdkGenerateForBizworks&RegionId=bizworks-premeses&ProjectCode=bizgo-ep&BizCode=BenefitCenter"}], "assetType": "BusinessCapability", "bizVersion": "V1.0.0", "displayName": "AI+]", "targetNamespace": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter"}');
票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/68493948

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档