获取MySQL DB表条目的时间

Question

I have a application form that should have been closed last friday. Due to things I can't control, it wasn't closed, and now people have applied after last friday. Unfortunately, those people can't come to the event, so we have to contact them to tell them the bad news.

My problem is, that when I made the form I was too fast and forgot to add a timestamp in the table.

Is there some way (either using php, phpmyadmin or sql-commands) to find out who has applied after a certain time (i.e. when the row was added to the table)?

The Database is a MySQL-database.

Answer 1

Does the table have an autoincrementing ID field?

If so, figure out the value of that ID field for the last person you were able to accept, then use this query in an SQL client like phpmyadmin.

  SELECT * 
    FROM tablename
   WHERE tablename.id > last_accepted_id

That will show all the rows for people to which you owe bad news.