[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