INSERT/UPDATE in same query from previous SELECT with some singularities
Insert query:

INSERT INTO pdone.reps (veeva_rep_id,display_name,username,first,last,email,avatar_url,rep_type) 
SELECT 
    Id, 
    CONCAT(UCASE(MID(firstname,1,1)),LCASE(MID(firstname,2)),' ',UCASE(MID(lastname,1,1)),LCASE(MID(lastname,2))),
    username, 
    firstname, 
    lastname, 
    email,
    'www.some_static_url.com',
    '1' 
FROM veeva.user 
WHERE Id = "00580000003UB5VAAW"


It will print Only first letter capital from both First &amp; Last name.