# for i in `seq 1 10`; do mysql -uusername -ppassword database_name -e "SELECT COUNT(*) FROM table$i";done;
bash for loop through numbers
# for i in `seq 1 10`; do mysql -uusername -ppassword database_name -e "SELECT COUNT(*) FROM table$i";done;