Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

MySQL 创建数据表时如果字段过多或者一条记录中的字段长度过大, 会报这个错误:
Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

解决方式

编辑 MySQL 配置文件, 添加下面两个配置项
innodb_log_file_size=2048M
innodb_strict_mode=0

posted @ 2022-02-09 19:41  kmswilliam  阅读(1235)  评论(0)    收藏  举报