Quoting Machiel Richards :
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 -e 'DELETE FROM Syst
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 wrote:
> Hi Everyone
>
>I have posted this question quite a while back and
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