Basically, I think we both want to copy a row back into the same table. At the moment I use a SELECT query to get all the information and then a seperate INSERT query to add the new row(s).
Not 100% sure but I think that would require a sub-select, something which (if a remember correctly) is not available in MySQL. Which database are you using?
redmonkey wrote:something which (if a remember correctly) is not available in MySQL
IIRC, MySQL 5.0 has sub-selects..
I wasn't taking into account 'alpha' versions. Considering the production release is only v4.0 I think you are in for a long wait for sub-selects in MySQL within a production environment.