Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or R
·
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
错误原因:
1.有可能是表中耨个字段存储数据量超过最大长度
2.总的数据量超过了
解决方案:
错误1解决方案:将字段换位大数据类型。
错误2解决方案:执行以下语句(首先连接到要操作的数据库上,XX指的是要操作的表)
ALTER TABLE XX
ENGINE=InnoDB
ROW_FORMAT=COMPRESSED
KEY_BLOCK_SIZE=8;
更多推荐
已为社区贡献2条内容
所有评论(0)