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
效果: