annot 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 Incr
" (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
> Subjec
ating 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
4 matches
Mail list logo