[lug] Shell Script

Bob Collins bcollins at csd.net
Fri Aug 25 10:40:34 MDT 2000


I have searched all my books and the library for information on the

<<QUERY_INPUT
 ... 
QUERY_INPUT 

portion of the following script.  I would appreciate a pointer to where
I can find out about it and/or an explantion.

#! /bin/sh
if [ $# -ne 1 ]; then echo "please specify one keyword"; exit; fi

mysql -t samp_db <<QUERY_INPUT
SELECT last_name, first_name, email, interests FROM member
WHERE interests LIKE "%$1%"
ORDER BY last_name, first_name;
QUERY_INPUT

-- 
Regards,
Bob Collins
                         Mailto:bcollins at csd.net
                      http://www.csd.net/~bcollins




More information about the LUG mailing list