/Shell/Bash/Bash mysql query count get only number

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"

Similar codes

4 votes136 views2 answers
Get ros version
Shell/Bash
0 vote139 views1 answer
Batch compress mp4
Shell/Bash
0 vote144 views1 answer
Switch case ruby on rails
Shell/Bash
0 vote144 views1 answer
Gem pg install error mac os
Shell/Bash
1 vote136 views1 answer
Get element by index bash
Shell/Bash
4 votes130 views4 answers
Conda set python version
Shell/Bash
0 vote91 views1 answer
Errors were encountered while processing: libc-bin
Shell/Bash
1 vote122 views1 answer
How to do sum with exper in linux
Shell/Bash
40 votes122 views4 answers
Cancel merge
Shell/Bash
0 vote152 views2 answers
Vim brew
Shell/Bash