HuyPV
Tuesday, February 2, 2010
Only one command (Add to crontab)
mysql -uhuypv -pXXX -h mysql-server vtv -e "DELETE FROM schedule WHERE started_time < now() - INTERVAL 3 MONTH"
Title:
Remove old records in MySQL by only one command
Description:
Only one command (Add to crontab) mysql -uhuypv -pXXX -h mysql-server vtv -e "DELETE FROM schedule WHERE started_time
...
Rating:
4