- Jan 19, 2006
- 1,117
- 1
- 0
Had a question regarding a simple SELECT in MySQL. Assuming the table has no primary key or index defined, I don't really care the order records were inserted, just how they're stored in table.
If I do a SELECT * FROM `table` LIMIT n, will I get back the rows in the same order as how it's stored in the table? I've tried on small sample and seems the case, but just wanted to make sure.
Just for some context, there's a ~3 billion row table that we want to try and transfer from AWS RDS MySQL instance to S3. So just want to be able to transfer in chunks rather than whole thing at once.
If I do a SELECT * FROM `table` LIMIT n, will I get back the rows in the same order as how it's stored in the table? I've tried on small sample and seems the case, but just wanted to make sure.
Just for some context, there's a ~3 billion row table that we want to try and transfer from AWS RDS MySQL instance to S3. So just want to be able to transfer in chunks rather than whole thing at once.