#1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAM

#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.的解决方法

CREATE TABLE `fa_zuserbank` (

  `id` bigint(20) NOT NULL COMMENT '序号',

  `zuser_id` bigint(20) NOT NULL COMMENT '用户ID',

  `zbank_id` tinyint(2) NOT NULL COMMENT '银行ID',

  `subbranch` varchar(1024) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '支行名称',

  `mobile` varchar(20) DEFAULT NULL COMMENT '预留手机号',

  `account` varchar(64) NOT NULL COMMENT '银行卡号',

  `updatetime` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间'

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='用户银行卡表' ROW_FORMAT=DYNAMIC;


只需将:ENGINE=InnoDB 

改为:ENGINE=MyISAM 


重试,搞定

最后编辑于:2021/07/29作者: 牛逼PHP

发表评论