Any way to move over an entire table of data in one shot?

I know you can move over data to another table, but I also noticed you need to do it field by field.
Is there anyway to use wildcards (like .) to move all fields over to a new record in another table (with identical structure)?
As per the manual:
==========================================================================================
global $conn;

$strSQLInsert = "insert into CandidateTemp (Field1, Field2) values (Value1, Value2)";

db_exec($strSQLInsert,$conn);
==========================================================================================
Now, there are over 30 fields in this one table and I need to move over the entire record. Is there any way to move the entire record?
Mike