MySQL bash shell one-liners

This is a useful thing to know if you're ever trying to use data in files to grab data from a MySQL database: You can feed in SQL query strings to the mysql client in the bash/shell standard way:

bash> mysql -u paul -h myhost -pmypass test_paul <<< "SELECT id from a_table where a_name='boo-yah';" 

Which means that you can put this in a shell script (or Perl script, or whatever). For example, to print out the addresses associated with a set of names:

for name in `cat names.list`;
   do address=`mysql -u paul -h myhost -pmypass test_paul <<< "SELECT address from a_table where a_name='$name';"`;     echo "$name -> $address";
   done