创建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文件
D:\mysql\mysql-8.2.0-winx64\mysql-8.2.0-winx64\my.ini
使用编辑器打开后在mysqld最下面加上一句
innodb_strict_mode=0
保存!保存!保存!
然后重启mysql再试一下:
show variables like '%innodb_strict_mode%'
如果结果时OFF,那么就成功关闭了,然后再跑一下建表语句就可以了~