简介:MySQL添加索引Specified key was too long; max key length is 767 bytes 添加删除索引 # 添加索引ALTER TABLE user ADD UNIQUE (name)# 删除索引ALTER TABLE user DROP INDEX (name) 添加索引是遇到问题 MySQL添加索引Specified key was too long; max key length is 767 bytes 要设置为索引的字段太长,...
# 添加索引 ALTER TABLE user ADD UNIQUE (name) # 删除索引 ALTER TABLE user DROP INDEX (name) 1. 2. 3. 4. 5. 添加索引是遇到问题 MySQL添加索引Specified key was too long; max key length is 767 bytes 1. 要设置为索引的字段太长,超过了767字节 name varchar(255) utf8mb4 # 255 * 4 =...
【摘要】 添加删除索引 # 添加索引 ALTER TABLE user ADD UNIQUE (name) # 删除索引 ALTER TABLE user DROP INDEX (name) 12345 添加索引是遇到问题 MySQL添加索引Specified key was too long; max key length is 767 bytes 1 要设置为索引的...
# 添加索引 ALTER TABLE user ADD UNIQUE (name) # 删除索引 ALTER TABLE user DROP INDEX (name) 1. 2. 3. 4. 5. 添加索引是遇到问题 MySQL添加索引Specified key was too long; max key length is 767 bytes 1. 要设置为索引的字段太长,超过了767字节 name varchar(255) utf8mb4 # 255 * 4 =...