Shell Programming and Scripting

#! /bin/bash
# initialization of dates
 
mysql -u root -D rddatabase
 
$a= 'select count(*) from orders where OrderTimestamp > 20110819';
 
echo $a

user="root"
db="rddatabase"
result=$(mysql -u $user $db -sN -e "'select count(*) from orders where OrderTimestamp > 20110819'")

user="root"
db="redeyedatabase"
result=$(mysql -u $user $db  -e "select count(*) from orders where OrderTimestamp > 20110819")

count(*) 3862

echo $result | awk '{print $2}'

result=$(mysql -N -r -B -u $user $db  -e "select count(*) from orders where OrderTimestamp > 20110819")

#!/bin/ksh
##  The command in $() returns COUNT=<nbr> which is then eval'd to create
##  and set a shell variable called COUNT.
eval $(print "select 'COUNT='||count(*) as count from schema.table_name;"|sqlplus -s / |grep COUNT=)

print "The count is $COUNT"