This mySQL “Insert from another table with select” example shows how you can concatenate two of the selected fields into one inserted field.
In this example we are inserting data into tbllistings using data from tblrawdata but we are doing other processing on fields before it is inserted. Obviously you can use any of the other mySQL select string, arithmetic and mathematical operators and functions when you do your select statement and then insert those into the new table.
INSERT INTO tbllistings (
property_id,
agent_id,
property_address,
property_borough,
.. etc
)
SELECT
Prop_ID,
concat(property_id, agent_id),
prop_name,
prop_street,
.. etc
FROM tblrawdata;