MySQL存储过程示例

功能为，插入若干条数据

存储过程
DELIMITER //  
CREATE PROCEDURE dowhile()    
 BEGIN   
  DECLARE i INT DEFAULT 1;  
  
   WHILE i<=15 DO  
     INSERT INTO usrpsw VALUES (CONCAT("Alfira", i) , "123456");   
    SET i=i+1;   
   END WHILE;  
 END;  
//
show procedure dowhile;
drop procedure dowhile;
call dowhile();