title: How to insert a column which is the current total row number in sqlite?
body: <p>For a talbe created using:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS Pics (X INTEGER NOT NULL, Y INTEGER NOT NULL, Z INTEGER NOT NULL, T INTEGER NOT NULL, Pic BLOB NULL,PRIMARY KEY(X, Y, Z, T))
  </code></pre>
  
  <p>How can I add one more column that is a <code>INTEGER</code> which notes down the current total row number in this table (it tells which row come first)?</p>
  
  <p>How should I write the insert command?</p>