MySql change logging

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

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

My SQL wrote:
Quoted text here. Click to load it

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?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?

Re: MySql change logging

I dont like a timestamp column because what if two people changed it?
One change timestamp will overwrite another..

Site Timeline