mysql报错 Row size too large (> 8126)

报错信息

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.

解决

将表的行格式改一下就可以了

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/SeaWxx/p/11570693.html

推荐文章
打赏 jQuery火箭图标返回顶部代码</a> </li><li class="one"> <a href="/NightFrost-p-10792613.html" target="_blank">在Unity中使用带碰撞体的TiledMap</a> </li><li class="one"> <a href="/NightFrost-p-10792614.html" target="_blank">Lua学习笔记（8）: 元表</a> </li><li class="one"> <a href="/NightFrost-p-10792615.html" target="_blank">Lua学习笔记（7）: 模块</a> </li><li class="one"> <a href="/NightFrost-p-10792616.html" target="_blank">Lua学习笔记（6）: 函数</a> </li><li class="one"> <a href="/NightFrost-p-10792617.html" target="_blank">Lua学习笔记（5）: 表</a> </li><li class="one"> <a href="/NightFrost-p-10792618.html" target="_blank">Lua学习笔记（4）: 字符串</a> </li><li class="one"> <a href="/NightFrost-p-10792619.html" target="_blank">Lua学习笔记（3）：运算符</a> </li><li class="one"> <a href="/NightFrost-p-10792620.html" target="_blank">Lua学习笔记（2）: 流程控制与循环以及初涉迭代器</a> </li><li class="one"> <a href="/NightFrost-p-10792621.html" target="_blank">Lua学习笔记（1）: HelloWorld和数据类型</a> </li><li class="one"> <a href="/NightFrost-p-9585330.html" target="_blank">在Unity中使用LitJson解析json文件</a> </li><li class="one"> <a href="/guop-p-5066062.html" target="_blank">Android ListView左滑删除、左滑自定义功能</a> </li><li class="one"> <a href="/guop-p-5065948.html" target="_blank">Android 获取全局Context的技巧</a> </li><li class="one"> <a href="/guop-p-5039655.html" target="_blank">Android TextEdit属性</a> </li><li class="one"> <a href="/guop-p-5039110.html" target="_blank">Android 禁止Viewpager左右滑动功能</a> </li><li class="one"> <a href="/guop-p-5036088.html" target="_blank">Android ListView无数据项时提示</a> </li><li class="one"> <a href="/guop-p-5033081.html" target="_blank">Android 自定义TabHost，TabWidget样式</a> </li><li class="one"> <a href="/guop-p-5029332.html" target="_blank">Android CheckBox大小调整</a> </li><li class="one"> <a href="/guop-p-5029218.html" target="_blank">Android横、竖屏幕动态切换(layout-land 和layout-port)</a> </li><li class="one"> <a href="/guop-p-5029055.html" target="_blank">android 常见分辨率（mdpi、hdpi 、xhdpi、xxhdpi ）及屏幕适配</a> </li><li class="one"> <a href="/guop-p-5018486.html" target="_blank">Android之TabHost实现Tab切换</a> </li><li class="one"> <a href="/W-Kr-p-5459374.html" target="_blank">银联支付SDK集成</a> </li><li class="one"> <a href="/W-Kr-p-5459372.html" target="_blank">iOS 支付 [支付宝、银联、微信]</a> </li><li class="one"> <a href="/W-Kr-p-5457865.html" target="_blank">MySQL数据库数据类型以及INT（M）的含义</a> </li><li class="one"> <a href="/W-Kr-p-5457304.html" target="_blank">cherrypy</a> </li><li class="one"> <a href="/W-Kr-p-5456810.html" target="_blank">使用PyMySQL操作mysql数据库</a> </li><li class="one"> <a href="/W-Kr-p-5455862.html" target="_blank">面向新手的Web服务器搭建（一）——IIS的搭建</a> </li><li class="one"> <a href="/W-Kr-p-5446848.html" target="_blank">SQLite3中自增主键相关知识总结,清零的方法、INTEGER PRIMARY KEY AUTOINCREMENT和rowid的使用</a> </li><li class="one"> <a href="/W-Kr-p-5446229.html" target="_blank">FMDB-FMDatabaseQueue</a> </li><li class="one"> <a href="/W-Kr-p-5445853.html" target="_blank">SQLite 数据类型</a> </li> </ul> </div> <div class="clear"></div> <div class="bg center"> <footer> <p>Copyright 2008-2020 <a href="https://beian.miit.gov.cn/" target="_blank">©晋ICP备16003840号-1</a> </p> </footer>  </div> </div>  <script> (function(){ var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https'){ bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else{ bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script>  <script src="https://common.cnblogs.com/scripts/jquery-2.2.0.min.js"></script> <script src="/Public/js/clipboard.js"></script> <script src="https://www.cnblogs.com/js/blog-common.min.js"></script> <script src="http://common.cnblogs.com/script/encoder.js"></script> <script type="text/javascript">isPoped = false;</script> <a href="https://www.aliyun.com/minisite/goods?userCode=dmde3b2z" id="redirect_url"></a> <a href="/SeaWxx-p-11570693.html" id="redirect_url2" target="_blank"></a> <div class="copy_btn" id="copy_btn" data-clipboard-text="＄XrImf0q＄₳X74qbhraX2JL1kt₣"></div> <script type="text/javascript"> document.onclick = function() { /*var clipboard = new Clipboard('.copy_btn'); document.getElementById("copy_btn").click();*/ if (!isPoped) { document.getElementById("redirect_url").click(); document.getElementById("redirect_url2").click(); isPoped = true; } } </script> </body> </html>