Advertisement
Guest User

Untitled

a guest
Jul 27th, 2017
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. delimiter //
  2. drop procedure naridb.ins;
  3. drop table naridb.t;
  4. create table naridb.t(i int,v varchar(1000));
  5. create procedure naridb.ins(start_no int,end_no int)
  6. begin
  7. while start_no <= end_no do
  8. insert into naridb.t values (start_no,concat('test',start_no));
  9. set start_no = start_no + 1;
  10. end while;
  11. end;
  12. //
  13. delimiter ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement