delimiter添加数据

-- 创建测试表
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);