I want to do a mysql search by creation date of all records, that is, I want it to show the record and the date it was registered.
I've researched but what always shows is between but that's not what I'm looking for.
What should I do?
MySQL search by record creation date
1
asked by anonymous 12.11.2018 / 18:57
1 answer
0
Your application must include the record creation date - most frames and applications have a mix of "time-stamped model", or equivalent, that can be used in your models - in these cases, the data and last change are placed in specific columns in your tables.
And in such cases, just do a query for that column, or put those columns in the order-by.
If the application that creates the table and inserted the records did not do this, only with the data in the database it is not possible to know the time of creation of the records. If the automatic record ID is not a string (for example, if it is a UUID), not even the insertion order can be retrieved.
If it is a production bank and you have enabled the general logs (not just the error logs) - in this case, the insertion and change timestamps in the database can probably be extracted from these logs. However, this generation of logs is not active in the default configuration (see here: link )
12.11.2018 / 19:24