title: Trigger after select
body: <p>I have a sqlite3-database. There's a table with some logs.
  These logs are readed by a tool and were writed to a text-file (or something else) by it.</p>
  
  <p>After this, the logs can be deleted. Is it possible to create a trigger in sqlite3 after a select, which automaticly deletes the logs?</p>
  
  <p>Like this:</p>
  
  <pre><code>CREATE TRIGGER after_select_x
  AFTER SELECT ON x
  BEGIN
    DELETE FROM x WHERE id = selected.id;
  END;
  </code></pre>
  
  <p>But this doesn't work.</p>
  
  <p>Thanks</p>
  
  <p>Best regards</p>