DB Audit

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
andrei.mita
Forum Commoner
Posts: 65
Joined: Sun May 08, 2005 4:06 am
Location: Barlad/Romania

DB Audit

Post by andrei.mita »

Hello,

I have a 44 columns table in MySQL and want to track around 30 of those columns. Probably I will have triggers only on update but I am not sure how to make the design. I thought to have 1 table with all the 44 with the latest information update and then another 30 to store the changes for the columns I want. Is this ok, do you know any documentation that will help me understand better?

Thanks
Post Reply