bash mysql count tables code example
Example: bash mysql query count get only number
mysql -h {host} -u {user} -p{password} -e "SELECT COUNT(DISTINCT table_name) FROM information_schema.columns WHERE table_schema = '{dbname}'" | grep -iv "count"mysql -h {host} -u {user} -p{password} -e "SELECT COUNT(DISTINCT table_name) FROM information_schema.columns WHERE table_schema = '{dbname}'" | grep -iv "count"