用sql批量生成数据
1、kdw(postgresql)数据库:
–插入key(class_id)的值是在(1000000,1999999)之间
insert into shan_test.test_class (class_id,class_name,class_num,class_teacher)
select generate_series(1000000,1999999) as class_id ,
'三年级'||(random()*(10^1))::integer'班',(random()*(6^2))::integer,'老师'
;
–class_name是由 (random()*(10^1))::integer进行拼接完成的,
其中, (random()*(10^1))::integer:是1位的随机0-10的整数
(random()*(6^2))::integer: 是2位的随机0-6的整数
—清空表数据:truncate table shan_test.test_class
2、orcle数据库
INSERT INTO public.ccma (ccmaint,ccmastr,ccmadate)
select 1,'b',now() from public.ccma
union all
select 1,'b',now() from public.ccma