Select last row in MySQL

by

Yes, there’s an auto_increment in there

If you want the last of all the rows in the table, then this is finally the time where MAX(id) is the right answer! Kind of:

SELECT fields FROM table ORDER BY id DESC LIMIT 1;

More Related Contents:

  1. Why do I get an error from this sub query script?
  2. sql query to modify the selected value from database [closed]
  3. how to get similar search results in MySQL?
  4. How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?
  5. Can I concatenate multiple MySQL rows into one field?
  6. Disable ONLY_FULL_GROUP_BY
  7. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  8. How to do the Recursive SELECT query in MySQL?
  9. MySQL, update multiple tables with one query
  10. MySQL foreign key constraints, cascade delete
  11. How do I see all foreign keys to a table or column?
  12. Mysql or/and precedence?
  13. MySQL “Group By” and “Order By”
  14. CHECK constraint in MySQL is not working
  15. MySQL Query to select data from last week?
  16. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  17. Migrate from Oracle to MySQL
  18. Which is more efficient: Multiple MySQL tables or one large table?
  19. Are there disadvantages to using a generic varchar(255) for all text-based fields?
  20. How to skip columns in CSV file when importing into MySQL table using LOAD DATA INFILE?
  21. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  22. MySQL InnoDB foreign key between different databases
  23. Images in MySQL
  24. Replace Into Query Syntax
  25. Loading utf-8 encoded text into MySQL table
  26. adding RMySQL package to R fails (on Windows)?
  27. Ruby gem mysql2 install failing [duplicate]
  28. What’s the best way to migrate a Django DB from SQLite to MySQL?
  29. MySQL “IN” queries terribly slow with subquery but fast with explicit values
  30. How to create and insert a JSON object using MySQL queries?

Leave a Comment