mysql json使用
如何加快对json数据的查询
- 创建虚拟列
add column `column_name` varchat(32) generated always as (json_unquote(json_extract(`json_column`,'$.column'))) virtual null;
- 为虚拟列添加索引
create index idx_column on table_name(column_name)
add column `column_name` varchat(32) generated always as (json_unquote(json_extract(`json_column`,'$.column'))) virtual null;
create index idx_column on table_name(column_name)