如何在SQL表中添加时间戳，然后按时间回显最新的行？ [关闭]

Question

I have a working script which echoes out data from the SQL DB. I am wondering how I would add a way to record the time the row was added then subsequently echo the latest row to my table. You can see for an example on my website HERE.

I want the latest row to show at the top, not the bottom. I'm sure there is an easy solution, but as you can tell I am only just learning this. Thanks if anybody has a solution. I have tried sorting by DESC and ASC in the SQL query but that's sorting it by alphabetical order and I need it to show the latest row of the table at the top.

Answer 1

The way you add a default "creation date" onto a record is well described in the documentation. The code looks something like:

alter table <tablename> add CreatedAt datetime default CURRENT_TIMESTAMP;

(or even better do it in the create table statement). I usually name such a column CreatedAt. Then I sometimes have CreatedBy (for the user) and CreatedOn (for the system).

To fetch the results:

select *
from <tablename> t
order by CreatedAt desc;