Thanks for the question, Mauricio.
Asked: July 05, 2018 - 9:48 pm UTC
Last updated: July 06, 2018 - 4:37 am UTC
Version: 18.2
Viewed 1000+ times
You Asked
Hi, I have a this...
Select * from MYDB where MYDB.ID IN (1,2,3...5000000)
Any way to export without 1000 output lines ¿?
Thanks
and Connor said...
You only get 1000 entries. Options you could consider:
1) Insert the data into a temporary table, then do:
Select * from MYDB where MYDB.ID IN (select id from my_temp_table)
2) Break it up into chunks
Select * from MYDB
where MYDB.ID IN ([1st 1000 entries])
or MYDB.ID IN ([2nd 1000 entries])
or MYDB.ID IN ([3rd 1000 entries])
Go with option 1 :-)
Is this answer out of date? If it is, please let us know via a Comment