Mysql User 더미데이터 넣는 프로시저

DELIMITER //

CREATE PROCEDURE InsertUsersData()
BEGIN
    SET @vn_data1 = 'test1_';
    SET @vn_data2 = 'test2_';
    SET @i = 1;

    WHILE @i <= 10 DO
        INSERT INTO users (username, email, PASSWORD)
        VALUES (CONCAT(@vn_data1, @i), CONCAT(@vn_data2, @i), 'password123');
        SET @i = @i + 1;
    END WHILE;

    COMMIT;
END //

DELIMITER ;

//호출
CALL InsertUsersData();