#!/bin/bash
HOSTNAME="localhost" #数据库信息
PORT="3306"
USERNAME="root"
PASSWORD="root"
DBNAME="test" #数据库名称
DATE=$(date -d '1days ago' +%Y-%m-%d)
GID="55"
GAMENAME="tj"
#select_sql="select * from ${TABLENAME}"
#mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e"${select_sql}"
deleteTableRecordsByGameId="call deleteTableRecordsByGameId('${GID}','${DATE}')"
deleteTableRecordsByGameName="call deleteTableRecordsByGameName('${GAMENAME}','${DATE}')"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e"${deleteTableRecordsByGameId}"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e"${deleteTableRecordsByGameName}"