Archiving data. How should one handle such transactions? :o

[simplyrichard]

I'm working on a application that requires me to make a archive of every row upon delete. What is the best was to handle these tranactions? Should I do it via php or is there something on mysql end that will handle this?

 

 

Richard

[severndigital]

if they have to be removed from the table all together

you could create a new table called deleted_rows and move them into that table upon deletion.

 

then once a month or whatever export from mysql.

 

if not, then add a field called active or something and give active items a value of 1, and "removed" items a value of 0.

 

then when you do your query's look for only active = 1

 

 

just my 2 cents, you can give me change if you want

 

[simplyrichard]

I want to keep my tables clean. I'm shocked that there is no way to collect all the information in a row and move it over to a new table. Blah. I know i can do it by many queries but I was hoping for a more efficence way of doing it.