On Wed, Aug 2, 2017 at 5:56 PM, Simon Slavin <[email protected]> wrote:
> > > On 2 Aug 2017, at 4:54pm, Peter Da Silva <[email protected]> > 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? > > Actually, I don’t understand how sequences are superior to normal use of > an AUTOINC column. Can someone explain ? > > Yes I can. I need to use special number that I specified the start and increment. for instance I have a entity with a lower number and upper number, I create then a sequence like CREATE SEQUENCE IF NOT EXISTS SEQ_RANGE START WITH 100 INCREMENT BY 100 ; then I create many entities like: insert into MYENTITY(LowerNumber,UpperNumber) select SEQ_RANGE.currval+1, SEQ_RANGE.nextval from MY_REF_TABLE ; _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
