若依 [Err] 1071 - Specified key was too long; max key length is 767 bytes

若依（Ruoyi）是一款基于Spring Boot和Vue.js的开源快速开发平台。它提供了一套完整的前后端分离的解决方案，包括权限管理、代码生成、数据字典、定时任务等常用功能。若依的目标是帮助开发者快速搭建企业级的管理系统。

关于你提到的错误信息"Specified key was too long; max key length is 767 bytes"，这是MySQL数据库的一个限制。MySQL InnoDB引擎对于索引的最大长度是767字节，如果你创建的索引超过了这个限制，就会出现该错误。解决这个问题的方法是缩短索引的长度，或者使用其他类型的索引。

相关问题

[Err] 1071 - Specified key was too long; max key length is 767 bytes

[Err] 1071 - Specified key was too long; max key length is 767 bytes 是一个错误信息，表明创建索引时指定的键太长，超过了最大长度限制为767字节。这个错误通常与MySQL数据库的限制有关。MySQL的innodb存储引擎对于单个列的长度限制为767字节，对于多列索引的长度限制为3072字节。这意味着每个列的长度不能大于767字节，而组成索引的所有列的长度总和不能超过3072字节。因此，如果在创建索引时指定的键长度超过了这些限制，就会出现这个错误。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [建表语句错误：[Err] 1071 - Specified key was too long; max key length is 767 bytes](https://blog.csdn.net/u010931123/article/details/102801269)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *2* *3* [1071 - Specified key was too long； max key length is 767 bytes](https://blog.csdn.net/qq_38925911/article/details/118210392)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]

[Err] 1071 - Specified key was too long; max key length is 1000 bytes

1071 - Specified key was too long; max key length is 1000 bytes 是一个错误信息，表示指定的键太长，最大键长度为1000个字节。这个错误通常发生在数据库中创建唯一键时，当键的长度超过了数据库所允许的最大长度时会出现该错误。引用提到了这个错误信息，并且指出是在尝试为`users`表添加一个唯一键(`users_username_unique`)时出现的。MySQL 5.7版本中，varchar的长度是根据字符数来计算的，一个字母或汉字都算作一个字符。因此，当键的长度超过1000个字节时，就会出现这个错误。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [[Err] 1071 - Specified key was too long； max key length is 767 bytes](https://blog.csdn.net/woshiwozzl/article/details/107491729)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *2* *3* [创建索引时，解决1071 Specified key was too long； max key length is 1000 bytes错误信息](https://blog.csdn.net/alpeace/article/details/116353774)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]