#!/bin/sh
DB_USER="root"
DB_PASS="123456"
DB_NAME="igames"
DB_TABLE="table"
DATE=`date +%Y_%m_%d`
BIN_DIR="/IGames/server/mysql/bin"
BCK_DIR="/home/whl"
DELETESQL_EAT="DELETE FROM TB_BACK_EAT where createTime <SUBDATE(DATE_FORMAT(NOW(),'%Y-%m-%d 00:00:00'),INTERVAL 70 DAY)"
DELETESQL_BET="DELETE FROM TB_BACK_BET where createTime <SUBDATE(DATE_FORMAT(NOW(),'%Y-%m-%d 00:00:00'),INTERVAL 70 DAY)"
${BIN_DIR}/mysql -u${DB_USER} -p${DB_PASS} ${DB_NAME} -e "call SP_BACK_BAK()"
linux shell 调用存储过程
最新推荐文章于 2021-06-09 10:36:35 发布