mysql:Specified key was too long; max key length is 767 bytes
来源:互联网 发布:淘宝数码商城 编辑:程序博客网 时间:2024/06/04 19:57
Specified key was too long; max key length is 767 bytes
这个报错是因为mysql的“字符串类型”(varchar、char等)字段作为索引时,有一个约束单个索引字段存储长度不能超过767字节。
按照表为utf8mb4字符集时,一个字符需要4个字节存储。那么最大定义索引前缀为 767/4=191.即字段a varchar(500)要建立索引时需要定义前缀索引 a(191),不能超过191的一个值。
其他utf8为3个字节存储一个字符,gbk为2个字节存储一个字符,依次类推得到对应字符串类型字段的前缀索引长度修正即可。
示例:add key
idx_xxx
(content(120),type);
阅读全文
0 0
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- mysql [Err] 1071 - Specified key was too long; max key length is 767 bytes
- MySQL:Specified key was too long; max key length is 767 bytes
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- mysql报错:Specified key was too long; max key length is 767 bytes
- MySQL-001-specified key was too long ; max key length is 767 bytes
- [MySQL] specified key was too long max key length is 767bytes
- mysql: Specified key was too long; max key length is 767 bytes
- mysql Specified key was too long; max key length is 767 bytes
- mysql [42000][1071] Specified key was too long; max key length is 767 bytes
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- 关于MySQL字符集问题:Specified key was too long; max key length is 767 bytes
- mysql:Specified key was too long; max key length is 767 bytes
- MySQL错误“Specified key was too long; max key length is 1000 bytes”
- MySQL错误“Specified key was too long; max key length is 1000 bytes”的解决办
- MySQL错误“Specified key was too long; max key length is 1000 bytes”的解决办法
- python发送、抄送邮件
- C语言实验——计算1到n的和(循环结构)
- 百度AI实现图像分类-python
- ajax登录后返回上一次浏览的页面
- ThreadLocal实现多线程
- mysql:Specified key was too long; max key length is 767 bytes
- ssm框架的搭建和整合
- 开发小结之layoutSubviews调用
- 欢迎使用CSDN-markdown编辑器
- ajax同步提交数据,并把请求返回值赋值给全局变量
- 二叉树的镜像 (剑指Offer 第 17 题)
- CG 标准函数库
- kafka
- react-router 4.0 格式化文档