I would like to be able to keep a log of all the modifications that are done in the database. For example, some one makes a change to a value from 4 to 5. I would like to write a table that reads the original value, saves it to a table and reads the value replaced with and saves it to the same table together with the time and date and which the change was done. Are there any other items I should be aware off that need to be kept in a log table? My program is an interface that allows the user to insert, update and delete records from the database. Is there any reading that you would recommend?
posted 4 years ago
I wonder if I can create part of the log by saving the output of the table below to a database table