Truncate the table contents which is older than N days

Add the below line as a cronjob :

/usr/bin/mysql -e “DELETE FROM table_g WHERE date < DATE_SUB(NOW(), INTERVAL N DAY)" -D database_g

Where,

* table_g : Table name
* database_g : Database Name

Cheers 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s