title: SQLITE: Replace without auto_increment
body: <p>I have a sqlite table: 
  for example </p>
  
  <pre><code>CREATE TABLE TEST (id integer primary key, number integer unique, name text); 
  </code></pre>
  
  <p>However, i need to make REPLACE without autoincrementing the id field when it updates.</p>
  
  <p>For example : THE TABLE IS EMPTY</p>
  
  <pre><code>REPLACE INTO TEST (null, 23, 'Bill');
  REPLACE INTO TEST (null, 52, 'Jack');
  </code></pre>
  
  <p>When I execute the query, <code>SELECT * FROM TEST;</code> I get...</p>
  
  <pre><code>1|23|Bill
  2|52|Jack
  </code></pre>
  
  <p>if I do...</p>
  
  <pre><code>REPLACE INTO TEST VALUES (null, 52, 'John');
  </code></pre>
  
  <p>from the query <code>SELECT * FROM TEST;</code>  i get..</p>
  
  <pre><code>1|23|Bill
  3|52|John
  </code></pre>
  
  <p>but i need...</p>
  
  <pre><code>1|23|Bill
  2|52|John
  </code></pre>
  
  <p>Does anyone have an idea on how do do this ?</p>