i have a file could you look at it and explain it to me please thank you On Thu, Jul 20, 2017 at 8:47 AM, Don V Nielsen <donvniel...@gmail.com> wrote:
> On the heel of this is a grammatical error: "declared type "INTEGER" > includes an "PRIMARY KEY DESC" clause". It should read "includes a > "primary...". > > On Wed, Jul 19, 2017 at 11:03 PM, Keith Medcalf <kmedc...@dessus.com> > wrote: > > > > > AUTOINCREMENT can only be used with INTEGER PRIMAY KEY columns in a rowid > > table definition to declare an alias for the rowid. Such columns must > not > > have the DESC ordering (the rowid is ascending). If it does, then > "PRIMARY > > KEY" is syntactic sugar for "UNIQUE" (ie, creating a unique index) and > the > > AUTOINCREMENT keyword cannot be applied. > > > > -----Original Message----- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > > On Behalf Of sanhua.zh > > Sent: Wednesday, 19 July, 2017 20:07 > > To: sqlite-users > > Subject: [sqlite] A Descending Auto Increment Key > > > > When I call `CREATE TABLE test(i INTEGER PRIMARY KEY DESC AUTO > > INCREMENT)`, SQLite comes to an error "AUTOINCREMENT is only allowed on > an > > INTEGER PRIMARY KEY". > > > > > > But as the document http://www.sqlite.org/lang_createtable.htmlsays, in > > the column-constraint, it shows that `PRIMARY DESC AUTOINCREMENT` is a > > valid syntax. > > > > > > Why the original SQL failed? Is that really not supported? > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users