MySQL存储过程demo

DELIMITER $$
CREATE
    PROCEDURE `userphone`.`addphone`()
    BEGIN
	DECLARE i INT;
	  SET i=1;
	  WHILE(i<=100000)DO
	    INSERT INTO `user_phone_info`
		VALUES(i,i,CONCAT('李白_',i),CONCAT('189223322',i),0,'2023-02-24 13:46:19','2023-02-24 13:46:19');
	    SET i=i+1;
	END WHILE;
    END$$
DELIMITER ;

运行完上述代码将存储过程保存，之后在执行该存储过程即可。

#执行存储过程
call addphone();