56,937
社区成员




create table t_06 (
id int not null primary key,
c1 varchar(30),
i2 int
) engine = myisam;
delimiter //
CREATE PROCEDURE prepareData_t_06 ()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i < 500000 DO
insert into t_06 values (i,concat('AA',i),i);
SET i = i + 1;
END WHILE;
END;
//
delimiter ;
CALL prepareData_t_06();
select count(*) from t_06;
DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`test1`$$
CREATE PROCEDURE `test`.`test1`()
declare v_cnt decimal (1) default 0 ;
dd:loop
insert into test.table1(t1,t2) values (0,1);
commit;
set v_cnt = v_cnt+1 ;
if v_cnt = 1000000 then leave dd;
end if;
end loop dd ;
BEGIN
END$$
DELIMITER ;
mysql> select count(*) from t1;
+----------+
| count(*) |
+----------+
| 100000 |
+----------+
1 row in set (0.14 sec)
mysql> select * from t1 INTO OUTFILE 'aaa';
Query OK, 100000 rows affected (0.08 sec)
mysql> select id from t1 INTO OUTFILE 'aaa1';
Query OK, 100000 rows affected (0.09 sec)
mysql> select id from t1 INTO OUTFILE 'aaa2';
Query OK, 100000 rows affected (0.11 sec)
mysql> select id from t1 INTO OUTFILE 'aa3';
Query OK, 100000 rows affected (0.09 sec)
mysql>