How to view change logs in MySQL database?

Question

MySQL

It is important to bring up the history of data changes in the MySQL database in a particular table over the past 90 days. How can I do that?

Answer 1

- invent a time machine
- return to a date 90 days ago
- enable logging of all requests or set up the maintenance and continuous archiving of a binary log
- return to the present and analyze the log configured in the last step
If you have not configured to log changes, then no one will store it . Even the mvcc versioner of innodb will try to clean up old versions of strings. Because why store a bunch of data if there was no requirement to store it?

Answer 2

no such logs

Answer 3

migrations
+ datetime / date field