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();