刚刚导入sql创建表,遇到错误提示:
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.
执行:show variables like '%innodb_strict_mode%' 查询
得到:innodb_strict_mode=NO
现在需要把innodb_strict_mode改为OFF
我的数据库为云数据库mysql,登录后台找到mysql实例列表,在数据库管理找到参数设置就可以了