Unable to read and send the output of the count of table through email

Question

Tried to figure out but could not find much help. I want to capture the count of the table and send an email if the count is more than 0. The output in the email should be as shown below only if it crosses the count more than 0. Please help, thanks in advance for helping me out.

spool log;

SELECT count(*)
FROM users
;

spool off

EOF


count=`grep -rn  log | wc -l`
if [ $count != "1" ]
then
cat log | mailx -r [email protected] " ${MAILTO} > /dev/null 2>&1
else
echo "No Sessions found"
fi

Output:

Count(*)
--------
      2

Answer 1

To simplify the work you can replace:

count=`grep -rn  log | wc -l`
if [ $count != "1" ]

with

count=`tail -1  log`
if ["$count" -gt 0 ]

the sql will return only one value (this is the idea of count(*) command) so do not need of wc -l, just grab the last line. And use -eq when compare numbers in bash