Hi Everyone
I have posted this question quite a while back and noticed now
that I haven't gotten an answer as yet and this is still on my
unresolved list.
We have 2 tables which we want to archive data from.
We need to be able to delete all data from the 2 tables that is
older than the start of yesterday.
The process of determining the rows manually is easy enough,
however we would like to cut out manual intervention and automate this
process.
I have played around with trying to create a stored routine /
function which is then passed the date as a parameter and then to use
this to determine the rows and delete them.
- This created 2 problems for me though
-- initially I struggled with the date format
because it does not want to accept the date format.
-- when at last it seemed to accept the date
format , it caused the script to not exit upon completion.
I am sure there must be a better way to do this than using
functions and linux scripts to automate the process, however my
experience is failing me in this respect as I am fairly new to the dba
scene.
I would really appreciate it if someone can assist me in this
regard please.....
Regards
Machiel
PS.... someone already suggested me using MySQL scheduled events ,
however I was not able to figure out how to use it for this
functionality though.
