-- 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造百万测试数据
最后编辑于 ：
©著作权归作者所有,转载或内容合作请联系作者
平台声明：文章内容（如有图片或视频亦包括在内）由作者上传并发布，文章内容仅代表作者本人观点，简书系信息发布平台，仅提供信息存储服务。
平台声明：文章内容（如有图片或视频亦包括在内）由作者上传并发布，文章内容仅代表作者本人观点，简书系信息发布平台，仅提供信息存储服务。
