title: How do I force an INSERT into a table with a unique key if it's already in the table?
body: <p>I have a table:</p>
  
  <pre><code>CREATE TABLE Students (studentId TEXT PRIMARY KEY, name TEXT);
  </code></pre>
  
  <p>I want to insert records into the table, if I insert a student twice I want 
  the second insert to override(update) the first record.</p>
  
  <pre><code>INSERT INTO Students (StudentId, name) VALUES ('123', 'Jones');
  INSERT INTO Students (StudentId, name) VALUES ('123', 'Jonas');
  </code></pre>
  
  <p>What's the best way of doing this?</p>