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 veryyyy simple script to purge data from a syslog DB:
#!/usr/local/bin/bash
/usr/local/bin/mysql -u syslog -pmypasswd -e 'DELETE FROM SystemEvents
WHERE ReceivedAt < date_add(current_date, interval -60 day)' Syslog
maybe that is useful for you...?
cheers Andy.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
