Mysql varchar字段索引的最大长度

2017/12/13 16:27
阅读数 6.5K

Prefix support and lengths of prefixes (where supported) are storage engine dependent. For example, a prefix can be up to 767 bytes long for InnoDB tables or 3072 bytes if the innodb_large_prefix option is enabled. For MyISAM tables, the prefix limit is 1000 bytes. The NDB storage engine does not support prefixes (see Section 21.1.6.6, “Unsupported or Missing Features in NDB Cluster”).

 

https://dev.mysql.com/doc/refman/5.7/en/create-index.html

Innodb(默认) innodb_large_prefix Enable MyIsam NDB
767 byte 3072 byte 1000 byte ?

 

展开阅读全文
加载中
点击引领话题📣 发布并加入讨论🔥
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部