Page 1 of 1

DB Audit

Posted: Mon Oct 13, 2008 1:46 am
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