title: SQLite: difference between 'INSERT OR REPLACE' and only 'REPLACE'
body: <p>I've found many discussions about <code>INSERT OR REPLACE</code> and I thought it was clear to me, but after reading <a href="http://www.sqlitetutorial.net/sqlite-replace-statement/" rel="nofollow noreferrer">this article</a> saying:</p>
  
  <blockquote>
    <p>The following illustrates the syntax of the REPLACE statement.</p>
  
  <pre><code>INSERT OR REPLACE INTO table(column_list)
  VALUES(value_list);
  </code></pre>
    
    <p>Or in a
    shorter form:</p>
  
  <pre><code>REPLACE INTO table(column_list)
  VALUES(value_list);
  </code></pre>
  </blockquote>
  
  <p>I'm afraid I missed something.</p>
  
  <p>Why is the <code>INSERT</code> statement needed together with <code>REPLACE</code>?
  Does it actually make any difference in examples like <a href="https://stackoverflow.com/a/4330694/5802289">this one</a>, for instance?</p>