Deleting of records older than a specific date time

2011-05-23 Thread Machiel Richards
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

Re: Deleting of records older than a specific date time

2011-05-23 Thread John Daisley
A simple stored procedure run by the event scheduler at predetermined times will do this quite easily. Can you post the output of SHOW CREATE TABLE for your two tables? John On 23 May 2011 13:15, Machiel Richards machi...@rdc.co.za wrote: Hi Everyone I have posted this question quite

Re: Deleting of records older than a specific date time

2011-05-23 Thread a . smith
Quoting Machiel Richards machi...@rdc.co.za: We need to be able to delete all data from the 2 tables that is older than the start of yesterday. Hi, I use this ver simple script to purge data from a syslog DB: #!/usr/local/bin/bash /usr/local/bin/mysql -u syslog -pmypasswd