#定义存储过程 P_UC_BUILD_USER
#parameter loop_start 起始ID
#parameter loop_end 结束ID

DELIMITER $$
DROP PROCEDURE IF EXISTS `meizu_user`.`P_UC_BUILD_USER`$$
CREATE PROCEDURE `P_UC_BUILD_USER`(IN loop_start INT,IN loop_end INT)
BEGIN
    DECLARE var INT;
    SET var=loop_start;
    WHILE var<=loop_end DO
            SET var=var+1;
            INSERT INTO uc_members(username,`password`,email,regip,regdate,lastloginip,lastlogintime,salt,flyme)
    VALUES (CONCAT('meizutiyanji_',var),'2d925263802cf9367f51d9e74fe2d3bb',CONCAT('meizutiyanji_',var,'@meizu.com'),'125.89.61.122','1330408290','125.89.61.122','1330408290','68dcfc',CONCAT('meizutiyanji_',var));
        
    END WHILE;
END$$
DELIMITER ;

# 调用存储过程 创建800个 flyme账户
call P_UC_BUILD_USER(0, 800);

#删除该存储过程
drop procedure `meizu_user`.`P_UC_BUILD_USER`;