using SELECT sql statement in shell script | Unix Linux Forums | Shell Programming and Scripting

host=`echo " SELECT hostname FROM main WHERE serial =$SN"|/usr/sfw/bin/mysql -h db-server1 -utest TEST` ...

www.unix.com