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? 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. Link to comment https://forums.phpfreaks.com/topic/170394-moving-between-tables/#findComment-899134 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.