数据库记录复制小问题，请达达们解答一吓。
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条