SQL表 - 从表复制到表

I have two tables that are identical to each other on the same database, one is a temporary 'holding' table for uploaded data, the other is the live data table which will store the permanent data.I have two tables that are identical to each ot