On Wed, Aug 2, 2017 at 5:54 PM, Peter Da Silva < peter.dasi...@flightaware.com> wrote:
> Can’t you do the same basic logic then use (SELECT value FROM > super_sequences WHERE id=’SEQ_1’) instead of SEQ_1.nextval? > > > insert into mytable (MY_NO, MY_INFO) > SELECT SEQ_1.nextval, a.INFO FROM myothertable a > ; > > no because nextval also increment the sequence, as opposed to the (SELECT value FROM super_sequences WHERE id=’SEQ_1’) where it only reads the value _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users