Select remote database from bash

Question

I'm kind of new in bash/shell scripting and I'm trying to remotely select from mysql database and check if record exist or no. Based on respond will do some stuff.

This is what I have as a command

mysql -u mysql -pMysql123 -h xxx.xxx.xxx.xxx MYDBNAME -e "select count(column) from TABLE where column=1234;" 

When I run this command directly in terminal I've got correct response. So I'm trying to put it in the script like this

#!/bin/bash count=mysql -u mysql -pMysql123 -h xxx.xxx.xxx.xxx MYDBNAME -e "select count(column) from TABLE where column=1234;" if [ $count -gt 0 ] then echo " greater that 0 " else echo " lower than 0 " fi 

When I execute above script the output is

$ ./check.sh

./check.sh: line 3: -u: command not found

./check.sh: line 5: [: -gt: unary operator expected

lower than 0

Appreciate any help on this. Thanks.

Answer 1

you need a subshell. try this:

count=$(mysql -u mysql -pMysql123 -h xxx.xxx.xxx.xxx MYDBNAME -sse "select count(column) from TABLE where column=1234;") if [ $count -gt 0 ] then echo " greater that 0 " else echo " lower than 0 " fi 

also take note of the -s option:

--silent, -s Silent mode. Produce less output. This option can be given multiple times to produce less and less output.