BEGIN
#插入用户相关信息
DECLARE id BIGINT;
DECLARE phone VARCHAR(11);
DECLARE memberid VARCHAR(11);
DECLARE sessionid VARCHAR(50);
#非数据表字段
DECLARE num INT DEFAULT 1;
DECLARE count INT;
SET count = num + 100;
WHILE (num < count) DO
SET id = num;
SET phone = CONCAT(1, ROUND(ROUND(RAND(),10)*10000000000));
SET memberid = ROUND(ROUND(RAND(),8)*100000000);
SET sessionid = '99E69C0584CD9A5B83DB39E152CBE7EE';
INSERT INTO u_userloginapp(id,phone,memberid,sessionid)
VALUES(id,phone,memberid,sessionid);
#累计行数
SET num = num+1;
END WHILE;
END
转载于:https://blog.51cto.com/jiyanle/1719453