-- 创建测试表
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
`id` bigint(20) NOT NULL COMMENT 'id',
`age` int(11) NULL DEFAULT NULL COMMENT '年龄',
`name` VARCHAR(11) NULL DEFAULT NULL COMMENT '名字',
`birthday` DATE NULL DEFAULT NULL COMMENT '生日',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- 删除存储结构
drop procedure rand_data;
-- 创建存储结构
delimiter //
create procedure rand_data(in num int)
begin
declare str char(62) default 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
declare str2 char(2);
declare i int default 0;
while i<num do
set str2=concat(substring(str,1+floor(rand()*61),1),substring(str,1+floor(rand()*61),1));
set i=i+1;
insert into test values (floor(rand()*num),floor(rand()*100),str2,CURDATE());
end while;
end;
-- 随机生成100条记录
delimiter ;
call rand_data(100);
delimiter添加数据
于 2022-05-18 15:36:43 首次发布