#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
重试,搞定
发表评论