用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的整數
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLiYTMfhHLlN3XnxCM38FdsYkRGZkRG9lcvx2bjxCMy8VZ6l2csYWLMZDbyAXNG1iY1EXewVTQClGVF5UMR9Fd4VGdsATNfd3bkFGazxycykFaKdkYzZUbapXNXlleSdVY2pESa9VZwlHdssmch1mclRXY39CXldWYtlWPzNXZj9mcw1ycz9WL49zZuBnLjVjZlVWO0cDZyYWZ3YWYilDN5QzMiVGN2kTY3UjMhR2Lc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
—清空表資料: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