Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535

ERROR 1118 (42000) at line 5: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some

程志伟

3043人浏览 · 2022-06-14 14:10:47

程志伟 · 2022-06-14 14:10:47 发布

关注微信公共号：小程在线

关注CSDN博客：程志伟的博客

报错：

ERROR 1118 (42000) at line 5: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

解决方法：

方法一、将长度很长的字段由varchar改成TEXT、BLOB

方法二、适当减少其他字段的varchar设置的长度

原因：

MySQL要求一个行的定义长度不能超过65535。

（1）单个字段如果大于65535，则转换为TEXT 。

（2）单行最大限制为65535，这里不包括TEXT、BLOB。