| Author |
MySql change logging
|
|
| My SQL 2005-08-26, 7:23 am |
| Hi
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.
Thanks
| |
| Jonathan 2005-08-26, 7:23 am |
| My SQL wrote:
> Hi
>
>
> 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.
>
>
> Thanks
>
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.
Jonathan
--
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?
| |
| My SQL 2005-08-26, 9:23 am |
| I dont like a timestamp column because what if two people changed it?
One change timestamp will overwrite another..
|
|
|
|