Mysql新建表报错 Row size too large. The maximum row size for the used table type, not counting BLOBs, is

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

 

1.可能是单个字段超过限定长度了,比如vachar(30000)这种

2.可能是表的字段的长度总和超出限定长度了,得减少字段或者修改某些字段的大小来为新的字段留出空间

 

 

./configure --prefix=/usr/local/nginx --without-

http_memcached_module --user=www --group=www --with-http_stub_status_module --with-

http_ssl_module --with-http_gzip_static_module --with-openssl=/usr/local/src/openssl- 

1.0.1h --with-zlib=/usr/local/src/zlib-1.2.8 --with-pcre=/usr/local/src/pcre-8.35