DELIMITER$$
create procedure COBA(kd_mhs varchar(20),jumlah int)
begin
DECLARE I INT;
SET I=0;
WHILE I<=10000 do
insert into NM_TABEL values (kd_mhs,jumlah);
SET I=I+1;
END WHILE;
end$$
DELIMITER;
pemanggilannya menggunakan
CALL COBA (//isi parameternya);
========================================================>
contoh:
CALL COBA('3125111329',250000);
create procedure COBA(kd_mhs varchar(20),jumlah int)
begin
DECLARE I INT;
SET I=0;
WHILE I<=10000 do
insert into NM_TABEL values (kd_mhs,jumlah);
SET I=I+1;
END WHILE;
end$$
DELIMITER;
pemanggilannya menggunakan
CALL COBA (//isi parameternya);
========================================================>
contoh:
CALL COBA('3125111329',250000);