transfer mysql data to another table?
Posted 05 January 2006 - 08:55 PM
say you have a table called news and then a table called archives, and you want to transfer the data from news to archives, is this possible? I want to be able to transfer it by ticking the news you want transfered then clicking a button (i get all that fine) just wondering how i would go about transfering it, is it possible?
thanks in advance.
Posted 05 January 2006 - 09:00 PM
Posted 05 January 2006 - 09:15 PM
Alternatively, "INSERT INTO archives SELECT * FROM news", and then "DELETE * FROM archives WHERE uid=(SELECT MAX(uid) FROM archives)".
Why delete archived news
I thought the basic ideas was to insert old news into archives and delete them from the news table
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users