Posted on 2004-04-19
Hi, I am a newcomer for the EE. I am a student and now I have a few questions to ask , hope that you can help me out.
These are my system development tools ->
Database : Mysql
Language : JSP,java,js
I got to do a audit trail report which is keep track what data in the database have been changed by users.
This report will show all the changes to master data.
In order to do this report, I got to keep track every data in the database so that I can know what data have been changed and when it changed.
Can I know Mysql got provide any build-in functions so that I can check it out when and what data has been changed for each table?
If there is no build-in function, do you have any advise for me in order to complete this assignment?