在作测试的过程中,通常会按需对数据库表进行操作,利用编程的思想利用存储过程来实现数据操作:
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