Início / dba / Perguntas / 326012
Accepted
IGGt
Asked: 2023-04-14 18:40:36 +0800 CST

como acessar dados JSON de uma coluna mysql JSON

  • 772

Eu tenho a seguinte entrada em um campo JSON no MySQL, como posso acessar os dados wid_1 -> pct_usage?

{ "wid_1": { "cof": 1, "pct_usage": 50.0, "tid": 69285334, "wid": 1 }, "wid_2": { "cof": 1, "pct_usage": 50.0, "tid": 69285335, "wid": 2 } }

Eu tentei várias variações de:

json_unquote(json_extract(s.`col_name`,'$.wid_1'.'pct_usage')) as wid_1_pct,
json_unquote(json_extract(s.`col_name`,'$.wid_1','pct_usage')) as wid_1_pct,
json_unquote(json_extract(s.`col_name`,'$.wid_1'{'pct_usage'})) as wid_1_pct, 
json_unquote(json_extract(s.`col_name`,'$.wid_1','{pct_usage}')) as wid_1_pct,

mas nenhum deles funciona.

mysql

1 respostas

  1. Best Answer

    Este funciona para mim:

    SELECT s.col_name,
json_extract(s.col_name, '$.wid_1.pct_usage')  as wid_1_pct
FROM t1 as s

    https://www.db-fiddle.com/f/466NTsurpc9YKbrbQ5LvaB/0

    • 1

relate perguntas