Mysql中Row size too large (> 8126). Changing some columns to TEXT or BLOB or using 错误的问题解决

Mysql中导入数据时,报
[ERR] 1118 - 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.
错误的问题解决,
在my.cnf或my.ini配置文件中关闭严格模式
** innodb_strict_mode=0**

再次导入就可以

posted @ 2024-11-13 21:08  vello  阅读(1848)  评论(0)    收藏  举报