Table structure:
"id":"xxxx"
"xxx":"xxx",
"catalogs" : [
{
"catalog_number" : "4.1",
"catalog_name" : "",
"subcatalogs" : [
{
"subcatalogs_number" : "4.1.1",
"subcatalogs_name" : "",
"subcatalog" : [
{
"chinese_name" : "",
"internal_identifier" : "DE02.07.001",
"version" : "v1.0",
"definition" : "",
"data_type" : "",
"data_format" : "a..30",
"range" : "DZJW 2203.7-2017CC02.07.001",
"synonymous_nouns" : "",
"measuring_unit" : "",
"remarks" : ""
},
{
"chinese_name" : "",
"internal_identifier" : "DE02.07.002",
"version" : "v1.0",
"definition" : "",
"data_type" : "",
"data_format" : "n1",
"range" : "DZJW 2203.7-2017CC02.07.001",
"synonymous_nouns" : "",
"measuring_unit" : "",
"remarks" : ""
},
{
"chinese_name" : "2",
"internal_identifier" : "DE02.07.001",
"version" : "v1.0",
"definition" : "",
"data_type" : "",
"data_format" : "a..30",
"range" : "DZJW 2203.7-2017CC02.07.001",
"synonymous_nouns" : "",
"measuring_unit" : "",
"remarks" : ""
},
{
"chinese_name" : "2",
"internal_identifier" : "DE02.07.002",
"version" : "v1.0",
"definition" : "",
"data_type" : "",
"data_format" : "n1",
"range" : "DZJW 2203.7-2017CC02.07.001",
"synonymous_nouns" : "",
"measuring_unit" : "",
"remarks" : ""
}
]
},
{
"subcatalogs_number" : "4.1.2",
"subcatalogs_name" : "2",
"subcatalog" : [
{
"chinese_name" : "22",
"internal_identifier" : "DE02.07.001",
"version" : "v1.0",
"definition" : "",
"data_type" : "",
"data_format" : "a..30",
"range" : "DZJW 2203.7-2017CC02.07.001",
"synonymous_nouns" : "",
"measuring_unit" : "",
"remarks" : ""
},
{
"chinese_name" : "22",
"internal_identifier" : "DE02.07.002",
"version" : "v1.0",
"definition" : "",
"data_type" : "",
"data_format" : "n1",
"range" : "DZJW 2203.7-2017CC02.07.001",
"synonymous_nouns" : "",
"measuring_unit" : "",
"remarks" : ""
},
{
"chinese_name" : "222",
"internal_identifier" : "DE02.07.001",
"version" : "v1.0",
"definition" : "",
"data_type" : "",
"data_format" : "a..30",
"range" : "DZJW 2203.7-2017CC02.07.001",
"synonymous_nouns" : "",
"measuring_unit" : "",
"remarks" : ""
},
{
"chinese_name" : "222",
"internal_identifier" : "DE02.07.002",
"version" : "v1.0",
"definition" : "",
"data_type" : "",
"data_format" : "n1",
"range" : "DZJW 2203.7-2017CC02.07.001",
"synonymous_nouns" : "",
"measuring_unit" : "",
"remarks" : ""
}
]
}
]
},
{
"catalog_number" : "4.2",
"catalog_name" : "",
"subcatalogs" : [
{
"chinese_name" : "2",
"internal_identifier" : "DE02.07.094",
"version" : "v1.0",
"definition" : "",
"data_type" : "",
"data_format" : "YYYYMMDD",
"range" : "",
"synonymous_nouns" : "",
"measuring_unit" : "",
"remarks" : "DZJW 2102.4-2017DE01.04.01"
},
{
"chinese_name" : "22",
"internal_identifier" : "DE02.07.094",
"version" : "v1.0",
"definition" : "",
"data_type" : "",
"data_format" : "YYYYMMDD",
"range" : "",
"synonymous_nouns" : "",
"measuring_unit" : "",
"remarks" : "DZJW 2102.4-2017DE01.04.01"
},
{
"chinese_name" : "222",
"internal_identifier" : "DE02.07.094",
"version" : "v1.0",
"definition" : "",
"data_type" : "",
"data_format" : "YYYYMMDD",
"range" : "",
"synonymous_nouns" : "",
"measuring_unit" : "",
"remarks" : "DZJW 2102.4-2017DE01.04.01"
}
]
},
{
"catalog_number" : "4.3",
"catalog_name" : "3",
"subcatalogs" : [
{
"chinese_name" : "33",
"internal_identifier" : "DE02.07.094",
"version" : "v1.0",
"definition" : "",
"data_type" : "",
"data_format" : "YYYYMMDD",
"range" : "",
"synonymous_nouns" : "",
"measuring_unit" : "",
"remarks" : "DZJW 2102.4-2017DE01.04.01"
}
]
}
],
"current_version" : "20180410-v1.03", question 1: I want to take "catalogs.catalog_name" as the second to fourth information in "reporting letters and visits". How should sql write?
question 2: if you want to modify and only modify "catalogs.catalog_name" to the first message in "reporting letters and visits",
sql how to write
has tried many ways, mainly because the whole json itself is a piece of data. Is it impossible to do this?
Thank you for your answers, thank you very much!