定期删除
#!/bin/bash
HOSTNAME="192.168.111.22" #数据库信息
PORT="3306"
USERNAME="root"
PASSWORD="123456"
DBNAME="test" #数据库名称
TABLENAME="student" #数据库中表的名称
delete_sql="delete from ${TABLENAME} where row_date = '${tenDaysAgo}' "
optimize_sql = "optimize table ${TABLENAME}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${delete_sql}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${optimize_sql}"