On Mon, Mar 10, 2008 at 11:35:23PM +0530, B V, Phanisekhar scratched on the 
wall:
> All,
> 
>      I wanted to know the algorithm used by sqlite to generate the new
> rowid. Assume there can be N distinct rowid's possible, now insert N
> records, followed by random deletion of some records. Now what rowid
> will be assigned to a new row that is added?

  Depends on how the table is setup.  For more information:

  http://www.sqlite.org/autoinc.html



   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"'People who live in bamboo houses should not throw pandas.' Jesus said that."
   - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006"
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to