#!/bin/bash
HOSTNAME="111.111.111.111"
PORT="1111"
USERNAME="username"
PASSWORD="password"
DBNAME="dbname"
TABLENAME="tablename" #表名称
MYSQL_HOME=/home/**/**/mysql/
sql="select * from ${TABLENAME}" #SQL语句
${MYSQL_HOME}/bin/mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${sql}"