Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- delimiter //
- drop procedure naridb.ins;
- drop table naridb.t;
- create table naridb.t(i int,v varchar(1000));
- create procedure naridb.ins(start_no int,end_no int)
- begin
- while start_no <= end_no do
- insert into naridb.t values (start_no,concat('test',start_no));
- set start_no = start_no + 1;
- end while;
- end;
- //
- delimiter ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement