audit trails

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