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;