一个经常会用到的存储过程,可以用来造数据。
1…100000的意思为从1到100000循环,来实现自增id
orcal:
begin
for i in 1..100000
loop
INSERT INTO "A" ("ID", "date", "type","name")
VALUES (i, TO_DATE('2018-10-17 15:08:57', 'SYYYY-MM-DD HH24:MI:SS'), '10',NULL)
end loop;
commit;
end;
mysql:
drop procedure pre;
create procedure pre()
begin
declare i int;
set i=13610;
while i<100000 do
insert into profiles1(sex,rating,age)
VALUES('M', i,i);
set i=i+1;
commit;
end while;
end;
call pre();