Re: [sqlite] A Descending Auto Increment Key
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 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 > 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
Re: [sqlite] A Descending Auto Increment Key
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 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
Re: [sqlite] A Descending Auto Increment Key
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] 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