解决MySQL导入MySQL数据时出现的报错Row size too large (> 8126).changing some columns to TEXT or BLOB or using ROW
·
问题描述:
[SQL] Query hzyztht backup251119 (2)start
[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.
[ERR]
INSERT INTO `help topiC VALUES (609,'SHOWXXXXXXXXX
解决办法:
到指定的数据库下执行下面两条语句即可
SET GLOBAL innodb_strict_mode = OFF;
SET GLOBAL max_allowed_packet = 256 * 1024 * 1024;
DAMO开发者矩阵,由阿里巴巴达摩院和中国互联网协会联合发起,致力于探讨最前沿的技术趋势与应用成果,搭建高质量的交流与分享平台,推动技术创新与产业应用链接,围绕“人工智能与新型计算”构建开放共享的开发者生态。
更多推荐


所有评论(0)