Archive data (table rows) mysql -


i have data in table row associated user. i'd archive old data based on year. however, data associated count user, i.e. each user has purchased "post" , each "post" row in table. if delete (drop row) "post" software automatically adjust number of available "posts" user.

i'd able archive or delete old "posts" in database, without crediting use of post user. php like: user1 has 30 credited "posts" of 15 have been used therefore 15 "posts" remain. dropping row manually results in: user1 has 14 "posts" used , 16 "posts" remaining.

i'd clean out old "posts" 80,000 of them.

is there standard method of doing this?


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

Kivy: Swiping (Carousel & ScreenManager) -

jdbc - Not able to establish database connection in eclipse -