MySQL统计库下面每个表的数据

mysql -h xxxxxxxxxxxx -uxxxx   -pxxxx  -P3306 -e "SELECT table_rows,table_name FROM information_schema.tables WHERE TABLE_SCHEMA = 'pth' ORDER BY table_rows DESC;" > $(date +%F)aaa.txt