this typically works:
UPDATE user SET username=fname||" "||lname;
the ||" "|| adds a space between them, typically not a good idea for usernames to ahve spaces though, might want to change it to an underscore or something
Note that in MySQL you'll need to use the concat function so it'd be
UPDATE user SET username=concat(fname," ",lname);
hope that helps.