56,687
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `test` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`value` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=latin1
insert into test.test values (1, 101);
insert into test.test values (2, 102);
insert into test.test values (3, 103);
insert into test.test values (4, 104);
insert into test.test values (5, 105);
insert into test.test values (6, 106);
insert into test.test values (7, 107);
insert into test.test values (8, 108);
insert into test.test values (9, 109);
insert into test.test values (10, 110);
insert into test.test values (11, 111);
insert into test.test values (12, 112);
insert into test.test values (13, 113);
...
insert into test.test values(999, 1999);
CREATE PROCEDURE dowhile()
BEGIN
DECLARE v1 INT DEFAULT 1000;
WHILE v1 > 0 DO
insert into test.test values (v1, v1);
SET v1 = v1 - 1;
END WHILE;
END;
call dowhile();