1.创建数据库表 CREATE TABLE `USER ` ( `id` int(10) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 2.创建存储过程 DELIMITER $$ CREATE PROCEDURE insertdata() BEGIN DECLARE i INT ; set i = 1; WHILE i < 10 DO INSERT INTO USER (id) VALUE (i) ; SET i = i + 1; END WHILE; END $$ 3.调用存储过程 CALL insertdata() 4.结果显示