mysql 表空间的自动发现
function database_discovery {
arr=$(${mysql} -u${MYSQL_USER} -p${MYSQL_PASSWORD} -h${MYSQL_Host} -e "show databases;"|grep -v Variable_name|sed 1d)
##字符串变数组
datacount=($(echo $arr))
printf '{\\n'
printf '\\t"data":[\\n'
for((i=0;i<${#datacount[@]};++i))
{
num=$(echo $((${#datacount[@]}-1)))
if [ "$i" != ${num} ];
then
printf "\\t\\t{ \\n"
printf "\\t\\t\\t\\"{#DATA_NAME}\\":\\"${datacount[$i]}\\"},\\n"
else
printf "\\t\\t{ \\n"
printf "\\t\\t\\t\\"{#DATA_NAME}\\":\\"${datacount[$num]}\\"}]}\\n"
fi
}
}
收起