#!/bin/bash
HOSTNAME="192.168.116.1"
PORT="3307"
USERNAME="root"
PASSWORD="1234"
DBNAME="db_risk"
TABLE_NAME="brcp_rdifs_index"
GET_TABLE_CNT_SQL="select count(1) from $TABLE_NAME"
cnt3=$($APPROC_PATH/mysqlbin/mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -s -e "${GET_TABLE_CNT_SQL}")
echo "[`date +"%Y-%m-%d %H:%M:%S"`]查询[$TABLE_NAME]表记录数为:${cnt3}";
shell脚本获取SQL执行结果(查询)
于 2022-01-16 16:42:19 首次发布