I have a membership system on my website and I am dropping all the user data (name, address etc) into a table called 'temp'.

Once payment for membership has been made wish to copy 'ALL' data from 'temp' across to another table called 'members'

Is there a way to do this without having to write out insert code for every single column?