SQL query taking input from a file

Question

I have following SQL query -

SELECT * FROM users where id=X

Here 'X' is the set of values which need to be read from a file say ~/ids.lst. I have following approach in hand.

Read ids.lst and load all variables.
For each variable form and fire an SQL query and concat the results.

I have working code in python, but the problem is if I have n ids, then n queries will be made to server. Is there any way I could achieve the same with a single query to server?

I can't! My query is not exactly what I mentioned above. It is a code which I can't make public, but with the algo above, the motive should be well understood! — Mangat Rai Modi
– Mangat Rai Modi, Commented Nov 4, 2014 at 6:47

NPatel · Accepted Answer · 2014-11-04 06:44:00Z

3

You can use in operator for single query.

SELECT * FROM users where id in (<concat ids with , (comma) read from file.>)

This will be single query and faster compare to individual query.

answered Nov 4, 2014 at 6:44

NPatel

21.4k17 gold badges104 silver badges165 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mangat Rai Modi Over a year ago

Aweseome! It is exactly what I was looking for.

Collectives™ on Stack Overflow

SQL query taking input from a file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related