Good day all
I am hoping this mail finds all well...
I am in need of some assistance please.
We have a few tables that I need to add auditing information for.
The idea is that we need to create an audit table that will track
the following on the main table :
- any changes (updates,deletes, inserts) to the main table
The audit table should include the following information:
-- Who made the changes (username logged in)
-- What type of change (insert,update,delete)
-- Date of change including time.
-- if update, which fields were updated.
-- Query that was run.
I have tried to get similar examples on the net, however no
luck so far that gives the specific information.
I know that this would probably be done using some triggers,
however I am not sure on how to get the relevant information (i.e.
user, query,etc...)
Any help would be appreciated.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
