给json中的字段创建索引

alter table customer add index usera((CAST(custom_json ->> '$.userId' as CHAR(500))));

创建索引数量限制报错

Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs


往后余生
0 声望1 粉丝