onthespot Posted August 15, 2009 Share Posted August 15, 2009 hey, i have a competitions table and a archive table. they are identical in structure I am looking to create an SQL function that will take the row from competitions, place it in archive and delete it from compeittions. How would I go about doing this? Quote Link to comment https://forums.phpfreaks.com/topic/170394-moving-between-tables/ Share on other sites More sharing options...
wildteen88 Posted August 15, 2009 Share Posted August 15, 2009 This is bad database design. You should read up on database normalisation to setup your databases properly. Quote Link to comment https://forums.phpfreaks.com/topic/170394-moving-between-tables/#findComment-899134 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.