Perad Posted March 23, 2009 Share Posted March 23, 2009 What is the most efficient way to transfer a record to an identical table? I need to create an archive which stores processed items. Is there some mysql function that allows me to transfer and delete all records from one table and move them to another? Quote Link to comment Share on other sites More sharing options...
fenway Posted March 27, 2009 Share Posted March 27, 2009 INSERT INTO... SELECT WHERE??? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.