Specified key was too ong; max key length is 767 bytes
时间: 2023-10-19 12:30:04 浏览: 43
"Specified key was too long; max key length is 767 bytes"是一个数据库错误信息,意思是指定的键太长,最大键长度为767字节。[2]
这个错误通常发生在设置数据库字段的唯一索引时,如果索引内容超过767个字节,就会出现这个错误。一般情况下,int、tinyint和varchar类型的字段不会超过这个长度。而出现问题的主要是varchar和text类型的字段。
对于text字段,直接将其作为索引是不被允许的,必须指定一个长度。例如,使用255的长度可以成功创建索引,但使用256的长度则会导致创建失败,因为超过了767个字节的限制。
所以,当出现这个错误时,我们需要检查所使用的字段类型和长度,确保不超过767个字节的限制。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [Specified key was too long; max key length is 767 bytes问题解决](https://blog.csdn.net/hfut_wowo/article/details/88018800)[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* [MySQL错误“Specified key was too long; max key length is 1000 bytes”的解决办法](https://download.csdn.net/download/weixin_38606300/12835900)[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 ]