MySql Big Data With Multiple Select

Asked Oct 09 '17 at 17:10

Active Oct 09 '17 at 17:10

Viewed 31 times

I have an MySQL database with a table named "foo". Foo has ~50.000.000 records. What i wanna do is select all the records with multiple queries. For example i'd like to get the first 5000 record first, then do [something] with it, then get the next 5000 record and repeat the process, until i'm finished. I can do it in small parts like this, because of memory limitations. Is there any solution for this?

asked Oct 09 '17 at 17:10

iron24

Cursors are one. http://www.mysqltutorial.org/mysql-cursor/ Also, I'm not sure I'd consider only 50m records Big Data – Marshall Tigerus Oct 09 '17 at 17:11
See also http://mysql.rjweb.org/doc.php/pagination – Rick James Oct 09 '17 at 22:58

MySql Big Data With Multiple Select

0 Answers0