I am looking to extract a very large dataset (1.5 million rows, or so) to Excel files per a request from a business partner. Since this is larger than the Excel row count limit, my thought was to split the extract in the MySQL code via LIMIT clause by adding the following at the bottom to a series of scripts extracting the same data:
LIMIT 0, 250000;
I have set the drop down to "Fetch All Rows" at the top by execute.
The only problem is, if the LIMIT clause in the query is above 10,234 it will fetch one row less than the LIMIT clause specifies.
LIMIT 0,10000; fetches 10000 rows
LIMIT 0,11000; fetches 10999 rows
LIMIT 0,10235; fetches 10234 rows
LIMIT 0,10234; fetches 10234 rows
I'm running Toad Data Point 220.127.116.11 64 bit.