Audit Trail

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?

Thank you.

Who is Participating?
chrisboltConnect With a Mentor Commented:
Enable mysql's binary log, which is usually meant for replication.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.