dynamic query question

Hello,
I'm new in dynamic query and I have a problem need help.

For example: I have a SQL query like this:

select hw.family,hw.id from hw where hw.id="1234567";

and I have a txt file holding more than ten thousands id.
I need feed the ids from the file to the SQL query, inside
the "???", please let me know how can I do this?

another question is:
then I put the SQL query in a file and run it from another .csh
file. Inside the .csh file, I have something like this:

mysql -u usrname dataname< /directory/sqlfile

>/directory/outputfile/id_???

how can I have the output files created with different names according
with the id inputs in the run time?

Thanks a lot.

.

Relevant Pages

  • Re: Is there an SQL query for table schema ...
    ... > Is there an SQL query that will return a list of all indexes on a ... > In addition will it list the fields involved if it is a compound index? ... Prev by Date: ...
    (microsoft.public.access.queries)
  • 1-in-N Selection in SQL
    ... a dataset of several thousand using an SQL query? ... Neil ... Alternative Network Directory ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: select distinctrow
    ... >I am trying to make a form, where I have 4 lookup boxes. ... >it makes a sql query and every time I go to make another it overwrites the ... I have no idea what you mean by "preceded by the letters a b c.." ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)
  • Re: Database searching via asp/vbscript
    ... I've considered using the like command however the problem is that ... need a way of generating the actual sql query. ... Simon ... Prev by Date: ...
    (microsoft.public.scripting.vbscript)
  • query too Complex
    ... view which joins the tables gives an SQL query too complex... ... When I zap the table it works as expected. ... when I compile it in VFP7 it works without any problem. ... Prev by Date: ...
    (microsoft.public.fox.programmer.exchange)