On Apr 16, 2012, at 10:51 PM, Puneet Kishor wrote: > how do I get the effect of `id INTEGER AUTOINCREMENT`. Guess I can't, not in > sqlite3, because AUTOINCREMENT only works with the PK invocation. So, I have > to use some other manual mechanism.
Right, no cigar in SQLite. You will need to roll your own mechanism to get the equivalent of a sequence. Which could be as simple as "select coalesce( max( id ), 0 ) + 1 from foo". _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
