jj20051 Posted November 18, 2008 Share Posted November 18, 2008 Ok I Want To Move Data From One Table To Another and Remove the Data From The Old Table. I Know It Will Invlove A SQL="DELETE something FROM new WHERE name='$name'"; At The End, but How Would I Copy the Data To Begin with? Quote Link to comment https://forums.phpfreaks.com/topic/133233-moving-data/ Share on other sites More sharing options...
genericnumber1 Posted November 18, 2008 Share Posted November 18, 2008 INSERT INTO dest_table (dest_col_1, dest_col_2) SELECT src_col_1, src_col_2 FROM src_table Quote Link to comment https://forums.phpfreaks.com/topic/133233-moving-data/#findComment-692928 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.