title: Changing Auto Increment of a colum in SQLite
body: <p>I am creating a table that at first keyID column is NOT in AUTO INCREMENT since i am going to insert a data that came from an old database where the keyID is already been set to each rows and it's not possible to be changed. So is it possible that i can set the column to AUTO INCREMENT after all the data has been moved? I've seen this:</p>
  
  <pre><code>ALTER TABLE tbl_name MODIFY COLUMN keyID_id INT auto_increment
  </code></pre>
  
  <p>So if ever i set the keyID to auto increment after i moved all the data, so for example 10 rows has been transferred and some numbers may be missing for example, keyIDs: 1,2,3,5,6,7...15</p>
  
  <p>can I assume that after i set the keyID to auto increment, the next row will be keyID 16? </p>