Row size too large. The maximum row size for the used table type, not counting BLOBs, is 6553
mysql 建表 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 BL
·
mysql 建表 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；
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
查找原因
数据库编码为utf8mb4， varchar长度：（2000+10000+2000+3100+300）*4>65535了
如果数据库编码为utf8，类型长度乘以3
解决方案
将比较长的字段类型设置成 blob 或者 text
本社区面向用户介绍CSDN开发云部门内部产品使用和产品迭代功能，产品功能迭代和产品建议更透明和便捷
更多推荐
5
0- 0
已为社区贡献1条内容
所有评论(0)