PG/MySQL/SqlServer数据库中批量制造测试模拟数据

一、PostgreSQL/Greenplum数据库

注意：greenplum中不支持函数function。

create table "public"."t_tang_user_2"(
	"number" varchar(255) not null,
	"name" varchar(255) not null,
	"sex" varchar(255) not null,
	"card_type" varchar(255) not null,
	"uid" varchar(255) not null,
	"status" varchar(255) not null,
	"pingyin" varchar(255) not null,
	"photo" bytea
);

do $$
declare idval integer;
begin
  FOR i IN 1..100 LOOP
		idval= 20000+i;
		INSERT INTO "public"."t_tang_user_2"(
			"number",
			"name",
			"sex",
			"card_type",
			"uid",
			"status",
			"pingyin",
			"photo"
		) VALUES ('Ab'|| i,'姓名' || i,'男',null,idval,idval,'pinyintest',null);
  end loop;
end $$;

二、SQLServer数据库

CREATE PROCEDURE dupl_data_tang AS
BEGIN

DECLARE @i INT
SET @i = 1
WHILE @i < 100000
BEGIN
	INSERT INTO [tang].[hundred_million_user] SELECT
		*
	FROM
		[tang].[sjzx_ykt_user]
	SET @i =@i + 1
END
END

三、MySQL数据库

BEGIN
    declare i int;
    set i=1;
    while i<1001 do
        insert INTO bear_users(`level_id`,`name`,`password`,`nickname`,`headimg`,`mobile`,`email`,`money`,`status`,`reg_time`,`last_login_time`,`create_time`,`update_time`) values(1,'name'+i,'14e1b600b1fd579f47433b88e8d85291','nickname'+i,'headimg'+i,18888888888,'email'+i,i,1,1533695403,1533695403,1533695403,1533695403);
        set i=i+1;
     end while;
END