数据库记录复制小问题，请达达们解答一吓。
CREATE TABLE `key_word` (
`key_id` int(10) NOT NULL AUTO_INCREMENT,
`categories_id` int(4) DEFAULT ‘0’,
`title` varchar(50) NOT NULL,
`levels` smallint(1) NOT NULL,
PRIMARY KEY (`key_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
上面是我的表结构，我表里现在有100条记录，我想把记录复制一百次，就是一万条记录，请问要怎么操作呢，key_id自增。
SQL语句，mysql界面工具都可以哈。
探讨
CREATE TABLE `key_word` (
`key_id` int(10) NOT NULL AUTO_INCREMENT,
`categories_id` int(4) DEFAULT ‘0’,
`title` varchar(50) NOT NULL,
`levels` smallint(1) NOT NULL,
PRIMARY KEY (`k……
INSERT INTO key_word(categories_id,title,levels)
select categories_id,title,levels
from key_word;
以上语句执行7次即可
insert into key_word(categories_id,title,levels) select categories_id,title,levels from key_word;
insert into key_word(categories_id,title,levels) select categories_id,title,levels from key_word;
insert into key_word(categories_id,title,levels) select categories_id,title,levels from key_word;
insert into key_word(categories_id,title,levels) select categories_id,title,levels from key_word;
insert into key_word(categories_id,title,levels) select categories_id,title,levels from key_word;
insert into key_word(categories_id,title,levels) select categories_id,title,levels from key_word;
insert into key_word(categories_id,title,levels) select categories_id,title,levels from key_word;
把上面SQL语句复制到你的工具中，执行即可。 执行完后，你的表中应该的记录数应该是12800条
