On Thu, 23 Nov 2017 17:35:08 -0700 "Keith Medcalf" <kmedc...@dessus.com> escribió:
> > That is correct. You cannot spell "INTEGER PRIMARY KEY", which is an > explicit alias for the rowid, as anything other than that one particular > correct spelling. > > Personally, I have never found a use for the AUTOINCREMENT option. Why is > it being used? If you declare a INTEGER PRIMARY KEY alone, sqlite could reuse rowid number from deleted rows. Using AUTOINCREMENT forces sqlite to use a rowid bigger than the last one inserted/updated(1), so you can use it to know if one row is older or newer than others, without autoincrement no. You can do similar behavior with a trigger, for example for TEXT columns or automatically with DATE current time. (1) You can change the integer primary key to whatever value you want. > The fact that there's a Highway to Hell but only a Stairway to Heaven says a > lot about anticipated traffic volume. .... See you there then? ;) -- Eduardo <eduardo.mor...@mobelservices.com> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
