There is a hard limit of 4096 columns per table, but the effective maximum may be less for a given table. The exact limit depends on several interacting factors, listed in the following discussion. Every table has a maximum row size of 65,535 bytes. This maximum applies to all storage engines, but a given engine might have additional constraints that result in a lower effective maximum row size.
---------------
这个是表示字节的长度,不是字符的长度,注意!!!
show charset
看看你系统选择的字符集的每个字符的长度是多少吧
谢谢 那后面那个问题呢?
一条记录的大小也有限制 <65,535 bytes