MySQL offset infinite rows

by

From the MySQL Manual on LIMIT:

To retrieve all rows from a certain
offset up to the end of the result
set, you can use some large number for
the second parameter. This statement
retrieves all rows from the 96th row
to the last:

SELECT * FROM tbl LIMIT 95, 18446744073709551615;

More Related Contents:

  1. How does MySQL process ORDER BY and LIMIT in a query?
  2. i have an error which i dont understand. can you help me? [closed]
  3. In SQL Server how to get the count of child if both parent and child are available [closed]
  4. Delete the entire content of all table in a Database [closed]
  5. MySQL select 10 random rows from 600K rows fast
  6. Get a list of dates between two dates
  7. Calculate a running total in MySQL
  8. Simulate lag function in MySQL
  9. MySQL SELECT only not null values
  10. Calculate Age in MySQL (InnoDb)
  11. Difference between two dates in MySQL
  12. MySQL search and replace some text in a field
  13. Best data type for storing currency values in a MySQL database
  14. Datetime equal or greater than today in MySQL
  15. How to get the next auto-increment id in mysql
  16. MySQL dynamic-pivot
  17. MySQL Workbench: How to keep the connection alive
  18. Can I reuse a calculated field in a SELECT query?
  19. Deleting duplicate rows from a table
  20. Using Count to find the number of occurrences
  21. MySQL INSERT INTO … VALUES and SELECT
  22. MySQL LIKE query with underscore
  23. MYSQL select DISTINCT values in two columns
  24. Compare only day and month with date field in mysql
  25. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  26. What is the difference between SQL and MySQL? [closed]
  27. how to use a like with a join in sql?
  28. How do you force mysql LIKE to be case sensitive? [duplicate]
  29. #1060 – Duplicate column name ‘id’
  30. In what order are MySQL JOINs evaluated?

Leave a Comment