CODE EXAMPLE FOR SHELL

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"