关于java:MySql-索引限制

43次阅读

共计 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

正文完
 0