sql报错:
Row size too large, The maximum row size for the used table type, not counting BLOBs, is 8126, You have to change some
解决办法:
1.找到 mysql 安装配置文件 my.ini
2.配置添加 max_allowed_packet=16M
innodb_file_per_table=1
3.修改MySQL全局变量:SET GLOBAL innodb_file_format='Barracuda';
4.并设置表的行格式属性:ALTER TABLE zqtys ROW_FORMAT = COMPRESSED;
5.修改数据库表部分字段类型为 text,部分字段类型为 longtext