shell 统计mysql数据库的表的行数

shell 统计mysql数据库的表的行数

#!/bin/bash

echo -n "MySQL username: " ; read username
echo -n "MySQL password: " ; stty -echo ; read password ; stty echo ; echo

mysql -u $username -p"$password" -NBe "SHOW DATABASES;" | grep -v 'lost+found' | grep -v 'performance_schema'  | grep -v 'mysql' | grep -v 'information_schema' | while read database ; do
mysql -u $username -p"$password" -NBe "SHOW TABLES;" $database | while read -a row ; do
tablename=${row[0]}

cnt=`mysql -u $username -p"$password" -NBe "select count(*) from $database.$tablename"`
echo "$database.$tablename count is $cnt"

done
done

效果：