一、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