On 22 Nov 2016, at 14:03, Richard Hipp wrote:
On 11/22/16, Igor Korot <ikoro...@gmail.com> wrote:
Hi, ALL,
SQLite version 3.13.0 2016-05-18 10:57:30
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> CREATE TABLE IF NOT EXISTS abc("abc_tnam" char(129) NOT NULL,
"abc_tid" integer, "abc_ownr" char(129) NOT NULL, "abc_cnam"
char(129) NOT
NULL
, "abc_cid" smallint, "abc_labl" char(254), "abc_lpos" smallint,
"abc_hdr"
char(
254), "abc_hpos" smallint, "abc_itfy" smallint, "abc_mask" char(31),
"abc_case"
smallint, "abc_hght" smallint, "abc_wdth" smallint, "abc_ptrn"
char(31),
"abc_bm
ap" char(1), "abc_init" char(254), "abc_cmnt" char(254), "abc_edit"
char(31), "a
bc_tag" char(254) PRIMARY KEY "abc_tnam", "abc_ownr", "abc_cnam");
Missing comma (,) in between "KEY" and "abc_tnam".
Or perhaps (if Igor's intent is to use three columns as a compound
primary
key) missing parens ['(' ... ')'] around the list of columns after
KEY ?
I was going to add "missing comma before PRIMARY" as well, but
https://www.sqlite.org/lang_createtable.html doesn't seem to indicate
that a comma is required between a column-def and a table-constraint.
Best regards,
Niall O'Reilly
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
