Mysql query to obtain date of entry of a data to the database

Question

Mysql query to obtain date of entry of a data to the database

Navigation

#1 by (1 votes)

1

I have a database in MYSQL and I designed the table to receive answers but I did not make a date field for it. My question is whether in MYSQL there is a query to know on what date an insert was made. Thank you very much.

mysql

asked by Carlos Cespedes 01.11.2018 в 16:39

source

1 answer

Any way for a user to modify the $ _SESSION []? Send to a View the list of Customers in my database

score 1 · Accepted Answer

I am afraid that not dear fellow. The subject of audit of the registers at the level of each table must be kept in the same in a date or datetime field, either for the creation of a record or its update.

Another way is to take it in a general way in another parameterized audit table for an entire system. In this aspect there are opinions from both sides.

Unfortunately it is what I can narrow down on your question. Greetings.