How to load values from file to mysql, where in (file)

Question

I need to make select where id in ( and here i want to load text file, with one int value per one line)

Any help would be appreciated

Does your input file have a header line, or does the first line contain data? — Tim Biegeleisen
– Tim Biegeleisen, Commented Apr 13, 2016 at 9:23

Andrey Portnov · Accepted Answer · 2016-04-13 09:31:05Z

5

You have to use temporary table

CREATE TEMPORARY TABLE `temp` (`id` bigint(20) NOT NULL, PRIMARY KEY(`id`))

then load data from file using

LOAD DATA INFILE ...

and then select your data using temporary table

SELECT * FROM some_table s, temp t WHERE s.id = t.id

answered Apr 13, 2016 at 9:31

Andrey Portnov

1192 bronze badges

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

Comments

Tim Biegeleisen · Accepted Answer · 2016-04-13 09:22:27Z

2

Because your input text file has only one int value per line, you should be able to get away with this:

LOAD DATA INFILE 'input.txt' INTO TABLE yourTable

answered Apr 13, 2016 at 9:22

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

but i dont want to insert values into table, i need to make query like this: select * from users where id in (file with int values)

MySQL doesn't operate this way. If the data be located in a file, you should first load it into a table. Afterwards, you can query as you want.