On 1 Nov 2016, at 11:44am, Andy Ling <andy.l...@s-a-m.com> wrote: > It remembers......
Ah, neat. Thanks for the testing. And the "show create table" command you used makes it clear that the engine keeps a record for the table. Apparently a single value for the table's primary key rather than a value for each "INTEGER PRIMARY KEY AUTOINCREMENT" column. I'd be interested in the equivalents for progresql and Oracle, if anyone is set up to find out. Maybe we could work up a table like the one in <https://www.sqlite.org/nulls.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users