MySQL中表名/列名最长可以多大？

原创

保持热爱奔赴山海

修改于 2024-09-26 21:37:51

1040

修改于 2024-09-26 21:37:51

文章被收录于专栏：数据库相关

我这里的MySQL是8.0.x版本

[test]> \s
--------------
mysql  Ver 8.0.36-28 for Linux on x86_64 (Percona Server (GPL), Release 28, Revision 47601f19)

Connection id:          174
Current database:       test
Current user:           root@localhost
SSL:                    Not in use
Current pager:          less
Using outfile:          ''
Using delimiter:        ;
Server version:         8.0.36-28 Percona Server (GPL), Release 28, Revision 47601f19
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    utf8mb4
Conn.  characterset:    utf8mb4
UNIX socket:            /data/mysql/mysql.sock
Uptime:                 6 hours 40 min 16 sec

Threads: 1  Questions: 106121  Slow queries: 20  Opens: 341  Flush tables: 4  Open tables: 175  Queries per second avg: 4.418
--------------

binlog_event.h 源码里面有，看下图框起来的地方，可知表名和字段名最大为64字符。