#!/bin/bash
HOST='127.0.0.1'
PORT=3306
USERNAME='test'
PASSWORD='test'
DB='test'
#读取字段总数
FIELDNUM=5
select_sql='select * from test'
list=(`/opt/mysql/bin/mysql -h ${HOSTNAME} -u ${USERNAME} -P ${PORT} -p${PASSWORD} -e "use ${DB};${select_sql}" -N -s`)
#总数
total=${#list[@]}
#总行数
line=`expr ${total} / ${FIELDNUM}`
for((i=0;i<${line};i++));do
j=$[$i * $FIELDNUM]
echo ${list[j+0]}-${list[j+1]};//输出第一个字段和第二个字段
done;
备注:myql要写绝对路径,不然脚本可执行但是放到crontab就无法执行了!