Does MySQL SQL get the most recent records in a table?

Question

I have a sql statement as shown below to get the latest records in a table. I have two questions:

• Is it better to order by id or by date?

• How do I rewrite this sql statement to re-order by date?

  SELECT id, comment, DATE_FORMAT(entry_date, '%W %H:%i') FROM comments ORDER BY id DESC LIMIT 10
  

Answer 1

It depends on what you mean by the latter:

If you mean the most recently created record, then (in most cases) using the primary key identifier will work.

If you mean the latest updated record, then definitely by date.

To sort by date, just change the field name: ORDER BY entry_date DESC

Answer 2

100% , . , , , , , id-s.

id . , , , , . , id (6,7,8, -7, -6...), id, , id date.