#!/bin/bash
user="root" #//mysql username
password="" #//mysql password
dbname="snmpmon" #//snmpmon mysql db name

date=`date +%Y%m --date='2 months ago'`
echo "delete from SNMPMON_IFLOAD where INTERVAL_END <" $date"00000000"|mysql -u $user --password=$password $dbname

