Re: dynamic SQL query question

Thank you, I finally got answer from mailling.database.mysql. Thank you everyone.
>>>>>>>>test.sh<<<<<<<

  cat idlist.txt | while read id
   do
     mysql -u username dataname -e "select hw.family, hw.id from hw where hw.id = '$id'" > /directory/outputfile/id_$id

   done Received on Fri May 20 2005 - 14:15:27 CDT