insert two column values into one column

Question

hi
how to insert two column values into another column. please give a query of that
means i take firstname and lastname and username in my table
username = firstname + lastname
how to write insert statement
all values are inserted same time
thanks.