共计 260 个字符,预计需要花费 1 分钟才能阅读完成。
给 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
正文完