Select last N rows from MySQL

by

You can do it with a sub-query:

SELECT * FROM (
    SELECT * FROM table ORDER BY id DESC LIMIT 50
) sub
ORDER BY id ASC

This will select the last 50 rows from table, and then order them in ascending order.

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. MyISAM versus InnoDB [closed]
  3. How to select the nth row in a SQL database table?
  4. Compare two MySQL databases [closed]
  5. How should I resolve –secure-file-priv in MySQL?
  6. What does character set and collation mean exactly?
  7. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  8. Storing image in database directly or as base64 data?
  9. Implementation of Levenshtein distance for mysql/fuzzy search?
  10. Does MySQL ignore null values on unique constraints?
  11. How do I restore a dump file from mysqldump?
  12. What’s the difference between MyISAM and InnoDB? [duplicate]
  13. Maximum length for MySQL type text
  14. What effects does using a binary collation have?
  15. MySQL SELECT increment counter
  16. Hyphens in column names in MySQL DB
  17. Error Code: 1215. Cannot add foreign key constraint (foreign keys)
  18. Error renaming a column in MySQL
  19. Modeling Product Variants
  20. Mysql database sync between two databases
  21. How do I get the ID of multiple inserted rows in MySQL?
  22. What’s the best database structure to keep multilingual data? [duplicate]
  23. Does mysql have the equivalent of Oracle’s “analytic functions”?
  24. MySQL concatenating all columns
  25. Remove special characters from a database field
  26. Using reserved words in column names
  27. How big can a MySQL database get before performance starts to degrade
  28. What is the difference between SQL and MySQL? [closed]
  29. mysql Failed to read auto-increment value from storage engine
  30. How to store data with dynamic number of attributes in a database

Leave a Comment