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

我这里的MySQL是8.0.x版本

代码语言:txt复制[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字符。

不信可以建表试试:

表长度最大64

表列长度最大长度也是64