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

For example: I have a SQL query like this:

select hw.family,hw.id 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?

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
how can I have the output files created with different names according
with the id inputs in the run time?

Thanks a lot.

leileili (AT) hotmail (DOT) com wrote:
There is nothing dynamic about your SQL statement nor is there a need
to dynamic SQL.

What you need to do is create an external table to the text file.
Then just do an INSERT INTO ... SELECT FROM ....

You can find a demo of external table creation at:
http://www.psoug.org
click on Morgan's Library
click on External Tables
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

oh, I'm sorry, I'm sending this to comp.database.ms-access,
hope that's a right place to get right answer.

<leileili (AT) hotmail (DOT) com> wrote

ms-access is Microsoft Access

you want a MySQL group

can't find any MySQL group here.
Trying www.mysql.com now.
Thanks.

leileili (AT) hotmail (DOT) com wrote:

: mysql -u usrname dataname< /directory/sqlfile
: >/directory/outputfile/id_???

That is mysql. This is an Oracle group. A good answer for Oracle will
not help you in mysql.

Personally, I would use perl and DBI.



--

This space not for rent.

but I don't own the database.
Can I still do this?

Thanks.

<leileili (AT) hotmail (DOT) com> wrote

Jim

leileili (AT) hotmail (DOT) com wrote:
: can't find any MySQL group here.
: Trying www.mysql.com now.
: Thanks.


Quoted from another group, where someone is promoting the start up of a
new group called comp.databases.mysql

:There are two news groups devoted to MySQL. Unfortunately their
:names don't comply with the conventions used for other database
roducts.

:mailing.database.mysql
:mailing.database.mysql-win32


I've never read em, but try

mailing.database.mysql
OR mailing.database.mysql-win32


--

This space not for rent.

thank you, www.mysql.com forum doesn't have any reply.
I'm trying mailing.database.mysql now. Thanks for the
pointer.