关于java:MySql-索引限制

给 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