title: Stopping a delete on MySQL via Triggers
body: <p>I'm trying to intercept any DELETE commands against a particular table.  MySQL supports triggers but it doesn't seem to support a way to raise an error yet like SQL Server and other databases.</p>
  
  <p>Can I do this with just an empty Trigger definition?  Something like:</p>
  
  <pre><code>create trigger trListsDelete on lists
  instead of delete
  as
  begin
    /* Do nothing */
  end
  </code></pre>
  
  <p>In SQL Server I could add a <code>RAISEERROR('You cannot delete lists.')</code> statement to force it to fail and that way I know the Delete wouldn't be executed.  Since MySQL doesn't support raising errors, how do I simply ignore the Delete command?  </p>