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
评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论