索引列大小太大.最大列大小为767个字节. -对于INT数据类型? [英] Index column size too large. The maximum column size is 767 bytes. - For INT datatype?

问题描述

我知道innodb对密钥大小施加了限制，但是一个INT?

I am aware innodb imposes a limit on key size, but an INT?

    CREATE TABLE IF NOT EXISTS  `db`.`TAGS` (

 `tag_id` INT( 11 ) NOT NULL ,
 `tag_text` VARCHAR( 700 ) NULL ,
 `date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
 `xxx_id` INT( 11 ) NOT NULL COMMENT  'This is for ease of reference lookup later',
 `user_id` INT( 11 ) NOT NULL ,
 `TAG_FACT_RELATION_relation_id` INT NOT NULL ,
PRIMARY KEY (  `tag_id` ) ,
UNIQUE INDEX  `tag_UNIQUE` (  `tag_text` ASC ) ,
UNIQUE INDEX  `tag_id_UNIQUE` (  `tag_id` ASC ) ,
INDEX  `fk_TAGS_TAG_FACT_RELATION1_idx` (  `TAG_FACT_RELATION_relation_id` ASC ) ,
CONSTRAINT  `fk_TAGS_TAG_FACT_RELATION1` FOREIGN KEY (  `TAG_FACT_RELATION_relation_id` ) REFERENCES  `meepl`.`TAG_FACT_RELATION` (
`relation_id`
) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE = INNODB;

有错误说:

#1709 - Index column size too large. The maximum column size is 767 bytes. 

有什么想法吗?多年来，我一直在研究数据类型.

Any ideas? I have been muching around with data types for ages.

推荐答案

有点晚了，但是我遇到了类似的问题.

A bit late but I had a similar issue.

您的tag_text列具有UNIQUE_INDEX，这就是引起问题的原因，而不是INT数据类型.

Your tag_text column has a UNIQUE_INDEX and that is what is causing the issue, not the INT datatype.

通过启用innodb_large_prefix设置，更改MySql安装以启用更大的索引列.

Change your MySql installation to enable larger index columns by enabling the innodb_large_prefix setting.

请参见 http://dev.mysql.com/doc /refman/5.5/en/innodb-restrictions.html

这篇关于索引列大小太大.最大列大小为767个字节. -对于INT数据类型?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！