mysql innodb 最大_innodb下几个关于mysql字段类型的最大值测试

mysql> CREATE TABLE t2 (a VARCHAR(65532))  TYPE=innodb;--最大只设65532Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> CREATE TABLE t3 (a VARCHAR(65533))  TYPE=innodb;---超过65532报错ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs

mysql> CREATE TABLE t17(a VARCHAR(65535))  TYPE=innodb;;---65535仍然报错

ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs

mysql> CREATE TABLE t17(a VARCHAR(65536))  TYPE=innodb;---超过65535则之间建立mediumtext 类型Query OK, 0 rows affected, 2 warnings (0.00 sec)

mysql> desc t17;

+-------+------------+------+-----+---------+-------+

| Field | Type       | Null | Key | Default | Extra |

+-------+------------+------+-----+---------+-------+

| a     | mediumtext | YES  |     | NULL    |       |

+-------+------------+------+-----+---------+-------+

1 row in set (0.00 sec)