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
DB Audit
Moderator: General Moderators
-
andrei.mita
- Forum Commoner
- Posts: 65
- Joined: Sun May 08, 2005 4:06 am
- Location: Barlad/Romania