title: SQLite - Update with random unique value
body: <p>I am trying to populate everyrow in a column with random ranging from 0 to row count.
  So far I have this</p>
  
  <pre><code>UPDATE table
  SET column = ABS (RANDOM() % (SELECT COUNT(id) FROM table))
  </code></pre>
  
  <p>This does the job but produces duplicate values, which turned out to be bad. I added a Unique constraint but that just causes it to crash.</p>
  
  <p>Is there a way to update a column with random unique values from certain range?</p>
  
  <p>Thanks!</p>