title: Capturing MySQL Statement and inserting it into another db via trigger
body: <p>I want to be able to keep a log of every sql statment that edits a specific table, and I think the best way would be with a trigger. However, I don't know how to get the statement that triggers the trigger.</p>
  
  <p>For example if I run:<br>
  <code>
      $sql = "INSERT INTO foo (col_1) VALUES ('bar');"
  </code><br>
  I want to be able to craft an insert statement like:<br>
  <code>
      $sql = "INSERT INTO log (statements) VALUES (INSERT INTO foo (col_1) VALUES ('bar')'
  </code></p>
  
  <p>Is this possible with a trigger? I know I can do this easily with php, but I figured that a trigger would have less overhead.</p>