I have a CSV file with many integers in the form:
id --- 1 2 3
I need to write a statement that selects ids from a table that are in the list in my CSV.
I could just convert the data 1000 elements at a time into a SQL IN like:
SELECT * FROM TABLE WHERE ID IN (....)
but that would take hundreds of queries, is there a better way I can do this?