示例数据库
大概看了下,知道这些文件是用来创建数据库、表并支持导入数据,但其中一个文件sql_test.sh看的不是很明白,可否写一个执行这个文件的执行示例语句?
文件上半部分,大概看明白了,下面这部分没看懂,如果可以,希望老师上课讲一下。
for T in $($MYSQL -BN -e ‘show tables from employees’)
do
CRC_TEXT=$($MYSQL -BN -e “checksum table $T” employees)
COUNT=$($MYSQL -BN -e “select count(*) from $T” employees)
CRC=$(echo $CRC_TEXT | awk ‘{print $2}’)
expected_crc=$(get_expected $T crc)
expected_count=$(get_expected $T count)
if [ “$expected_count” == “$COUNT” ]
then
COUNT_RESULT=OK
else
COUNT_RESULT=DIFFERS
fi
if [ “$expected_crc” == “$CRC” ]
then
CRC_RESULT=OK
else
CRC_RESULT=DIFFERS
fi
printf “%-15s %'10d %'15d (%-7s %-7s)\n” $T $COUNT $CRC $COUNT_RESULT $CRC_RESULT
done
谢谢