create table(id bigint, name varchar(20));
insert into test1 select generate_series(10000,100000),'aa'|| floor(random()*(25-10)+10);
create table(id bigint, name varchar(20));
insert into test1 select generate_series(10000,100000),'aa'|| floor(random()*(25-10)+10);
转载于:https://my.oschina.net/yukong/blog/1475098