JSON(JavaScript Object Notation)\u662f\u4e00\u79cd\u8f7b\u91cf\u7ea7\u7684\u6570\u636e\u4ea4\u6362\u683c\u5f0f,\u91c7\u7528\u5b8c\u5168\u72ec\u7acb\u4e8e\u8bed\u8a00\u7684\u6587\u672c\u683c\u5f0f,\u6613\u4e8e\u4eba\u9605\u8bfb\u548c\u7f16\u5199,\u540c\u65f6\u4e5f\u6613\u4e8e\u673a\u5668\u89e3\u6790\u548c\u751f\u6210\u3002JSON\u57fa\u4e8eJavaScript\u7684\u4e00\u4e2a\u5b50\u96c6,\u662f\u7406\u60f3\u7684\u534a\u7ed3\u6784\u5316\u6570\u636e\u5b58\u50a8\u683c\u5f0f\u3002<\/p>\n
#publish-mermaid-1786238291865-0{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}@keyframes edge-animation-frame{from{stroke-dashoffset:0;}}@keyframes dash{to{stroke-dashoffset:0;}}#publish-mermaid-1786238291865-0 .edge-animation-slow{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 50s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238291865-0 .edge-animation-fast{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 20s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238291865-0 .error-icon{fill:#552222;}#publish-mermaid-1786238291865-0 .error-text{fill:#552222;stroke:#552222;}#publish-mermaid-1786238291865-0 .edge-thickness-normal{stroke-width:1px;}#publish-mermaid-1786238291865-0 .edge-thickness-thick{stroke-width:3.5px;}#publish-mermaid-1786238291865-0 .edge-pattern-solid{stroke-dasharray:0;}#publish-mermaid-1786238291865-0 .edge-thickness-invisible{stroke-width:0;fill:none;}#publish-mermaid-1786238291865-0 .edge-pattern-dashed{stroke-dasharray:3;}#publish-mermaid-1786238291865-0 .edge-pattern-dotted{stroke-dasharray:2;}#publish-mermaid-1786238291865-0 .marker{fill:#333333;stroke:#333333;}#publish-mermaid-1786238291865-0 .marker.cross{stroke:#333333;}#publish-mermaid-1786238291865-0 svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#publish-mermaid-1786238291865-0 p{margin:0;}#publish-mermaid-1786238291865-0 .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#publish-mermaid-1786238291865-0 .cluster-label text{fill:#333;}#publish-mermaid-1786238291865-0 .cluster-label span{color:#333;}#publish-mermaid-1786238291865-0 .cluster-label span p{background-color:transparent;}#publish-mermaid-1786238291865-0 .label text,#publish-mermaid-1786238291865-0 span{fill:#333;color:#333;}#publish-mermaid-1786238291865-0 .node rect,#publish-mermaid-1786238291865-0 .node circle,#publish-mermaid-1786238291865-0 .node ellipse,#publish-mermaid-1786238291865-0 .node polygon,#publish-mermaid-1786238291865-0 .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238291865-0 .rough-node .label text,#publish-mermaid-1786238291865-0 .node .label text,#publish-mermaid-1786238291865-0 .image-shape .label,#publish-mermaid-1786238291865-0 .icon-shape .label{text-anchor:middle;}#publish-mermaid-1786238291865-0 .node .katex path{fill:#000;stroke:#000;stroke-width:1px;}#publish-mermaid-1786238291865-0 .rough-node .label,#publish-mermaid-1786238291865-0 .node .label,#publish-mermaid-1786238291865-0 .image-shape .label,#publish-mermaid-1786238291865-0 .icon-shape .label{text-align:center;}#publish-mermaid-1786238291865-0 .node.clickable{cursor:pointer;}#publish-mermaid-1786238291865-0 .root .anchor path{fill:#333333!important;stroke-width:0;stroke:#333333;}#publish-mermaid-1786238291865-0 .arrowheadPath{fill:#333333;}#publish-mermaid-1786238291865-0 .edgePath .path{stroke:#333333;stroke-width:1px;}#publish-mermaid-1786238291865-0 .flowchart-link{stroke:#333333;fill:none;}#publish-mermaid-1786238291865-0 .edgeLabel{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238291865-0 .edgeLabel p{background-color:rgba(232,232,232, 0.8);}#publish-mermaid-1786238291865-0 .edgeLabel rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238291865-0 .labelBkg{background-color:rgba(232, 232, 232, 0.5);}#publish-mermaid-1786238291865-0 .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#publish-mermaid-1786238291865-0 .cluster text{fill:#333;}#publish-mermaid-1786238291865-0 .cluster span{color:#333;}#publish-mermaid-1786238291865-0 div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#publish-mermaid-1786238291865-0 .flowchartTitleText{text-anchor:middle;font-size:18px;fill:#333;}#publish-mermaid-1786238291865-0 rect.text{fill:none;stroke-width:0;}#publish-mermaid-1786238291865-0 .icon-shape,#publish-mermaid-1786238291865-0 .image-shape{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238291865-0 .icon-shape p,#publish-mermaid-1786238291865-0 .image-shape p{background-color:rgba(232,232,232, 0.8);padding:2px;}#publish-mermaid-1786238291865-0 .icon-shape .label rect,#publish-mermaid-1786238291865-0 .image-shape .label rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238291865-0 .label-icon{display:inline-block;height:1em;overflow:visible;vertical-align:-0.125em;}#publish-mermaid-1786238291865-0 .node .label-icon path{fill:currentColor;stroke:revert;stroke-width:revert;}#publish-mermaid-1786238291865-0 .node .neo-node{stroke:#9370DB;}#publish-mermaid-1786238291865-0 [data-look=\\”neo\\”].node rect,#publish-mermaid-1786238291865-0 [data-look=\\”neo\\”].cluster rect,#publish-mermaid-1786238291865-0 [data-look=\\”neo\\”].node polygon{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238291865-0 [data-look=\\”neo\\”].swimlane.cluster rect{filter:none;}#publish-mermaid-1786238291865-0 [data-look=\\”neo\\”].node path{stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238291865-0 [data-look=\\”neo\\”].node .outer-path{filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238291865-0 [data-look=\\”neo\\”].node .neo-line path{stroke:#9370DB;filter:none;}#publish-mermaid-1786238291865-0 [data-look=\\”neo\\”].node circle{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238291865-0 [data-look=\\”neo\\”].node circle .state-start{fill:#000000;}#publish-mermaid-1786238291865-0 [data-look=\\”neo\\”].icon-shape .icon{fill:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238291865-0 [data-look=\\”neo\\”].icon-shape .icon-neo path{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238291865-0 :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;}<\/p>\n JSON\u6570\u636e\u7ed3\u6784<\/p>\n <\/span><\/p>\n \u5bf9\u8c61 Object<\/p>\n <\/span><\/p>\n \u6570\u7ec4 Array<\/p>\n <\/span><\/p>\n \u57fa\u7840\u503c Value<\/p>\n <\/span><\/p>\n {key: value, …}<\/p>\n <\/span><\/p>\n [value, value, …]<\/p>\n <\/span><\/p>\n string<\/p>\n <\/span><\/p>\n number<\/p>\n <\/span><\/p>\n boolean<\/p>\n <\/span><\/p>\n null<\/p>\n <\/span><\/p>\n object<\/p>\n <\/span><\/p>\n array<\/p>\n <\/span><\/p>\n \u8fbe\u68a6\u6570\u636e\u5e93DM8\u63d0\u4f9b\u4e86\u5bf9JSON\u6570\u636e\u7684\u5168\u9762\u652f\u6301,\u4e3b\u8981\u5305\u62ec\u4ee5\u4e0b\u80fd\u529b:<\/p>\n #publish-mermaid-1786238291989-1{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}@keyframes edge-animation-frame{from{stroke-dashoffset:0;}}@keyframes dash{to{stroke-dashoffset:0;}}#publish-mermaid-1786238291989-1 .edge-animation-slow{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 50s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238291989-1 .edge-animation-fast{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 20s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238291989-1 .error-icon{fill:#552222;}#publish-mermaid-1786238291989-1 .error-text{fill:#552222;stroke:#552222;}#publish-mermaid-1786238291989-1 .edge-thickness-normal{stroke-width:1px;}#publish-mermaid-1786238291989-1 .edge-thickness-thick{stroke-width:3.5px;}#publish-mermaid-1786238291989-1 .edge-pattern-solid{stroke-dasharray:0;}#publish-mermaid-1786238291989-1 .edge-thickness-invisible{stroke-width:0;fill:none;}#publish-mermaid-1786238291989-1 .edge-pattern-dashed{stroke-dasharray:3;}#publish-mermaid-1786238291989-1 .edge-pattern-dotted{stroke-dasharray:2;}#publish-mermaid-1786238291989-1 .marker{fill:#333333;stroke:#333333;}#publish-mermaid-1786238291989-1 .marker.cross{stroke:#333333;}#publish-mermaid-1786238291989-1 svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#publish-mermaid-1786238291989-1 p{margin:0;}#publish-mermaid-1786238291989-1 .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#publish-mermaid-1786238291989-1 .cluster-label text{fill:#333;}#publish-mermaid-1786238291989-1 .cluster-label span{color:#333;}#publish-mermaid-1786238291989-1 .cluster-label span p{background-color:transparent;}#publish-mermaid-1786238291989-1 .label text,#publish-mermaid-1786238291989-1 span{fill:#333;color:#333;}#publish-mermaid-1786238291989-1 .node rect,#publish-mermaid-1786238291989-1 .node circle,#publish-mermaid-1786238291989-1 .node ellipse,#publish-mermaid-1786238291989-1 .node polygon,#publish-mermaid-1786238291989-1 .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238291989-1 .rough-node .label text,#publish-mermaid-1786238291989-1 .node .label text,#publish-mermaid-1786238291989-1 .image-shape .label,#publish-mermaid-1786238291989-1 .icon-shape .label{text-anchor:middle;}#publish-mermaid-1786238291989-1 .node .katex path{fill:#000;stroke:#000;stroke-width:1px;}#publish-mermaid-1786238291989-1 .rough-node .label,#publish-mermaid-1786238291989-1 .node .label,#publish-mermaid-1786238291989-1 .image-shape .label,#publish-mermaid-1786238291989-1 .icon-shape .label{text-align:center;}#publish-mermaid-1786238291989-1 .node.clickable{cursor:pointer;}#publish-mermaid-1786238291989-1 .root .anchor path{fill:#333333!important;stroke-width:0;stroke:#333333;}#publish-mermaid-1786238291989-1 .arrowheadPath{fill:#333333;}#publish-mermaid-1786238291989-1 .edgePath .path{stroke:#333333;stroke-width:1px;}#publish-mermaid-1786238291989-1 .flowchart-link{stroke:#333333;fill:none;}#publish-mermaid-1786238291989-1 .edgeLabel{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238291989-1 .edgeLabel p{background-color:rgba(232,232,232, 0.8);}#publish-mermaid-1786238291989-1 .edgeLabel rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238291989-1 .labelBkg{background-color:rgba(232, 232, 232, 0.5);}#publish-mermaid-1786238291989-1 .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#publish-mermaid-1786238291989-1 .cluster text{fill:#333;}#publish-mermaid-1786238291989-1 .cluster span{color:#333;}#publish-mermaid-1786238291989-1 div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#publish-mermaid-1786238291989-1 .flowchartTitleText{text-anchor:middle;font-size:18px;fill:#333;}#publish-mermaid-1786238291989-1 rect.text{fill:none;stroke-width:0;}#publish-mermaid-1786238291989-1 .icon-shape,#publish-mermaid-1786238291989-1 .image-shape{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238291989-1 .icon-shape p,#publish-mermaid-1786238291989-1 .image-shape p{background-color:rgba(232,232,232, 0.8);padding:2px;}#publish-mermaid-1786238291989-1 .icon-shape .label rect,#publish-mermaid-1786238291989-1 .image-shape .label rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238291989-1 .label-icon{display:inline-block;height:1em;overflow:visible;vertical-align:-0.125em;}#publish-mermaid-1786238291989-1 .node .label-icon path{fill:currentColor;stroke:revert;stroke-width:revert;}#publish-mermaid-1786238291989-1 .node .neo-node{stroke:#9370DB;}#publish-mermaid-1786238291989-1 [data-look=\\”neo\\”].node rect,#publish-mermaid-1786238291989-1 [data-look=\\”neo\\”].cluster rect,#publish-mermaid-1786238291989-1 [data-look=\\”neo\\”].node polygon{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238291989-1 [data-look=\\”neo\\”].swimlane.cluster rect{filter:none;}#publish-mermaid-1786238291989-1 [data-look=\\”neo\\”].node path{stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238291989-1 [data-look=\\”neo\\”].node .outer-path{filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238291989-1 [data-look=\\”neo\\”].node .neo-line path{stroke:#9370DB;filter:none;}#publish-mermaid-1786238291989-1 [data-look=\\”neo\\”].node circle{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238291989-1 [data-look=\\”neo\\”].node circle .state-start{fill:#000000;}#publish-mermaid-1786238291989-1 [data-look=\\”neo\\”].icon-shape .icon{fill:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238291989-1 [data-look=\\”neo\\”].icon-shape .icon-neo path{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238291989-1 :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;}<\/p>\n DM8 JSON\u652f\u6301<\/p>\n <\/span><\/p>\n \u5b58\u50a8\u80fd\u529b<\/p>\n <\/span><\/p>\n \u67e5\u8be2\u80fd\u529b<\/p>\n <\/span><\/p>\n \u6784\u5efa\u80fd\u529b<\/p>\n <\/span><\/p>\n \u8f6c\u6362\u80fd\u529b<\/p>\n <\/span><\/p>\n \u4f18\u5316\u80fd\u529b<\/p>\n <\/span><\/p>\n CLOB\/VARCHAR\u5b58\u50a8<\/p>\n <\/span><\/p>\n JSON\u7c7b\u578b\u6821\u9a8c<\/p>\n <\/span><\/p>\n JSON_PATH\u8def\u5f84\u67e5\u8be2<\/p>\n <\/span><\/p>\n \u6761\u4ef6\u8fc7\u6ee4<\/p>\n <\/span><\/p>\n JSON_OBJECT\u6784\u5efa\u5bf9\u8c61<\/p>\n <\/span><\/p>\n JSON_ARRAY\u6784\u5efa\u6570\u7ec4<\/p>\n <\/span><\/p>\n JSON_TABLE\u8f6c\u5173\u7cfb\u8868<\/p>\n <\/span><\/p>\n \u5173\u7cfb\u6570\u636e\u8f6cJSON<\/p>\n <\/span><\/p>\n \u51fd\u6570\u7d22\u5f15<\/p>\n <\/span><\/p>\n \u67e5\u8be2\u4f18\u5316<\/p>\n <\/span><\/p>\n JSON\u51fd\u6570\u5728\u5b9e\u9645\u4e1a\u52a1\u4e2d\u6709\u5e7f\u6cdb\u7684\u5e94\u7528\u573a\u666f,\u4e3b\u8981\u5305\u62ec:<\/p>\n #publish-mermaid-1786238292127-2{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}@keyframes edge-animation-frame{from{stroke-dashoffset:0;}}@keyframes dash{to{stroke-dashoffset:0;}}#publish-mermaid-1786238292127-2 .edge-animation-slow{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 50s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238292127-2 .edge-animation-fast{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 20s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238292127-2 .error-icon{fill:#552222;}#publish-mermaid-1786238292127-2 .error-text{fill:#552222;stroke:#552222;}#publish-mermaid-1786238292127-2 .edge-thickness-normal{stroke-width:1px;}#publish-mermaid-1786238292127-2 .edge-thickness-thick{stroke-width:3.5px;}#publish-mermaid-1786238292127-2 .edge-pattern-solid{stroke-dasharray:0;}#publish-mermaid-1786238292127-2 .edge-thickness-invisible{stroke-width:0;fill:none;}#publish-mermaid-1786238292127-2 .edge-pattern-dashed{stroke-dasharray:3;}#publish-mermaid-1786238292127-2 .edge-pattern-dotted{stroke-dasharray:2;}#publish-mermaid-1786238292127-2 .marker{fill:#333333;stroke:#333333;}#publish-mermaid-1786238292127-2 .marker.cross{stroke:#333333;}#publish-mermaid-1786238292127-2 svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#publish-mermaid-1786238292127-2 p{margin:0;}#publish-mermaid-1786238292127-2 .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#publish-mermaid-1786238292127-2 .cluster-label text{fill:#333;}#publish-mermaid-1786238292127-2 .cluster-label span{color:#333;}#publish-mermaid-1786238292127-2 .cluster-label span p{background-color:transparent;}#publish-mermaid-1786238292127-2 .label text,#publish-mermaid-1786238292127-2 span{fill:#333;color:#333;}#publish-mermaid-1786238292127-2 .node rect,#publish-mermaid-1786238292127-2 .node circle,#publish-mermaid-1786238292127-2 .node ellipse,#publish-mermaid-1786238292127-2 .node polygon,#publish-mermaid-1786238292127-2 .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238292127-2 .rough-node .label text,#publish-mermaid-1786238292127-2 .node .label text,#publish-mermaid-1786238292127-2 .image-shape .label,#publish-mermaid-1786238292127-2 .icon-shape .label{text-anchor:middle;}#publish-mermaid-1786238292127-2 .node .katex path{fill:#000;stroke:#000;stroke-width:1px;}#publish-mermaid-1786238292127-2 .rough-node .label,#publish-mermaid-1786238292127-2 .node .label,#publish-mermaid-1786238292127-2 .image-shape .label,#publish-mermaid-1786238292127-2 .icon-shape .label{text-align:center;}#publish-mermaid-1786238292127-2 .node.clickable{cursor:pointer;}#publish-mermaid-1786238292127-2 .root .anchor path{fill:#333333!important;stroke-width:0;stroke:#333333;}#publish-mermaid-1786238292127-2 .arrowheadPath{fill:#333333;}#publish-mermaid-1786238292127-2 .edgePath .path{stroke:#333333;stroke-width:1px;}#publish-mermaid-1786238292127-2 .flowchart-link{stroke:#333333;fill:none;}#publish-mermaid-1786238292127-2 .edgeLabel{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238292127-2 .edgeLabel p{background-color:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292127-2 .edgeLabel rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292127-2 .labelBkg{background-color:rgba(232, 232, 232, 0.5);}#publish-mermaid-1786238292127-2 .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#publish-mermaid-1786238292127-2 .cluster text{fill:#333;}#publish-mermaid-1786238292127-2 .cluster span{color:#333;}#publish-mermaid-1786238292127-2 div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#publish-mermaid-1786238292127-2 .flowchartTitleText{text-anchor:middle;font-size:18px;fill:#333;}#publish-mermaid-1786238292127-2 rect.text{fill:none;stroke-width:0;}#publish-mermaid-1786238292127-2 .icon-shape,#publish-mermaid-1786238292127-2 .image-shape{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238292127-2 .icon-shape p,#publish-mermaid-1786238292127-2 .image-shape p{background-color:rgba(232,232,232, 0.8);padding:2px;}#publish-mermaid-1786238292127-2 .icon-shape .label rect,#publish-mermaid-1786238292127-2 .image-shape .label rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292127-2 .label-icon{display:inline-block;height:1em;overflow:visible;vertical-align:-0.125em;}#publish-mermaid-1786238292127-2 .node .label-icon path{fill:currentColor;stroke:revert;stroke-width:revert;}#publish-mermaid-1786238292127-2 .node .neo-node{stroke:#9370DB;}#publish-mermaid-1786238292127-2 [data-look=\\”neo\\”].node rect,#publish-mermaid-1786238292127-2 [data-look=\\”neo\\”].cluster rect,#publish-mermaid-1786238292127-2 [data-look=\\”neo\\”].node polygon{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292127-2 [data-look=\\”neo\\”].swimlane.cluster rect{filter:none;}#publish-mermaid-1786238292127-2 [data-look=\\”neo\\”].node path{stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238292127-2 [data-look=\\”neo\\”].node .outer-path{filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292127-2 [data-look=\\”neo\\”].node .neo-line path{stroke:#9370DB;filter:none;}#publish-mermaid-1786238292127-2 [data-look=\\”neo\\”].node circle{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292127-2 [data-look=\\”neo\\”].node circle .state-start{fill:#000000;}#publish-mermaid-1786238292127-2 [data-look=\\”neo\\”].icon-shape .icon{fill:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292127-2 [data-look=\\”neo\\”].icon-shape .icon-neo path{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292127-2 :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;}\u7ed3\u6784\u56fa\u5b9a\u534a\u7ed3\u6784\u5316\u4e0d\u5e38\u67e5\u8be2<\/p>\n \u4e1a\u52a1\u9700\u6c42<\/p>\n <\/span><\/p>\n \u6570\u636e\u7279\u70b9<\/p>\n <\/span><\/p>\n \u5173\u7cfb\u578b\u5b57\u6bb5<\/p>\n <\/span><\/p>\n JSON\u5b57\u6bb5<\/p>\n <\/span><\/p>\n JSON\u5b58\u50a8<\/p>\n <\/span><\/p>\n \u4f7f\u7528JSON\u51fd\u6570\u5904\u7406<\/p>\n <\/span><\/p>\n \u67e5\u8be2: JSON_VALUE\/QUERY<\/p>\n <\/span><\/p>\n \u6784\u5efa: JSON_OBJECT\/ARRAY<\/p>\n <\/span><\/p>\n \u8f6c\u6362: JSON_TABLE<\/p>\n <\/span><\/p>\n JSON_VALUE\u51fd\u6570\u7528\u4e8e\u4eceJSON\u5b57\u7b26\u4e32\u4e2d\u63d0\u53d6\u6807\u91cf\u503c(\u5b57\u7b26\u4e32\u3001\u6570\u5b57\u3001\u5e03\u5c14\u503c\u7b49),\u8fd4\u56de\u5355\u4e2a\u6807\u91cf\u503c\u3002<\/p>\n \u8bed\u6cd5\u683c\u5f0f:<\/p>\n JSON_VALUE(json_string, json_path)<\/p>\n \u53c2\u6570\u8bf4\u660e:<\/p>\n \u793a\u4f8b:<\/p>\n — \u521b\u5efa\u6d4b\u8bd5\u8868 JSON\u8def\u5f84\u8868\u8fbe\u5f0f\u8bf4\u660e:<\/p>\n | \u8def\u5f84\u8868\u8fbe\u5f0f | \u542b\u4e49 | \u793a\u4f8b |<\/p>\n | — | — | — |<\/p>\n | $ | \u6839\u5bf9\u8c61 | $ |<\/p>\n | $.key | \u5bf9\u8c61\u5c5e\u6027 | $.name |<\/p>\n | $.key.subkey | \u5d4c\u5957\u5c5e\u6027 | $.address.city |<\/p>\n | $.key[index] | \u6570\u7ec4\u5143\u7d20 | $.hobbies[0] |<\/p>\n | $.key[] | \u6240\u6709\u6570\u7ec4\u5143\u7d20 | $.hobbies[] |<\/p>\n JSON_QUERY\u51fd\u6570\u7528\u4e8e\u4eceJSON\u5b57\u7b26\u4e32\u4e2d\u63d0\u53d6\u5bf9\u8c61\u6216\u6570\u7ec4\u7247\u6bb5,\u8fd4\u56deJSON\u683c\u5f0f\u7684\u5b57\u7b26\u4e32\u3002<\/p>\n \u8bed\u6cd5\u683c\u5f0f:<\/p>\n JSON_QUERY(json_string, json_path)<\/p>\n \u793a\u4f8b:<\/p>\n — \u63d2\u5165\u5305\u542b\u6570\u7ec4\u548c\u5d4c\u5957\u5bf9\u8c61\u7684\u6570\u636e JSON_EXISTS\u51fd\u6570\u7528\u4e8e\u5224\u65adJSON\u5b57\u7b26\u4e32\u4e2d\u662f\u5426\u5b58\u5728\u6307\u5b9a\u8def\u5f84\u7684\u503c,\u8fd4\u56de\u5e03\u5c14\u503cTRUE\u6216FALSE\u3002<\/p>\n \u8bed\u6cd5\u683c\u5f0f:<\/p>\n JSON_EXISTS(json_string, json_path)<\/p>\n \u793a\u4f8b:<\/p>\n — \u5224\u65ad\u5c5e\u6027\u662f\u5426\u5b58\u5728 JSON_OBJECT\u51fd\u6570\u7528\u4e8e\u6784\u5efaJSON\u5bf9\u8c61,\u5c06\u952e\u503c\u5bf9\u8f6c\u6362\u4e3aJSON\u683c\u5f0f\u5b57\u7b26\u4e32\u3002<\/p>\n \u8bed\u6cd5\u683c\u5f0f:<\/p>\n JSON_OBJECT(key1 VALUE value1, key2 VALUE value2, …)<\/p>\n \u793a\u4f8b:<\/p>\n — \u6784\u5efa\u7b80\u5355JSON\u5bf9\u8c61 JSON_ARRAY\u51fd\u6570\u7528\u4e8e\u6784\u5efaJSON\u6570\u7ec4,\u5c06\u591a\u4e2a\u503c\u7ec4\u5408\u6210JSON\u6570\u7ec4\u683c\u5f0f\u5b57\u7b26\u4e32\u3002<\/p>\n \u8bed\u6cd5\u683c\u5f0f:<\/p>\n JSON_ARRAY(value1, value2, …)<\/p>\n \u793a\u4f8b:<\/p>\n — \u6784\u5efa\u7b80\u5355\u6570\u7ec4 JSON_TABLE\u51fd\u6570\u662fDM8\u4e2d\u529f\u80fd\u6700\u5f3a\u5927\u7684JSON\u5904\u7406\u51fd\u6570,\u5b83\u53ef\u4ee5\u5c06JSON\u6570\u636e\u8f6c\u6362\u4e3a\u5173\u7cfb\u8868\u683c\u5f0f,\u4fbf\u4e8e\u8fdb\u884cSQL\u67e5\u8be2\u548c\u5206\u6790\u3002<\/p>\n \u8bed\u6cd5\u683c\u5f0f:<\/p>\n JSON_TABLE(json_string, json_path COLUMNS ( \u793a\u4f8b:<\/p>\n — \u521b\u5efa\u5305\u542bJSON\u6570\u7ec4\u7684\u6d4b\u8bd5\u6570\u636e \u672c\u8282\u901a\u8fc7\u5b9e\u9645\u6848\u4f8b\u6f14\u793a\u5982\u4f55\u4f7f\u7528JSON\u51fd\u6570\u8fdb\u884c\u6570\u636e\u67e5\u8be2\u548c\u63d0\u53d6\u3002<\/p>\n \u6848\u4f8b\u4e00:\u7535\u5546\u8ba2\u5355\u6570\u636e\u67e5\u8be2<\/p>\n — \u521b\u5efa\u8ba2\u5355\u8868 \u6848\u4f8b\u4e8c:\u65e5\u5fd7\u6570\u636e\u5206\u6790<\/p>\n — \u521b\u5efa\u65e5\u5fd7\u8868 \u672c\u8282\u6f14\u793a\u5982\u4f55\u4f7f\u7528JSON\u51fd\u6570\u6784\u5efa\u548c\u4fee\u6539JSON\u6570\u636e\u3002<\/p>\n \u6848\u4f8b\u4e00:\u52a8\u6001\u6784\u5efaJSON\u914d\u7f6e<\/p>\n — \u521b\u5efa\u914d\u7f6e\u8868 \u6848\u4f8b\u4e8c:JSON\u6570\u636e\u66f4\u65b0<\/p>\n — \u521b\u5efa\u7528\u6237\u6269\u5c55\u4fe1\u606f\u8868 \u672c\u8282\u6f14\u793aJSON\u6570\u636e\u4e0e\u5173\u7cfb\u6570\u636e\u4e4b\u95f4\u7684\u76f8\u4e92\u8f6c\u6362\u3002<\/p>\n \u6848\u4f8b\u4e00:JSON\u6570\u7ec4\u5c55\u5f00\u4e3a\u5173\u7cfb\u8868<\/p>\n — \u521b\u5efa\u5305\u542bJSON\u6570\u7ec4\u7684\u5546\u54c1\u8868 \u6848\u4f8b\u4e8c:\u5173\u7cfb\u6570\u636e\u805a\u5408\u4e3aJSON<\/p>\n — \u521b\u5efa\u90e8\u95e8\u5458\u5de5\u8868 \u5bf9\u4e8e\u9891\u7e41\u67e5\u8be2\u7684JSON\u5b57\u6bb5,\u5efa\u8bae\u5efa\u7acb\u51fd\u6570\u7d22\u5f15\u4ee5\u63d0\u9ad8\u67e5\u8be2\u6027\u80fd\u3002<\/p>\n — \u4e3aJSON\u5b57\u6bb5\u521b\u5efa\u51fd\u6570\u7d22\u5f15 \u7d22\u5f15\u4f18\u5316\u6d41\u7a0b:<\/p>\n #publish-mermaid-1786238292356-3{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}@keyframes edge-animation-frame{from{stroke-dashoffset:0;}}@keyframes dash{to{stroke-dashoffset:0;}}#publish-mermaid-1786238292356-3 .edge-animation-slow{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 50s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238292356-3 .edge-animation-fast{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 20s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238292356-3 .error-icon{fill:#552222;}#publish-mermaid-1786238292356-3 .error-text{fill:#552222;stroke:#552222;}#publish-mermaid-1786238292356-3 .edge-thickness-normal{stroke-width:1px;}#publish-mermaid-1786238292356-3 .edge-thickness-thick{stroke-width:3.5px;}#publish-mermaid-1786238292356-3 .edge-pattern-solid{stroke-dasharray:0;}#publish-mermaid-1786238292356-3 .edge-thickness-invisible{stroke-width:0;fill:none;}#publish-mermaid-1786238292356-3 .edge-pattern-dashed{stroke-dasharray:3;}#publish-mermaid-1786238292356-3 .edge-pattern-dotted{stroke-dasharray:2;}#publish-mermaid-1786238292356-3 .marker{fill:#333333;stroke:#333333;}#publish-mermaid-1786238292356-3 .marker.cross{stroke:#333333;}#publish-mermaid-1786238292356-3 svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#publish-mermaid-1786238292356-3 p{margin:0;}#publish-mermaid-1786238292356-3 .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#publish-mermaid-1786238292356-3 .cluster-label text{fill:#333;}#publish-mermaid-1786238292356-3 .cluster-label span{color:#333;}#publish-mermaid-1786238292356-3 .cluster-label span p{background-color:transparent;}#publish-mermaid-1786238292356-3 .label text,#publish-mermaid-1786238292356-3 span{fill:#333;color:#333;}#publish-mermaid-1786238292356-3 .node rect,#publish-mermaid-1786238292356-3 .node circle,#publish-mermaid-1786238292356-3 .node ellipse,#publish-mermaid-1786238292356-3 .node polygon,#publish-mermaid-1786238292356-3 .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238292356-3 .rough-node .label text,#publish-mermaid-1786238292356-3 .node .label text,#publish-mermaid-1786238292356-3 .image-shape .label,#publish-mermaid-1786238292356-3 .icon-shape .label{text-anchor:middle;}#publish-mermaid-1786238292356-3 .node .katex path{fill:#000;stroke:#000;stroke-width:1px;}#publish-mermaid-1786238292356-3 .rough-node .label,#publish-mermaid-1786238292356-3 .node .label,#publish-mermaid-1786238292356-3 .image-shape .label,#publish-mermaid-1786238292356-3 .icon-shape .label{text-align:center;}#publish-mermaid-1786238292356-3 .node.clickable{cursor:pointer;}#publish-mermaid-1786238292356-3 .root .anchor path{fill:#333333!important;stroke-width:0;stroke:#333333;}#publish-mermaid-1786238292356-3 .arrowheadPath{fill:#333333;}#publish-mermaid-1786238292356-3 .edgePath .path{stroke:#333333;stroke-width:1px;}#publish-mermaid-1786238292356-3 .flowchart-link{stroke:#333333;fill:none;}#publish-mermaid-1786238292356-3 .edgeLabel{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238292356-3 .edgeLabel p{background-color:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292356-3 .edgeLabel rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292356-3 .labelBkg{background-color:rgba(232, 232, 232, 0.5);}#publish-mermaid-1786238292356-3 .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#publish-mermaid-1786238292356-3 .cluster text{fill:#333;}#publish-mermaid-1786238292356-3 .cluster span{color:#333;}#publish-mermaid-1786238292356-3 div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#publish-mermaid-1786238292356-3 .flowchartTitleText{text-anchor:middle;font-size:18px;fill:#333;}#publish-mermaid-1786238292356-3 rect.text{fill:none;stroke-width:0;}#publish-mermaid-1786238292356-3 .icon-shape,#publish-mermaid-1786238292356-3 .image-shape{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238292356-3 .icon-shape p,#publish-mermaid-1786238292356-3 .image-shape p{background-color:rgba(232,232,232, 0.8);padding:2px;}#publish-mermaid-1786238292356-3 .icon-shape .label rect,#publish-mermaid-1786238292356-3 .image-shape .label rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292356-3 .label-icon{display:inline-block;height:1em;overflow:visible;vertical-align:-0.125em;}#publish-mermaid-1786238292356-3 .node .label-icon path{fill:currentColor;stroke:revert;stroke-width:revert;}#publish-mermaid-1786238292356-3 .node .neo-node{stroke:#9370DB;}#publish-mermaid-1786238292356-3 [data-look=\\”neo\\”].node rect,#publish-mermaid-1786238292356-3 [data-look=\\”neo\\”].cluster rect,#publish-mermaid-1786238292356-3 [data-look=\\”neo\\”].node polygon{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292356-3 [data-look=\\”neo\\”].swimlane.cluster rect{filter:none;}#publish-mermaid-1786238292356-3 [data-look=\\”neo\\”].node path{stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238292356-3 [data-look=\\”neo\\”].node .outer-path{filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292356-3 [data-look=\\”neo\\”].node .neo-line path{stroke:#9370DB;filter:none;}#publish-mermaid-1786238292356-3 [data-look=\\”neo\\”].node circle{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292356-3 [data-look=\\”neo\\”].node circle .state-start{fill:#000000;}#publish-mermaid-1786238292356-3 [data-look=\\”neo\\”].icon-shape .icon{fill:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292356-3 [data-look=\\”neo\\”].icon-shape .icon-neo path{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292356-3 :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;}\u9ad8\u9891\u67e5\u8be2\u4f4e\u9891\u67e5\u8be2\u662f\u5426<\/p>\n JSON\u67e5\u8be2\u9700\u6c42<\/p>\n <\/span><\/p>\n \u67e5\u8be2\u9891\u7387<\/p>\n <\/span><\/p>\n \u521b\u5efa\u51fd\u6570\u7d22\u5f15<\/p>\n <\/span><\/p>\n \u5168\u8868\u626b\u63cf<\/p>\n <\/span><\/p>\n \u5206\u6790\u67e5\u8be2\u6761\u4ef6<\/p>\n <\/span><\/p>\n \u5355\u5b57\u6bb5\u67e5\u8be2<\/p>\n <\/span><\/p>\n \u591a\u5b57\u6bb5\u67e5\u8be2<\/p>\n <\/span><\/p>\n \u5355\u5b57\u6bb5\u51fd\u6570\u7d22\u5f15<\/p>\n <\/span><\/p>\n \u590d\u5408\u51fd\u6570\u7d22\u5f15<\/p>\n <\/span><\/p>\n \u9a8c\u8bc1\u6267\u884c\u8ba1\u5212<\/p>\n <\/span><\/p>\n \u662f\u5426\u8d70\u7d22\u5f15<\/p>\n <\/span><\/p>\n \u4f18\u5316\u5b8c\u6210<\/p>\n <\/span><\/p>\n \u8c03\u6574\u7d22\u5f15\u7b56\u7565<\/p>\n <\/span><\/p>\n — \u4f18\u5316\u524d:\u91cd\u590d\u89e3\u6790JSON \u67e5\u8be2\u4f18\u5316\u51b3\u7b56\u6d41\u7a0b:<\/p>\n #publish-mermaid-1786238292489-4{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}@keyframes edge-animation-frame{from{stroke-dashoffset:0;}}@keyframes dash{to{stroke-dashoffset:0;}}#publish-mermaid-1786238292489-4 .edge-animation-slow{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 50s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238292489-4 .edge-animation-fast{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 20s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238292489-4 .error-icon{fill:#552222;}#publish-mermaid-1786238292489-4 .error-text{fill:#552222;stroke:#552222;}#publish-mermaid-1786238292489-4 .edge-thickness-normal{stroke-width:1px;}#publish-mermaid-1786238292489-4 .edge-thickness-thick{stroke-width:3.5px;}#publish-mermaid-1786238292489-4 .edge-pattern-solid{stroke-dasharray:0;}#publish-mermaid-1786238292489-4 .edge-thickness-invisible{stroke-width:0;fill:none;}#publish-mermaid-1786238292489-4 .edge-pattern-dashed{stroke-dasharray:3;}#publish-mermaid-1786238292489-4 .edge-pattern-dotted{stroke-dasharray:2;}#publish-mermaid-1786238292489-4 .marker{fill:#333333;stroke:#333333;}#publish-mermaid-1786238292489-4 .marker.cross{stroke:#333333;}#publish-mermaid-1786238292489-4 svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#publish-mermaid-1786238292489-4 p{margin:0;}#publish-mermaid-1786238292489-4 .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#publish-mermaid-1786238292489-4 .cluster-label text{fill:#333;}#publish-mermaid-1786238292489-4 .cluster-label span{color:#333;}#publish-mermaid-1786238292489-4 .cluster-label span p{background-color:transparent;}#publish-mermaid-1786238292489-4 .label text,#publish-mermaid-1786238292489-4 span{fill:#333;color:#333;}#publish-mermaid-1786238292489-4 .node rect,#publish-mermaid-1786238292489-4 .node circle,#publish-mermaid-1786238292489-4 .node ellipse,#publish-mermaid-1786238292489-4 .node polygon,#publish-mermaid-1786238292489-4 .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238292489-4 .rough-node .label text,#publish-mermaid-1786238292489-4 .node .label text,#publish-mermaid-1786238292489-4 .image-shape .label,#publish-mermaid-1786238292489-4 .icon-shape .label{text-anchor:middle;}#publish-mermaid-1786238292489-4 .node .katex path{fill:#000;stroke:#000;stroke-width:1px;}#publish-mermaid-1786238292489-4 .rough-node .label,#publish-mermaid-1786238292489-4 .node .label,#publish-mermaid-1786238292489-4 .image-shape .label,#publish-mermaid-1786238292489-4 .icon-shape .label{text-align:center;}#publish-mermaid-1786238292489-4 .node.clickable{cursor:pointer;}#publish-mermaid-1786238292489-4 .root .anchor path{fill:#333333!important;stroke-width:0;stroke:#333333;}#publish-mermaid-1786238292489-4 .arrowheadPath{fill:#333333;}#publish-mermaid-1786238292489-4 .edgePath .path{stroke:#333333;stroke-width:1px;}#publish-mermaid-1786238292489-4 .flowchart-link{stroke:#333333;fill:none;}#publish-mermaid-1786238292489-4 .edgeLabel{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238292489-4 .edgeLabel p{background-color:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292489-4 .edgeLabel rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292489-4 .labelBkg{background-color:rgba(232, 232, 232, 0.5);}#publish-mermaid-1786238292489-4 .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#publish-mermaid-1786238292489-4 .cluster text{fill:#333;}#publish-mermaid-1786238292489-4 .cluster span{color:#333;}#publish-mermaid-1786238292489-4 div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#publish-mermaid-1786238292489-4 .flowchartTitleText{text-anchor:middle;font-size:18px;fill:#333;}#publish-mermaid-1786238292489-4 rect.text{fill:none;stroke-width:0;}#publish-mermaid-1786238292489-4 .icon-shape,#publish-mermaid-1786238292489-4 .image-shape{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238292489-4 .icon-shape p,#publish-mermaid-1786238292489-4 .image-shape p{background-color:rgba(232,232,232, 0.8);padding:2px;}#publish-mermaid-1786238292489-4 .icon-shape .label rect,#publish-mermaid-1786238292489-4 .image-shape .label rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292489-4 .label-icon{display:inline-block;height:1em;overflow:visible;vertical-align:-0.125em;}#publish-mermaid-1786238292489-4 .node .label-icon path{fill:currentColor;stroke:revert;stroke-width:revert;}#publish-mermaid-1786238292489-4 .node .neo-node{stroke:#9370DB;}#publish-mermaid-1786238292489-4 [data-look=\\”neo\\”].node rect,#publish-mermaid-1786238292489-4 [data-look=\\”neo\\”].cluster rect,#publish-mermaid-1786238292489-4 [data-look=\\”neo\\”].node polygon{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292489-4 [data-look=\\”neo\\”].swimlane.cluster rect{filter:none;}#publish-mermaid-1786238292489-4 [data-look=\\”neo\\”].node path{stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238292489-4 [data-look=\\”neo\\”].node .outer-path{filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292489-4 [data-look=\\”neo\\”].node .neo-line path{stroke:#9370DB;filter:none;}#publish-mermaid-1786238292489-4 [data-look=\\”neo\\”].node circle{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292489-4 [data-look=\\”neo\\”].node circle .state-start{fill:#000000;}#publish-mermaid-1786238292489-4 [data-look=\\”neo\\”].icon-shape .icon{fill:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292489-4 [data-look=\\”neo\\”].icon-shape .icon-neo path{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292489-4 :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;}\u5355\u503c\u63d0\u53d6\u7247\u6bb5\u63d0\u53d6\u6570\u7ec4\u5c55\u5f00\u6761\u4ef6\u5224\u65ad\u662f\u5426\u662f\u5426<\/p>\n JSON\u67e5\u8be2<\/p>\n <\/span><\/p>\n \u67e5\u8be2\u7c7b\u578b<\/p>\n <\/span><\/p>\n JSON_VALUE<\/p>\n <\/span><\/p>\n JSON_QUERY<\/p>\n <\/span><\/p>\n JSON_TABLE<\/p>\n <\/span><\/p>\n JSON_EXISTS<\/p>\n <\/span><\/p>\n \u591a\u6b21\u63d0\u53d6\u540c\u4e00JSON<\/p>\n <\/span><\/p>\n \u4f7f\u7528CTE\/\u5b50\u67e5\u8be2<\/p>\n <\/span><\/p>\n \u76f4\u63a5\u4f7f\u7528<\/p>\n <\/span><\/p>\n \u9700\u8981\u7c7b\u578b\u8f6c\u6362<\/p>\n <\/span><\/p>\n \u5728COLUMNS\u4e2d\u6307\u5b9a\u7c7b\u578b<\/p>\n <\/span><\/p>\n \u4f7f\u7528\u9ed8\u8ba4VARCHAR<\/p>\n <\/span><\/p>\n \u4f18\u5316\u5b8c\u6210<\/p>\n <\/span><\/p>\n \u95ee\u9898\u4e00:JSON_VALUE\u8fd4\u56deNULL<\/p>\n — \u539f\u56e0:\u8def\u5f84\u4e0d\u5b58\u5728\u6216\u503c\u4e0d\u662f\u6807\u91cf \u95ee\u9898\u4e8c:\u6570\u5b57\u6bd4\u8f83\u4e0d\u6b63\u786e<\/p>\n — \u539f\u56e0:JSON_VALUE\u8fd4\u56de\u5b57\u7b26\u4e32,\u9700\u8981CAST\u8f6c\u6362 \u95ee\u9898\u4e09:JSON\u683c\u5f0f\u6821\u9a8c<\/p>\n — \u4f7f\u7528IS JSON\u6761\u4ef6\u6821\u9a8c \u95ee\u9898\u6392\u67e5\u6d41\u7a0b:<\/p>\n #publish-mermaid-1786238292846-5{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}@keyframes edge-animation-frame{from{stroke-dashoffset:0;}}@keyframes dash{to{stroke-dashoffset:0;}}#publish-mermaid-1786238292846-5 .edge-animation-slow{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 50s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238292846-5 .edge-animation-fast{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 20s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238292846-5 .error-icon{fill:#552222;}#publish-mermaid-1786238292846-5 .error-text{fill:#552222;stroke:#552222;}#publish-mermaid-1786238292846-5 .edge-thickness-normal{stroke-width:1px;}#publish-mermaid-1786238292846-5 .edge-thickness-thick{stroke-width:3.5px;}#publish-mermaid-1786238292846-5 .edge-pattern-solid{stroke-dasharray:0;}#publish-mermaid-1786238292846-5 .edge-thickness-invisible{stroke-width:0;fill:none;}#publish-mermaid-1786238292846-5 .edge-pattern-dashed{stroke-dasharray:3;}#publish-mermaid-1786238292846-5 .edge-pattern-dotted{stroke-dasharray:2;}#publish-mermaid-1786238292846-5 .marker{fill:#333333;stroke:#333333;}#publish-mermaid-1786238292846-5 .marker.cross{stroke:#333333;}#publish-mermaid-1786238292846-5 svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#publish-mermaid-1786238292846-5 p{margin:0;}#publish-mermaid-1786238292846-5 .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#publish-mermaid-1786238292846-5 .cluster-label text{fill:#333;}#publish-mermaid-1786238292846-5 .cluster-label span{color:#333;}#publish-mermaid-1786238292846-5 .cluster-label span p{background-color:transparent;}#publish-mermaid-1786238292846-5 .label text,#publish-mermaid-1786238292846-5 span{fill:#333;color:#333;}#publish-mermaid-1786238292846-5 .node rect,#publish-mermaid-1786238292846-5 .node circle,#publish-mermaid-1786238292846-5 .node ellipse,#publish-mermaid-1786238292846-5 .node polygon,#publish-mermaid-1786238292846-5 .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238292846-5 .rough-node .label text,#publish-mermaid-1786238292846-5 .node .label text,#publish-mermaid-1786238292846-5 .image-shape .label,#publish-mermaid-1786238292846-5 .icon-shape .label{text-anchor:middle;}#publish-mermaid-1786238292846-5 .node .katex path{fill:#000;stroke:#000;stroke-width:1px;}#publish-mermaid-1786238292846-5 .rough-node .label,#publish-mermaid-1786238292846-5 .node .label,#publish-mermaid-1786238292846-5 .image-shape .label,#publish-mermaid-1786238292846-5 .icon-shape .label{text-align:center;}#publish-mermaid-1786238292846-5 .node.clickable{cursor:pointer;}#publish-mermaid-1786238292846-5 .root .anchor path{fill:#333333!important;stroke-width:0;stroke:#333333;}#publish-mermaid-1786238292846-5 .arrowheadPath{fill:#333333;}#publish-mermaid-1786238292846-5 .edgePath .path{stroke:#333333;stroke-width:1px;}#publish-mermaid-1786238292846-5 .flowchart-link{stroke:#333333;fill:none;}#publish-mermaid-1786238292846-5 .edgeLabel{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238292846-5 .edgeLabel p{background-color:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292846-5 .edgeLabel rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292846-5 .labelBkg{background-color:rgba(232, 232, 232, 0.5);}#publish-mermaid-1786238292846-5 .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#publish-mermaid-1786238292846-5 .cluster text{fill:#333;}#publish-mermaid-1786238292846-5 .cluster span{color:#333;}#publish-mermaid-1786238292846-5 div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#publish-mermaid-1786238292846-5 .flowchartTitleText{text-anchor:middle;font-size:18px;fill:#333;}#publish-mermaid-1786238292846-5 rect.text{fill:none;stroke-width:0;}#publish-mermaid-1786238292846-5 .icon-shape,#publish-mermaid-1786238292846-5 .image-shape{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238292846-5 .icon-shape p,#publish-mermaid-1786238292846-5 .image-shape p{background-color:rgba(232,232,232, 0.8);padding:2px;}#publish-mermaid-1786238292846-5 .icon-shape .label rect,#publish-mermaid-1786238292846-5 .image-shape .label rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292846-5 .label-icon{display:inline-block;height:1em;overflow:visible;vertical-align:-0.125em;}#publish-mermaid-1786238292846-5 .node .label-icon path{fill:currentColor;stroke:revert;stroke-width:revert;}#publish-mermaid-1786238292846-5 .node .neo-node{stroke:#9370DB;}#publish-mermaid-1786238292846-5 [data-look=\\”neo\\”].node rect,#publish-mermaid-1786238292846-5 [data-look=\\”neo\\”].cluster rect,#publish-mermaid-1786238292846-5 [data-look=\\”neo\\”].node polygon{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292846-5 [data-look=\\”neo\\”].swimlane.cluster rect{filter:none;}#publish-mermaid-1786238292846-5 [data-look=\\”neo\\”].node path{stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238292846-5 [data-look=\\”neo\\”].node .outer-path{filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292846-5 [data-look=\\”neo\\”].node .neo-line path{stroke:#9370DB;filter:none;}#publish-mermaid-1786238292846-5 [data-look=\\”neo\\”].node circle{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292846-5 [data-look=\\”neo\\”].node circle .state-start{fill:#000000;}#publish-mermaid-1786238292846-5 [data-look=\\”neo\\”].icon-shape .icon{fill:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292846-5 [data-look=\\”neo\\”].icon-shape .icon-neo path{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292846-5 :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;}\u8fd4\u56deNULL\u7c7b\u578b\u9519\u8bef\u8bed\u6cd5\u9519\u8bef\u6027\u80fd\u95ee\u9898<\/p>\n JSON\u51fd\u6570\u5f02\u5e38<\/p>\n <\/span><\/p>\n \u5f02\u5e38\u7c7b\u578b<\/p>\n <\/span><\/p>\n \u68c0\u67e5\u8def\u5f84\u662f\u5426\u5b58\u5728<\/p>\n <\/span><\/p>\n \u68c0\u67e5\u662f\u5426\u9700\u8981CAST<\/p>\n <\/span><\/p>\n \u68c0\u67e5JSON\u683c\u5f0f<\/p>\n <\/span><\/p>\n \u68c0\u67e5\u7d22\u5f15\u4f7f\u7528<\/p>\n <\/span><\/p>\n \u4f7f\u7528JSON_EXISTS\u5224\u65ad<\/p>\n <\/span><\/p>\n \u6dfb\u52a0CAST\u8f6c\u6362<\/p>\n <\/span><\/p>\n \u4f7f\u7528IS JSON\u6821\u9a8c<\/p>\n <\/span><\/p>\n \u521b\u5efa\u51fd\u6570\u7d22\u5f15<\/p>\n <\/span><\/p>\n \u95ee\u9898\u89e3\u51b3<\/p>\n <\/span><\/p>\n #publish-mermaid-1786238292972-6{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}@keyframes edge-animation-frame{from{stroke-dashoffset:0;}}@keyframes dash{to{stroke-dashoffset:0;}}#publish-mermaid-1786238292972-6 .edge-animation-slow{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 50s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238292972-6 .edge-animation-fast{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 20s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238292972-6 .error-icon{fill:#552222;}#publish-mermaid-1786238292972-6 .error-text{fill:#552222;stroke:#552222;}#publish-mermaid-1786238292972-6 .edge-thickness-normal{stroke-width:1px;}#publish-mermaid-1786238292972-6 .edge-thickness-thick{stroke-width:3.5px;}#publish-mermaid-1786238292972-6 .edge-pattern-solid{stroke-dasharray:0;}#publish-mermaid-1786238292972-6 .edge-thickness-invisible{stroke-width:0;fill:none;}#publish-mermaid-1786238292972-6 .edge-pattern-dashed{stroke-dasharray:3;}#publish-mermaid-1786238292972-6 .edge-pattern-dotted{stroke-dasharray:2;}#publish-mermaid-1786238292972-6 .marker{fill:#333333;stroke:#333333;}#publish-mermaid-1786238292972-6 .marker.cross{stroke:#333333;}#publish-mermaid-1786238292972-6 svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#publish-mermaid-1786238292972-6 p{margin:0;}#publish-mermaid-1786238292972-6 .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#publish-mermaid-1786238292972-6 .cluster-label text{fill:#333;}#publish-mermaid-1786238292972-6 .cluster-label span{color:#333;}#publish-mermaid-1786238292972-6 .cluster-label span p{background-color:transparent;}#publish-mermaid-1786238292972-6 .label text,#publish-mermaid-1786238292972-6 span{fill:#333;color:#333;}#publish-mermaid-1786238292972-6 .node rect,#publish-mermaid-1786238292972-6 .node circle,#publish-mermaid-1786238292972-6 .node ellipse,#publish-mermaid-1786238292972-6 .node polygon,#publish-mermaid-1786238292972-6 .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238292972-6 .rough-node .label text,#publish-mermaid-1786238292972-6 .node .label text,#publish-mermaid-1786238292972-6 .image-shape .label,#publish-mermaid-1786238292972-6 .icon-shape .label{text-anchor:middle;}#publish-mermaid-1786238292972-6 .node .katex path{fill:#000;stroke:#000;stroke-width:1px;}#publish-mermaid-1786238292972-6 .rough-node .label,#publish-mermaid-1786238292972-6 .node .label,#publish-mermaid-1786238292972-6 .image-shape .label,#publish-mermaid-1786238292972-6 .icon-shape .label{text-align:center;}#publish-mermaid-1786238292972-6 .node.clickable{cursor:pointer;}#publish-mermaid-1786238292972-6 .root .anchor path{fill:#333333!important;stroke-width:0;stroke:#333333;}#publish-mermaid-1786238292972-6 .arrowheadPath{fill:#333333;}#publish-mermaid-1786238292972-6 .edgePath .path{stroke:#333333;stroke-width:1px;}#publish-mermaid-1786238292972-6 .flowchart-link{stroke:#333333;fill:none;}#publish-mermaid-1786238292972-6 .edgeLabel{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238292972-6 .edgeLabel p{background-color:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292972-6 .edgeLabel rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292972-6 .labelBkg{background-color:rgba(232, 232, 232, 0.5);}#publish-mermaid-1786238292972-6 .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#publish-mermaid-1786238292972-6 .cluster text{fill:#333;}#publish-mermaid-1786238292972-6 .cluster span{color:#333;}#publish-mermaid-1786238292972-6 div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#publish-mermaid-1786238292972-6 .flowchartTitleText{text-anchor:middle;font-size:18px;fill:#333;}#publish-mermaid-1786238292972-6 rect.text{fill:none;stroke-width:0;}#publish-mermaid-1786238292972-6 .icon-shape,#publish-mermaid-1786238292972-6 .image-shape{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238292972-6 .icon-shape p,#publish-mermaid-1786238292972-6 .image-shape p{background-color:rgba(232,232,232, 0.8);padding:2px;}#publish-mermaid-1786238292972-6 .icon-shape .label rect,#publish-mermaid-1786238292972-6 .image-shape .label rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238292972-6 .label-icon{display:inline-block;height:1em;overflow:visible;vertical-align:-0.125em;}#publish-mermaid-1786238292972-6 .node .label-icon path{fill:currentColor;stroke:revert;stroke-width:revert;}#publish-mermaid-1786238292972-6 .node .neo-node{stroke:#9370DB;}#publish-mermaid-1786238292972-6 [data-look=\\”neo\\”].node rect,#publish-mermaid-1786238292972-6 [data-look=\\”neo\\”].cluster rect,#publish-mermaid-1786238292972-6 [data-look=\\”neo\\”].node polygon{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292972-6 [data-look=\\”neo\\”].swimlane.cluster rect{filter:none;}#publish-mermaid-1786238292972-6 [data-look=\\”neo\\”].node path{stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238292972-6 [data-look=\\”neo\\”].node .outer-path{filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292972-6 [data-look=\\”neo\\”].node .neo-line path{stroke:#9370DB;filter:none;}#publish-mermaid-1786238292972-6 [data-look=\\”neo\\”].node circle{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292972-6 [data-look=\\”neo\\”].node circle .state-start{fill:#000000;}#publish-mermaid-1786238292972-6 [data-look=\\”neo\\”].icon-shape .icon{fill:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292972-6 [data-look=\\”neo\\”].icon-shape .icon-neo path{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238292972-6 :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;}<\/p>\n DM8 JSON\u51fd\u6570\u5e94\u7528<\/p>\n <\/span><\/p>\n \u67e5\u8be2\u63d0\u53d6<\/p>\n <\/span><\/p>\n \u6570\u636e\u6784\u5efa<\/p>\n <\/span><\/p>\n \u6570\u636e\u8f6c\u6362<\/p>\n <\/span><\/p>\n \u6027\u80fd\u4f18\u5316<\/p>\n <\/span><\/p>\n JSON_VALUE: \u6807\u91cf\u503c\u63d0\u53d6<\/p>\n <\/span><\/p>\n JSON_QUERY: \u5bf9\u8c61\/\u6570\u7ec4\u63d0\u53d6<\/p>\n <\/span><\/p>\n JSON_EXISTS: \u8def\u5f84\u5b58\u5728\u5224\u65ad<\/p>\n <\/span><\/p>\n JSON_OBJECT: \u5bf9\u8c61\u6784\u5efa<\/p>\n <\/span><\/p>\n JSON_ARRAY: \u6570\u7ec4\u6784\u5efa<\/p>\n <\/span><\/p>\n JSON_ARRAYAGG: \u805a\u5408\u4e3a\u6570\u7ec4<\/p>\n <\/span><\/p>\n JSON_TABLE: JSON\u8f6c\u5173\u7cfb\u8868<\/p>\n <\/span><\/p>\n \u5173\u7cfb\u6570\u636e\u8f6cJSON\u5bf9\u8c61<\/p>\n <\/span><\/p>\n \u51fd\u6570\u7d22\u5f15\u4f18\u5316<\/p>\n <\/span><\/p>\n CTE\u51cf\u5c11\u91cd\u590d\u89e3\u6790<\/p>\n <\/span><\/p>\n \u7c7b\u578b\u8f6c\u6362\u4f18\u5316<\/p>\n <\/span><\/p>\n \u51fd\u6570\u9009\u62e9\u6307\u5357:<\/p>\n #publish-mermaid-1786238293100-7{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}@keyframes edge-animation-frame{from{stroke-dashoffset:0;}}@keyframes dash{to{stroke-dashoffset:0;}}#publish-mermaid-1786238293100-7 .edge-animation-slow{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 50s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238293100-7 .edge-animation-fast{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 20s linear infinite;stroke-linecap:round;}#publish-mermaid-1786238293100-7 .error-icon{fill:#552222;}#publish-mermaid-1786238293100-7 .error-text{fill:#552222;stroke:#552222;}#publish-mermaid-1786238293100-7 .edge-thickness-normal{stroke-width:1px;}#publish-mermaid-1786238293100-7 .edge-thickness-thick{stroke-width:3.5px;}#publish-mermaid-1786238293100-7 .edge-pattern-solid{stroke-dasharray:0;}#publish-mermaid-1786238293100-7 .edge-thickness-invisible{stroke-width:0;fill:none;}#publish-mermaid-1786238293100-7 .edge-pattern-dashed{stroke-dasharray:3;}#publish-mermaid-1786238293100-7 .edge-pattern-dotted{stroke-dasharray:2;}#publish-mermaid-1786238293100-7 .marker{fill:#333333;stroke:#333333;}#publish-mermaid-1786238293100-7 .marker.cross{stroke:#333333;}#publish-mermaid-1786238293100-7 svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#publish-mermaid-1786238293100-7 p{margin:0;}#publish-mermaid-1786238293100-7 .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#publish-mermaid-1786238293100-7 .cluster-label text{fill:#333;}#publish-mermaid-1786238293100-7 .cluster-label span{color:#333;}#publish-mermaid-1786238293100-7 .cluster-label span p{background-color:transparent;}#publish-mermaid-1786238293100-7 .label text,#publish-mermaid-1786238293100-7 span{fill:#333;color:#333;}#publish-mermaid-1786238293100-7 .node rect,#publish-mermaid-1786238293100-7 .node circle,#publish-mermaid-1786238293100-7 .node ellipse,#publish-mermaid-1786238293100-7 .node polygon,#publish-mermaid-1786238293100-7 .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238293100-7 .rough-node .label text,#publish-mermaid-1786238293100-7 .node .label text,#publish-mermaid-1786238293100-7 .image-shape .label,#publish-mermaid-1786238293100-7 .icon-shape .label{text-anchor:middle;}#publish-mermaid-1786238293100-7 .node .katex path{fill:#000;stroke:#000;stroke-width:1px;}#publish-mermaid-1786238293100-7 .rough-node .label,#publish-mermaid-1786238293100-7 .node .label,#publish-mermaid-1786238293100-7 .image-shape .label,#publish-mermaid-1786238293100-7 .icon-shape .label{text-align:center;}#publish-mermaid-1786238293100-7 .node.clickable{cursor:pointer;}#publish-mermaid-1786238293100-7 .root .anchor path{fill:#333333!important;stroke-width:0;stroke:#333333;}#publish-mermaid-1786238293100-7 .arrowheadPath{fill:#333333;}#publish-mermaid-1786238293100-7 .edgePath .path{stroke:#333333;stroke-width:1px;}#publish-mermaid-1786238293100-7 .flowchart-link{stroke:#333333;fill:none;}#publish-mermaid-1786238293100-7 .edgeLabel{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238293100-7 .edgeLabel p{background-color:rgba(232,232,232, 0.8);}#publish-mermaid-1786238293100-7 .edgeLabel rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238293100-7 .labelBkg{background-color:rgba(232, 232, 232, 0.5);}#publish-mermaid-1786238293100-7 .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#publish-mermaid-1786238293100-7 .cluster text{fill:#333;}#publish-mermaid-1786238293100-7 .cluster span{color:#333;}#publish-mermaid-1786238293100-7 div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#publish-mermaid-1786238293100-7 .flowchartTitleText{text-anchor:middle;font-size:18px;fill:#333;}#publish-mermaid-1786238293100-7 rect.text{fill:none;stroke-width:0;}#publish-mermaid-1786238293100-7 .icon-shape,#publish-mermaid-1786238293100-7 .image-shape{background-color:rgba(232,232,232, 0.8);text-align:center;}#publish-mermaid-1786238293100-7 .icon-shape p,#publish-mermaid-1786238293100-7 .image-shape p{background-color:rgba(232,232,232, 0.8);padding:2px;}#publish-mermaid-1786238293100-7 .icon-shape .label rect,#publish-mermaid-1786238293100-7 .image-shape .label rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#publish-mermaid-1786238293100-7 .label-icon{display:inline-block;height:1em;overflow:visible;vertical-align:-0.125em;}#publish-mermaid-1786238293100-7 .node .label-icon path{fill:currentColor;stroke:revert;stroke-width:revert;}#publish-mermaid-1786238293100-7 .node .neo-node{stroke:#9370DB;}#publish-mermaid-1786238293100-7 [data-look=\\”neo\\”].node rect,#publish-mermaid-1786238293100-7 [data-look=\\”neo\\”].cluster rect,#publish-mermaid-1786238293100-7 [data-look=\\”neo\\”].node polygon{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238293100-7 [data-look=\\”neo\\”].swimlane.cluster rect{filter:none;}#publish-mermaid-1786238293100-7 [data-look=\\”neo\\”].node path{stroke:#9370DB;stroke-width:1px;}#publish-mermaid-1786238293100-7 [data-look=\\”neo\\”].node .outer-path{filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238293100-7 [data-look=\\”neo\\”].node .neo-line path{stroke:#9370DB;filter:none;}#publish-mermaid-1786238293100-7 [data-look=\\”neo\\”].node circle{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238293100-7 [data-look=\\”neo\\”].node circle .state-start{fill:#000000;}#publish-mermaid-1786238293100-7 [data-look=\\”neo\\”].icon-shape .icon{fill:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238293100-7 [data-look=\\”neo\\”].icon-shape .icon-neo path{stroke:#9370DB;filter:drop-shadow(1px 2px 2px rgba(185, 185, 185, 1));}#publish-mermaid-1786238293100-7 :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;}\u63d0\u53d6\u6807\u91cf\u503c\u63d0\u53d6\u5bf9\u8c61\/\u6570\u7ec4\u5224\u65ad\u8def\u5f84\u5b58\u5728\u6784\u5efaJSON\u5bf9\u8c61\u6784\u5efaJSON\u6570\u7ec4JSON\u8f6c\u5173\u7cfb\u8868\u805a\u5408\u4e3aJSON\u6570\u7ec4<\/p>\n JSON\u5904\u7406\u9700\u6c42<\/p>\n <\/span><\/p>\n \u9700\u6c42\u7c7b\u578b<\/p>\n <\/span><\/p>\n JSON_VALUE<\/p>\n <\/span><\/p>\n JSON_QUERY<\/p>\n <\/span><\/p>\n JSON_EXISTS<\/p>\n <\/span><\/p>\n JSON_OBJECT<\/p>\n <\/span><\/p>\n JSON_ARRAY<\/p>\n <\/span><\/p>\n JSON_TABLE<\/p>\n <\/span><\/p>\n JSON_ARRAYAGG<\/p>\n <\/span><\/p>\n \u8fd4\u56de: \u6807\u91cf\u503c<\/p>\n <\/span><\/p>\n \u8fd4\u56de: JSON\u5b57\u7b26\u4e32<\/p>\n <\/span><\/p>\n \u8fd4\u56de: BOOLEAN<\/p>\n <\/span><\/p>\n \u8fd4\u56de: JSON\u5bf9\u8c61\u5b57\u7b26\u4e32<\/p>\n <\/span><\/p>\n \u8fd4\u56de: JSON\u6570\u7ec4\u5b57\u7b26\u4e32<\/p>\n <\/span><\/p>\n \u8fd4\u56de: \u5173\u7cfb\u8868\u884c<\/p>\n <\/span><\/p>\n \u8fd4\u56de: JSON\u6570\u7ec4\u5b57\u7b26\u4e32<\/p>\n <\/span><\/p>\n \u901a\u8fc7\u672c\u6587\u7684\u8be6\u7ec6\u4ecb\u7ecd,\u76f8\u4fe1\u8bfb\u8005\u5df2\u7ecf\u5bf9DM8\u6570\u636e\u5e93\u4e2d\u7684JSON\u51fd\u6570\u6709\u4e86\u5168\u9762\u7684\u4e86\u89e3\u3002\u5728\u5b9e\u9645\u5f00\u53d1\u4e2d,\u5408\u7406\u4f7f\u7528JSON\u51fd\u6570\u53ef\u4ee5\u5927\u5927\u7b80\u5316\u534a\u7ed3\u6784\u5316\u6570\u636e\u7684\u5904\u7406\u6d41\u7a0b,\u63d0\u9ad8\u5f00\u53d1\u6548\u7387\u3002\u5efa\u8bae\u8bfb\u8005\u6839\u636e\u5b9e\u9645\u4e1a\u52a1\u9700\u6c42,\u9009\u62e9\u5408\u9002\u7684JSON\u51fd\u6570,\u5e76\u9075\u5faa\u6700\u4f73\u5b9e\u8df5\u8fdb\u884c\u4f18\u5316\u3002<\/p>\n","protected":false},"excerpt":{"rendered":" DM8 SQL\u8bed\u8a00\u4e2dJSON\u51fd\u6570\u5b9e\u6218：\u9ad8\u6548\u5904\u7406\u534a\u7ed3\u6784\u5316\u6570\u636e1.2 DM8\u5bf9JSON\u7684\u652f\u6301\u80fd\u529b<\/h4>\n
1.3 JSON\u51fd\u6570\u5e94\u7528\u573a\u666f\u5206\u6790<\/h4>\n
\u4e8c\u3001\u6838\u5fc3JSON\u51fd\u6570\u8be6\u89e3<\/h3>\n
2.1 JSON_VALUE\u51fd\u6570\u4f7f\u7528<\/h4>\n
\nCREATE TABLE json_test (
\n id INT,
\n info CLOB
\n);
\n— \u63d2\u5165\u6d4b\u8bd5\u6570\u636e
\nINSERT INTO json_test VALUES (1, '{"name": "zhangsan", "age": 30, "city": "beijing"}');
\nINSERT INTO json_test VALUES (2, '{"name": "lisi", "age": 25, "city": "shanghai"}');
\n— \u4f7f\u7528JSON_VALUE\u63d0\u53d6\u503c
\nSELECT id, JSON_VALUE(info, '$.name') AS name,
\n JSON_VALUE(info, '$.age') AS age,
\n JSON_VALUE(info, '$.city') AS city
\nFROM json_test;<\/p>\n2.2 JSON_QUERY\u51fd\u6570\u4f7f\u7528<\/h4>\n
\nINSERT INTO json_test VALUES (3, '{
\n "name": "wangwu",
\n "age": 28,
\n "hobbies": ["reading", "swimming", "coding"],
\n "address": {
\n "city": "guangzhou",
\n "street": "zhongshan road"
\n }
\n}');
\n— \u63d0\u53d6\u6570\u7ec4
\nSELECT JSON_QUERY(info, '$.hobbies') AS hobbies
\nFROM json_test WHERE id = 3;
\n— \u63d0\u53d6\u5d4c\u5957\u5bf9\u8c61
\nSELECT JSON_QUERY(info, '$.address') AS address
\nFROM json_test WHERE id = 3;
\n— \u63d0\u53d6\u6570\u7ec4\u4e2d\u7279\u5b9a\u5143\u7d20
\nSELECT JSON_QUERY(info, '$.hobbies[0]') AS first_hobby
\nFROM json_test WHERE id = 3;<\/p>\n2.3 JSON_EXISTS\u51fd\u6570\u4f7f\u7528<\/h4>\n
\nSELECT id, JSON_EXISTS(info, '$.address') AS has_address
\nFROM json_test;
\n— \u5728WHERE\u6761\u4ef6\u4e2d\u4f7f\u7528
\nSELECT id, JSON_VALUE(info, '$.name') AS name
\nFROM json_test
\nWHERE JSON_EXISTS(info, '$.address.city');
\n— \u5224\u65ad\u6570\u7ec4\u662f\u5426\u5b58\u5728
\nSELECT id
\nFROM json_test
\nWHERE JSON_EXISTS(info, '$.hobbies');<\/p>\n2.4 JSON_OBJECT\u51fd\u6570\u4f7f\u7528<\/h4>\n
\nSELECT JSON_OBJECT('name' VALUE 'zhaoliu', 'age' VALUE 35) AS json_obj;
\n— \u4ece\u8868\u6570\u636e\u6784\u5efaJSON
\nSELECT JSON_OBJECT(
\n 'id' VALUE id,
\n 'name' VALUE JSON_VALUE(info, '$.name'),
\n 'age' VALUE JSON_VALUE(info, '$.age')
\n) AS json_obj
\nFROM json_test;
\n— \u5d4c\u5957JSON\u5bf9\u8c61
\nSELECT JSON_OBJECT(
\n 'user' VALUE JSON_OBJECT(
\n 'name' VALUE 'qianqi',
\n 'age' VALUE 40
\n ),
\n 'role' VALUE 'admin'
\n) AS nested_json;<\/p>\n2.5 JSON_ARRAY\u51fd\u6570\u4f7f\u7528<\/h4>\n
\nSELECT JSON_ARRAY('apple', 'banana', 'cherry') AS fruits;
\n— \u6784\u5efa\u6570\u5b57\u6570\u7ec4
\nSELECT JSON_ARRAY(1, 2, 3, 4, 5) AS numbers;
\n— \u6784\u5efa\u6df7\u5408\u7c7b\u578b\u6570\u7ec4
\nSELECT JSON_ARRAY('test', 123, TRUE, NULL) AS mixed;
\n— \u805a\u5408\u6784\u5efa\u6570\u7ec4
\nSELECT JSON_ARRAYAGG(JSON_VALUE(info, '$.name')) AS all_names
\nFROM json_test;<\/p>\n2.6 JSON_TABLE\u51fd\u6570\u4f7f\u7528<\/h4>\n
\n column_name column_type PATH json_path,
\n column_name column_type PATH json_path,
\n …
\n))<\/p>\n
\nCREATE TABLE json_array_test (
\n id INT,
\n data CLOB
\n);
\nINSERT INTO json_array_test VALUES (1, '{
\n "department": "tech",
\n "employees": [
\n {"name": "zhangsan", "age": 30, "position": "engineer"},
\n {"name": "lisi", "age": 25, "position": "tester"},
\n {"name": "wangwu", "age": 28, "position": "pm"}
\n ]
\n}');
\n— \u4f7f\u7528JSON_TABLE\u5c55\u5f00\u6570\u7ec4
\nSELECT t.id,
\n jt.name,
\n jt.age,
\n jt.position
\nFROM json_array_test t,
\nJSON_TABLE(t.data, '$.employees[*]' COLUMNS (
\n name VARCHAR(50) PATH '$.name',
\n age INT PATH '$.age',
\n position VARCHAR(50) PATH '$.position'
\n)) jt;<\/p>\n\u4e09\u3001JSON\u51fd\u6570\u5b9e\u6218\u6848\u4f8b<\/h3>\n
3.1 JSON\u6570\u636e\u67e5\u8be2\u4e0e\u63d0\u53d6<\/h4>\n
\nCREATE TABLE orders (
\n order_id INT PRIMARY KEY,
\n customer_id INT,
\n order_info CLOB,
\n create_time TIMESTAMP
\n);
\n— \u63d2\u5165\u8ba2\u5355\u6570\u636e
\nINSERT INTO orders VALUES (1, 1001, '{
\n "product": "laptop",
\n "price": 5999,
\n "quantity": 1,
\n "attributes": {
\n "brand": "lenovo",
\n "model": "ThinkPad",
\n "color": "black"
\n },
\n "tags": ["electronics", "office", "premium"]
\n}', SYSDATE);
\nINSERT INTO orders VALUES (2, 1002, '{
\n "product": "phone",
\n "price": 3999,
\n "quantity": 2,
\n "attributes": {
\n "brand": "huawei",
\n "model": "Mate60",
\n "color": "white"
\n },
\n "tags": ["electronics", "mobile"]
\n}', SYSDATE);
\n— \u67e5\u8be2\u8ba2\u5355\u57fa\u672c\u4fe1\u606f
\nSELECT order_id,
\n customer_id,
\n JSON_VALUE(order_info, '$.product') AS product,
\n JSON_VALUE(order_info, '$.price') AS price,
\n JSON_VALUE(order_info, '$.quantity') AS quantity
\nFROM orders;
\n— \u67e5\u8be2\u8ba2\u5355\u5c5e\u6027
\nSELECT order_id,
\n JSON_VALUE(order_info, '$.attributes.brand') AS brand,
\n JSON_VALUE(order_info, '$.attributes.model') AS model,
\n JSON_VALUE(order_info, '$.attributes.color') AS color
\nFROM orders;
\n— \u8ba1\u7b97\u8ba2\u5355\u603b\u4ef7
\nSELECT order_id,
\n JSON_VALUE(order_info, '$.product') AS product,
\n CAST(JSON_VALUE(order_info, '$.price') AS DECIMAL(10,2)) *
\n CAST(JSON_VALUE(order_info, '$.quantity') AS INT) AS total_price
\nFROM orders;
\n— \u67e5\u8be2\u5305\u542b\u7279\u5b9a\u6807\u7b7e\u7684\u8ba2\u5355
\nSELECT order_id, JSON_QUERY(order_info, '$.tags') AS tags
\nFROM orders
\nWHERE JSON_EXISTS(order_info, '$.tags');<\/p>\n
\nCREATE TABLE app_logs (
\n log_id INT PRIMARY KEY,
\n log_time TIMESTAMP,
\n log_data CLOB
\n);
\n— \u63d2\u5165\u65e5\u5fd7\u6570\u636e
\nINSERT INTO app_logs VALUES (1, SYSDATE, '{
\n "level": "ERROR",
\n "module": "auth",
\n "message": "login failed",
\n "details": {
\n "user": "admin",
\n "ip": "192.168.1.100",
\n "attempt": 3
\n }
\n}');
\nINSERT INTO app_logs VALUES (2, SYSDATE, '{
\n "level": "INFO",
\n "module": "order",
\n "message": "order created",
\n "details": {
\n "order_id": "ORD20240101001",
\n "amount": 999
\n }
\n}');
\n— \u6309\u65e5\u5fd7\u7ea7\u522b\u7edf\u8ba1
\nSELECT JSON_VALUE(log_data, '$.level') AS log_level,
\n COUNT(*) AS count
\nFROM app_logs
\nGROUP BY JSON_VALUE(log_data, '$.level');
\n— \u67e5\u8be2\u9519\u8bef\u65e5\u5fd7
\nSELECT log_id,
\n log_time,
\n JSON_VALUE(log_data, '$.module') AS module,
\n JSON_VALUE(log_data, '$.message') AS message,
\n JSON_QUERY(log_data, '$.details') AS details
\nFROM app_logs
\nWHERE JSON_VALUE(log_data, '$.level') = 'ERROR';<\/p>\n3.2 JSON\u6570\u636e\u6784\u5efa\u4e0e\u4fee\u6539<\/h4>\n
\nCREATE TABLE app_config (
\n config_id INT PRIMARY KEY,
\n config_name VARCHAR(100),
\n config_data CLOB,
\n update_time TIMESTAMP
\n);
\n— \u4f7f\u7528JSON_OBJECT\u6784\u5efa\u914d\u7f6e
\nINSERT INTO app_config VALUES (
\n 1,
\n 'database_config',
\n JSON_OBJECT(
\n 'host' VALUE 'localhost',
\n 'port' VALUE 5236,
\n 'database' VALUE 'DM8',
\n 'username' VALUE 'SYSDBA',
\n 'pool_size' VALUE 10,
\n 'timeout' VALUE 30,
\n 'ssl' VALUE FALSE
\n ),
\n SYSDATE
\n);
\n— \u6784\u5efa\u5d4c\u5957\u914d\u7f6e
\nINSERT INTO app_config VALUES (
\n 2,
\n 'app_config',
\n JSON_OBJECT(
\n 'app' VALUE JSON_OBJECT(
\n 'name' VALUE 'MyApp',
\n 'version' VALUE '1.0.0'
\n ),
\n 'features' VALUE JSON_ARRAY(
\n 'authentication',
\n 'logging',
\n 'monitoring'
\n ),
\n 'limits' VALUE JSON_OBJECT(
\n 'max_users' VALUE 1000,
\n 'max_requests' VALUE 10000
\n )
\n ),
\n SYSDATE
\n);
\n— \u4ece\u5173\u7cfb\u6570\u636e\u6784\u5efaJSON
\nCREATE TABLE users (
\n user_id INT PRIMARY KEY,
\n username VARCHAR(50),
\n email VARCHAR(100),
\n phone VARCHAR(20)
\n);
\nINSERT INTO users VALUES (1, 'zhangsan', 'zhangsan@example.com', '13800138000');
\nINSERT INTO users VALUES (2, 'lisi', 'lisi@example.com', '13900139000');
\n— \u5c06\u7528\u6237\u6570\u636e\u8f6c\u4e3aJSON\u683c\u5f0f
\nSELECT JSON_OBJECT(
\n 'user_id' VALUE user_id,
\n 'username' VALUE username,
\n 'contact' VALUE JSON_OBJECT(
\n 'email' VALUE email,
\n 'phone' VALUE phone
\n )
\n) AS user_json
\nFROM users;<\/p>\n
\nCREATE TABLE user_profile (
\n user_id INT PRIMARY KEY,
\n profile CLOB
\n);
\nINSERT INTO user_profile VALUES (1, '{"nickname": "zs", "bio": "developer", "skills": ["Java", "Python"]}');
\n— \u66f4\u65b0JSON\u4e2d\u7684\u7279\u5b9a\u5b57\u6bb5
\nUPDATE user_profile
\nSET profile = JSON_OBJECT(
\n 'nickname' VALUE 'zsf',
\n 'bio' VALUE JSON_VALUE(profile, '$.bio'),
\n 'skills' VALUE JSON_QUERY(profile, '$.skills')
\n)
\nWHERE user_id = 1;
\n— \u6dfb\u52a0\u65b0\u5b57\u6bb5
\nUPDATE user_profile
\nSET profile = JSON_OBJECT(
\n 'nickname' VALUE JSON_VALUE(profile, '$.nickname'),
\n 'bio' VALUE JSON_VALUE(profile, '$.bio'),
\n 'skills' VALUE JSON_QUERY(profile, '$.skills'),
\n 'avatar' VALUE '\/images\/avatar1.png',
\n 'level' VALUE 5
\n)
\nWHERE user_id = 1;<\/p>\n3.3 JSON\u4e0e\u5173\u7cfb\u6570\u636e\u8f6c\u6362<\/h4>\n
\nCREATE TABLE products (
\n product_id INT PRIMARY KEY,
\n product_name VARCHAR(100),
\n variants CLOB
\n);
\nINSERT INTO products VALUES (1, 'T-Shirt', '[
\n {"size": "S", "color": "white", "price": 99, "stock": 100},
\n {"size": "M", "color": "white", "price": 99, "stock": 150},
\n {"size": "L", "color": "black", "price": 109, "stock": 80},
\n {"size": "XL", "color": "black", "price": 119, "stock": 50}
\n]');
\n— \u4f7f\u7528JSON_TABLE\u5c55\u5f00\u53d8\u4f53\u4fe1\u606f
\nSELECT p.product_id,
\n p.product_name,
\n v.size,
\n v.color,
\n v.price,
\n v.stock
\nFROM products p,
\nJSON_TABLE(p.variants, '$[*]' COLUMNS (
\n size VARCHAR(10) PATH '$.size',
\n color VARCHAR(20) PATH '$.color',
\n price DECIMAL(10,2) PATH '$.price',
\n stock INT PATH '$.stock'
\n)) v;
\n— \u6761\u4ef6\u8fc7\u6ee4
\nSELECT p.product_name,
\n v.size,
\n v.color,
\n v.price
\nFROM products p,
\nJSON_TABLE(p.variants, '$[*]' COLUMNS (
\n size VARCHAR(10) PATH '$.size',
\n color VARCHAR(20) PATH '$.color',
\n price DECIMAL(10,2) PATH '$.price',
\n stock INT PATH '$.stock'
\n)) v
\nWHERE v.stock > 100 AND v.price < 100;<\/p>\n
\nCREATE TABLE dept_employee (
\n dept_id INT,
\n dept_name VARCHAR(50),
\n emp_id INT,
\n emp_name VARCHAR(50),
\n salary DECIMAL(10,2)
\n);
\nINSERT INTO dept_employee VALUES (1, 'tech', 101, 'zhangsan', 15000);
\nINSERT INTO dept_employee VALUES (1, 'tech', 102, 'lisi', 12000);
\nINSERT INTO dept_employee VALUES (1, 'tech', 103, 'wangwu', 18000);
\nINSERT INTO dept_employee VALUES (2, 'market', 201, 'zhaoliu', 10000);
\nINSERT INTO dept_employee VALUES (2, 'market', 202, 'qianqi', 11000);
\n— \u6309\u90e8\u95e8\u805a\u5408\u5458\u5de5\u4fe1\u606f\u4e3aJSON
\nSELECT dept_id,
\n dept_name,
\n JSON_OBJECT(
\n 'dept_id' VALUE dept_id,
\n 'dept_name' VALUE dept_name,
\n 'employees' VALUE JSON_ARRAYAGG(
\n JSON_OBJECT(
\n 'emp_id' VALUE emp_id,
\n 'emp_name' VALUE emp_name,
\n 'salary' VALUE salary
\n )
\n )
\n ) AS dept_json
\nFROM dept_employee
\nGROUP BY dept_id, dept_name;<\/p>\n\u56db\u3001JSON\u51fd\u6570\u6027\u80fd\u4f18\u5316\u5efa\u8bae<\/h3>\n
4.1 \u7d22\u5f15\u7b56\u7565\u4f18\u5316<\/h4>\n
\nCREATE INDEX idx_json_name ON json_test(JSON_VALUE(info, '$.name'));
\nCREATE INDEX idx_json_age ON json_test(CAST(JSON_VALUE(info, '$.age') AS INT));
\n— \u590d\u5408\u51fd\u6570\u7d22\u5f15
\nCREATE INDEX idx_json_name_age ON json_test(
\n JSON_VALUE(info, '$.name'),
\n CAST(JSON_VALUE(info, '$.age') AS INT)
\n);
\n— \u9a8c\u8bc1\u7d22\u5f15\u4f7f\u7528
\nEXPLAIN SELECT * FROM json_test
\nWHERE JSON_VALUE(info, '$.name') = 'zhangsan';<\/p>\n4.2 \u67e5\u8be2\u4f18\u5316\u6280\u5de7<\/h4>\n
\nSELECT JSON_VALUE(info, '$.name') AS name,
\n JSON_VALUE(info, '$.age') AS age,
\n JSON_VALUE(info, '$.city') AS city,
\n JSON_VALUE(info, '$.name') || '@example.com' AS email
\nFROM json_test;
\n— \u4f18\u5316\u540e:\u4f7f\u7528CTE\u51cf\u5c11\u91cd\u590d\u89e3\u6790
\nWITH parsed_json AS (
\n SELECT id,
\n JSON_VALUE(info, '$.name') AS name,
\n JSON_VALUE(info, '$.age') AS age,
\n JSON_VALUE(info, '$.city') AS city
\n FROM json_test
\n)
\nSELECT name, age, city, name || '@example.com' AS email
\nFROM parsed_json;
\n— \u4f7f\u7528JSON_TABLE\u4e00\u6b21\u6027\u63d0\u53d6\u591a\u4e2a\u5b57\u6bb5
\nSELECT jt.name, jt.age, jt.city
\nFROM json_test t,
\nJSON_TABLE(t.info, '$' COLUMNS (
\n name VARCHAR(50) PATH '$.name',
\n age INT PATH '$.age',
\n city VARCHAR(50) PATH '$.city'
\n)) jt;<\/p>\n4.3 \u5e38\u89c1\u95ee\u9898\u4e0e\u89e3\u51b3\u65b9\u6848<\/h4>\n
\n— \u89e3\u51b3\u65b9\u6848:\u4f7f\u7528JSON_EXISTS\u5148\u5224\u65ad,\u6216\u4f7f\u7528\u9ed8\u8ba4\u503c
\nSELECT id,
\n COALESCE(JSON_VALUE(info, '$.phone'), 'N\/A') AS phone
\nFROM json_test;<\/p>\n
\n— \u9519\u8bef\u5199\u6cd5:
\nSELECT * FROM json_test WHERE JSON_VALUE(info, '$.age') > 25;
\n— \u6b63\u786e\u5199\u6cd5:
\nSELECT * FROM json_test
\nWHERE CAST(JSON_VALUE(info, '$.age') AS INT) > 25;<\/p>\n
\nSELECT id,
\n CASE WHEN info IS JSON THEN 'valid' ELSE 'invalid' END AS json_valid
\nFROM json_test;
\n— \u8fc7\u6ee4\u6709\u6548JSON\u6570\u636e
\nSELECT * FROM json_test WHERE info IS JSON;<\/p>\n\u4e94\u3001\u603b\u7ed3\u4e0e\u6700\u4f73\u5b9e\u8df5<\/h3>\n
5.1 \u4f7f\u7528\u573a\u666f\u603b\u7ed3<\/h4>\n
5.2 \u6700\u4f73\u5b9e\u8df5\u5efa\u8bae<\/h4>\n
5.3 \u6ce8\u610f\u4e8b\u9879\u8bf4\u660e<\/h4>\n
\n\u4e00\u3001JSON\u51fd\u6570\u6982\u8ff0\u4e0e\u5e94\u7528\u573a\u666f
\n1.1 JSON\u6570\u636e\u683c\u5f0f\u7b80\u4ecb
\nJSON(JavaScript Object Notation)\u662f\u4e00\u79cd\u8f7b\u91cf\u7ea7\u7684\u6570\u636e\u4ea4\u6362\u683c\u5f0f,\u91c7\u7528\u5b8c\u5168\u72ec\u7acb\u4e8e\u8bed\u8a00\u7684\u6587\u672c\u683c\u5f0f,\u6613\u4e8e\u4eba\u9605\u8bfb\u548c\u7f16\u5199,\u540c\u65f6\u4e5f\u6613\u4e8e\u673a\u5668\u89e3\u6790\u548c\u751f\u6210\u3002JSON\u57fa\u4e8eJavaScript\u7684\u4e00\u4e2a\u5b50\u96c6,\u662f\u7406\u60f3\u7684\u534a\u7ed3\u6784\u5316\u6570\u636e\u5b58\u50a8\u683c\u5f0f\u3002
\n#publish-mermaid-1786238291865-0{font-family:\\”trebu<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[11370,11371,93,768,3586],"topic":[],"class_list":["post-99391","post","type-post","status-publish","format-standard","hentry","category-server","tag-dm8","tag-json","tag-sql","tag-3586"],"yoast_head":"\n