-- auto-generated definition
create table test1
(
id int auto_increment
primary key,
name varchar(200) null,
age int null,
address varchar(200) null
);
DROP PROCEDURE IF EXISTS test_insert;
DELIMITER ;;
CREATE PROCEDURE test_insert ()
BEGIN
DECLARE i int;
set i=0;
WHILE i<100000
DO
INSERT INTO test1 (name, age, address) VALUES (replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', '')),
(replace(uuid(), '-', ''), i, replace(uuid(), '-', ''));
SET i=i+1;
END WHILE ;
commit;
END;;
call test_insert () ;
mysq造百万测试数据
最后编辑于 ：
©著作权归作者所有,转载或内容合作请联系作者
- 文/潘晓璐 我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
- 文/花漫 我一把揭开白布。 她就那样静静地躺着，像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上，一...
- 文/苍兰香墨 我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
