声明存过
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
# pre delete drop procedure insert_parquet; #declare procedure delimiter @ create procedure insert_parquet(in item integer) begin declare counter int; set counter = item; while counter >= 1 do insert into parquet values(counter,concat('company',counter),counter+0.1,CURTIME()); set counter = counter - 1; end while; end @ delimiter ; |
测试使用
|
1 2 3 4 |
mysql> truncate table parquet; Query OK, 0 rows affected mysql> call insert_parquet(1000000);<br>Query OK, 1 row affected (50 min 18.30 sec)<br> |
生成了100w条数据。还挺快，不到1小时完成。