Shell Programming and Scripting

QUERY OK: 'SELECT 0 as elapsed union SELECT avg(elapsed) as elapsed  FROM elapsed_total where datetime_a > adddate(now(),INTERVAL -1200 minute) order by 1 desc limit 1' returned 0.000000 | result=0.000000;1800.000000;3600.000000;

-m --message Message to output after result. Can take a printf string with a single substitution (defaults to 'query returned') 
-n --message-prepend Display message before rather than after result (prepend)
-s --short Shorten output, do not output message just result

#!/bin/bash

check_mysql_query.pl <whatever your arguments are> >/dev/null 2>/dev/null
returned=$?

if [ "$returned" == "0" ]
then
     echo “OK”
     exit 0
elif [ "$returned" == "1" ]
then
     echo “WARNING”
     exit 1
elif [ "$returned" == "2" ]
then
     echo “CRITICAL”
     exit 2
else
     echo "UNKNOWN"
     exit 3
fi

case "$?" in
0) # statement zero code
   # statement zero code
   ;;
1) # statement one code
   # statement one code
   ;;
2) # statement two code
   # statement two code
   ;;
*) # All other cases
   # All other cases
   ;;
esac