mysql concat two columns and insert another existing table in same table code example

Example: mysql concatenate two columns into one

SELECT concat(first_column, ' ', second_column) from table_name