title: Can you modify an existing mysql trigger after it has been created?
body: <p>In <code>mysql</code> I can create a trigger, and then show information about it like this:</p>
  
  <pre><code>mysql&gt; show triggers like 'fooTrigger';
  </code></pre>
  
  <p>This command gives output that looks an awful lot like a select statement, with a row showing the matching trigger.  Is it possible to update a column on the row it shows me?</p>
  
  <p>For example, one column is named <code>Statement</code>, and it defines what happens when the trigger is activated.  Is it possible to change the <code>Statement</code> field for <code>fooTrigger</code> so the trigger does something different?  Or do I need to <code>drop</code> and re-<code>create</code> the trigger?</p>