mysql archive 索引_mysql archive存储引擎导入数据报duplicate key

DROP TABLE IF EXISTS `test`;

CREATE TABLE `test` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`version` varchar(25) DEFAULT NULL COMMENT ‘版本号’,

PRIMARY KEY (`id`)

) ENGINE=ARCHIVE AUTO_INCREMENT=5365 DEFAULT CHARSET=utf8 COMMENT=’用户登录记录’;

/*!40101 SET character_set_client = @saved_cs_client */;

INSERT INTO `test` VALUES (1,’0.9.8′),(2,’1.9.2′,50);

ERROR 1022 (23000) at line 58: Can’t write; duplicate key in table ‘test’

解决办法：

1、将存储引擎改为innodb

2、将AUTO_INCREMENT改为0或1

3、删除主键定义，或者删除主键的自增属性

4、修改id列的主键索引为唯一索引或者普通索引

ARCHIVE 相关说明：

The ARCHIVE storage engine is used for storing large amounts of data without indexes in a very small footprint.

The ARCHIVE engine supports INSERT and SELECT, but not DELETE, REPLACE, or UPDATE . It does support ORDER BY operations, BLOB columns, and basically all but spatial data types (see Section 11.17.4.1, “MySQL Spatial Data Types”). The ARCHIVE engine uses row-level locking.

The ARCHIVE engine supports the AUTO_INCREMENT column attribute. The AUTO_INCREMENT column can have either a unique or nonunique index. Attempting to create an index on any other column results in an error . The ARCHIVE engine also supports the AUTO_INCREMENT table option in CREATE TABLE and ALTER TABLE statements to specify the initial sequence value for a new table or reset the sequence value for an existing table, respectively.