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

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

 

原因:Mysql的每行长度是有限制的,varchar类型的长度加起来不能超过65535

解决:

1.把一些长度很长的varchar类型改成text文本类型 2.把某些varchar字段长度调小

原文链接:https://blog.csdn.net/Special_shooting/article/details/114276446

posted @ 2022-06-20 17:10  进击的小蔡鸟  阅读(258)  评论(0)    收藏  举报