分库分表表结构检查脚本

#tableLike 表名 ，keyword 检查关键字

tableLike=$1

keyword=$2

for i in {0..7}

do

for j in {0..31}

do

inx=`echo $j | awk '{printf("%02d\n",$0)}'`

table=" db_0${i}.${tableLike}_${inx}"

cmd=" show create table ${table}"

res=`mysql -h 127.0.0.1 -P 3306 -umcsp_stc_search -p112233 -e "${cmd}" `

if [ "$res" == *"$table"* ]; then

echo $table

fi

done

done

echo "check over!"