title: INSERT IF NOT EXISTS ELSE UPDATE?
body: <p>I've found a few "would be" solutions for the classic "How do I insert a new record or update one if it already exists" but I cannot get any of them to work in SQLite.</p>
  
  <p>I have a table defined as follows:</p>
  
  <pre><code>CREATE TABLE Book 
  ID     INTEGER PRIMARY KEY AUTOINCREMENT,
  Name   VARCHAR(60) UNIQUE,
  TypeID INTEGER,
  Level  INTEGER,
  Seen   INTEGER
  </code></pre>
  
  <p>What I want to do is add a record with a unique Name. If the Name already exists, I want to modify the fields. </p>
  
  <p>Can somebody tell me how to do this please?</p>