Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- MySql change logging
August 26, 2005, 8:12 am
rate this thread
Is it possible for me to have the daily updation and insert queries
performed on the MySQL DB saved? This will help me track when a
particular record was modified in the DB.
Is there any other way to track as to when the changes were made to the
DB? I also want to add who made the changes but this will come at a
later stage once the user login is implemented. It will be great if I
can atleast store a log file or something daily.
Re: MySql change logging
Why not a a timetsamp column to every table? Everytime a record is
changed/updated the timestamp is modified to reflect the time of the change.
You can also add a column for the user, the value of this column has to
be updated by code or manually, it can not be done by the MySQL engine.
A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
Q: What is the most annoying thing on usenet and in e-mail?
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum