title: In mySQL, how do I make a Trigger so that one table keeps a change log from ALL other tables?
body: <p>My idea was to have a table called "changelog_table" that had the following columns:</p>
  
  <pre><code>updated_table     //the table being updated
  updated_column    //the column being updated
  updated_row       //the id of the row being updated
  updated_content   //this is what they updated the field to
  updated_user      //the user who updated
  updated_datetime  //the timestamp it was updated
  </code></pre>
  
  <p>I think this is both the minimum and maximum of what I'd really want, but I may be wrong.
  Also...I do not understand, after weeks of reading, how to store variables (like "which table is being updated" and "which column is being updated" and so forth) in my trigger.</p>
  
  <p>So let's say I had a table called "foo_table", with a column "bar_column", with a row "58008", that is being updated to "this is the new content", by user "peter_griffin", at 12/30/2013 at noon.</p>
  
  <p>What would a trigger that could capture that look like?</p>