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界面工具都可以哈。
`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界面工具都可以哈。
反复执行下面的语句,记录数每次翻倍
insert into key_word(categories_id,title,levels) select categories_id,title,levels
from key_word;
1.DELIMITER //
2.CREATE PROCEDURE do_insert()
3. BEGIN
4. DECLARE i INT DEFAULT 1;
5.
6. WHILE i<=10000 DO
7. INSERT INTO key_word(key_id,categories_id,title,levels) select categories_id,title,levels
from key_word;
8. SET i=i+1;
9. END WHILE;
10. END;
11. //
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;
把上面SQL语句复制到你的工具中,执行即可。 执行完后,你的表中应该的记录数应该是12800条