Jump to content

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


simplyrichard

Recommended Posts

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 :)

 

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.