mysql 循環比對資料

#!/bin/bash

dir_1="/tmp/check/177/*"

log_dir="/tmp/check/"

mysql_1="mysql - -p-h -P3336"

db_1=`ls -1 $dir_1`

for db_1 in $db_1;

do

    echo "正在執行檢查"${db_1}"資料"

    ${mysql_1} < ${db_1} >> ${log_dir}check.txt

done

dir_2="/tmp/check/178/*"

mysql_2="mysql - -p-h -P3336"

db_2=`ls -1 $dir_2`

for db_2 in $db_2;

    echo "正在執行檢查"${db_2}"資料"

    ${mysql_2} < ${db_2} >> ${log_dir}check.txt