rsyslog mysql database clear

mysql -u user -ppassword -e 'DELETE FROM SystemEvents WHERE ReceivedAt < date_add(current_date, interval -7 day)' database-name