mysql存储过程实现动态插入数据

在作测试的过程中，通常会按需对数据库表进行操作，利用编程的思想利用存储过程来实现数据操作：

drop PROCEDURE IF EXISTS useradd;   #如果存在存储过程，则删除
CREATE PROCEDURE  useradd()         #创建存储过程
BEGIN
 DECLARE username BIGINT DEFAULT 0;  #声明变量
 DECLARE i int DEFAULT 0;
 DECLARE updateStamp BIGINT DEFAULT 0; 
 SELECT UNIX_TIMESTAMP() into updateStamp;  #获取当前时间戳
 SET updateStamp = CONCAT(updateStamp,'000'); 
 set i = 1;
 SET username = 18910000001;
 WHILE i < 20000 DO
       INSERT INTO a_user_info(user_name,update_time) VALUES(username,updateStamp);
       INSERT INTO a_userfeature(user_name,Feature,Feature_count) VALUES(username,"新闻",100);
       INSERT INTO a_userfeature(user_name,Feature,Feature_count) VALUES(username,"财经",90);
       INSERT INTO a_userfeature(user_name,Feature,Feature_count) VALUES(username,"体育",80);
       INSERT I