官方说是64个字节。
自己测试了一下
3 rows in set (0.00 sec)
mysql> alter table column_test change iddddddddddddddddddddddddddddddddddddddddddddddddddd Abortedddddddddddddddddddddddddddddddddddddddddddddddddddd int not null;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> alter table column_test change iddddddddddddddddddddddddddddddddddddddddddddddddddd Abortedddddddddddddddddddddddddddddddddddddddddddddddddddd int not null;
ERROR 1054 (42S22): Unknown column 'iddddddddddddddddddddddddddddddddddddddddddddddddddd' in 'column_test'
mysql> alter table column_test change Abortedddddddddddddddddddddddddddddddddddddddddddddddddddd Abortedddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd int not null;
ERROR 1059 (42000): Identifier name 'Abortedddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd' is too long
mysql> alter table column_test change Abortedddddddddddddddddddddddddddddddddddddddddddddddddddd Aborteddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd int not null;
ERROR 1059 (42000): Identifier name 'Aborteddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd' is too long
mysql> alter table column_test change Abortedddddddddddddddddddddddddddddddddddddddddddddddddddd Abortedddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd int not null;
ERROR 1059 (42000): Identifier name 'Abortedddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd' is too long
mysql> alter table column_test change Abortedddddddddddddddddddddddddddddddddddddddddddddddddddd Aborteddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd int not null;
ERROR 1059 (42000): Identifier name 'Aborteddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd' is too long
mysql> alter table column_test change Abortedddddddddddddddddddddddddddddddddddddddddddddddddddd Abortedddddddddddddddddddddddddddddddddddddddddddddddddddddddddd int not null;
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> select char_length("Abortedddddddddddddddddddddddddddddddddddddddddddddddddddddddddd");
+---------------------------------------------------------------------------------+
| char_length("Abortedddddddddddddddddddddddddddddddddddddddddddddddddddddddddd") |
+---------------------------------------------------------------------------------+
| 64 |
+---------------------------------------------------------------------------------+
1 row in set (0.00 sec)