[Err] 1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. You have to change some columns to TEXT or BLOBs
参考:https://blog.csdn.net/lsjseu/article/details/51887991
问题:
text字段存储大字段也会报错
原因:
表的ROW_FORMAT = Compact导致
(创建表时指定:ENGINE=InnoDB AUTO_INCREMENT=771 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED,但是ROW_FORMAT还是Compact,查询可知:SHOW TABLE STATUS LIKE 'mtymentinfo%';
)
想要设置ALTER TABLE mtymentinfo ROW_FORMAT = COMPRESSED
但是不生效
解决:
查看show variables like '%per_table%';
如果是off或者0表示关闭
开启方法:
1、打开mysql的配置my.ini。在innodb配置出添加:innodb_file_per_table=1
(在my.cnf中[mysqld]下设置inn