MySQL – Select the last inserted row easiest way

by

It would be best to have a TIMESTAMP column that defaults to CURRENT_TIMESTAMP .. it is the only true predictive behavior you can find here.

The second-best thing you can do is ORDER BY ID DESC LIMIT 1 and hope the newest ID is the largest value.

More Related Contents:

  1. What is better subquery vs literal on IN clause in mysql
  2. How can I select data from different tables?
  3. SQL query return data from multiple tables
  4. Select all columns except one in MySQL?
  5. MySQL SELECT only not null values
  6. What is MySQL row order for “SELECT * FROM table_name;”?
  7. Select mysql query between date?
  8. MySQL SELECT increment counter
  9. mysql select from n last rows
  10. MySQL select with CONCAT condition
  11. How does MySQL’s ORDER BY RAND() work?
  12. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  13. MySQL INSERT INTO … VALUES and SELECT
  14. Mysql select distinct
  15. How to select one row randomly taking into account a weight?
  16. Compare only day and month with date field in mysql
  17. Sum results of a few queries and then find top 5 in SQL
  18. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  19. Syntax error when using except in a query
  20. MySQL INNER JOIN select only one row from second table
  21. Using index, using temporary, using filesort – how to fix this?
  22. What is the default MySQL JOIN behaviour, INNER or OUTER?
  23. MySQL : retrieve a large select by chunks
  24. MySQL – insert data from another table merged with constants
  25. Insert data into table with result from another select query
  26. How to SELECT by MAX(date)?
  27. How to use Table output from stored MYSQL Procedure
  28. MySQL matching unicode characters with ascii version
  29. MySQL Select Multiple VALUES
  30. mySQL returns all rows when field=0

Leave a Comment