相关推荐recommended
如何解决mysql报错1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB may help
作者:mmseoamin日期:2024-04-27

创建mysql表时报错> 1118 - 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.

运行下面这句sql查看是否开启了严格模式:

show variables like '%innodb_strict_mode%'

若结果innodb_strict_mode = on,请打开mysql安装目录下的my.ini文件,宝塔面板则直接在配置文件菜单里修改配置

在配置文件mysqld最下面加上一句

innodb_strict_mode=0

保存然后重启mysql再试一下:

show variables like '%innodb_strict_mode%'

如果结果是OFF,那么就成功关闭了,然后再跑一下建表语句就可以了