Hi:
Pleaes use following sql, UUID is reserved word and please use “” to enclose
it:
CREATE TABLE IF NOT EXISTS Token (
"UUID" VARCHAR(36) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL,
Expiration DATE NOT NULL,
SOPInstanceUUID VARCHAR(64) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL,
PRIMARY KEY ("UUID")
);
Best Regrard!
Benny/Wang Aimin
MP:13501196050
Mail:[email protected]
From: mathieu ferlay [mailto:[email protected]]
Sent: Thursday, March 16, 2017 3:39 PM
To: [email protected]
Subject: issue with a request
Hi everybody, i try to load these following lines:
CREATE TABLE IF NOT EXISTS Token (
UUID VARCHAR(36) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL,
Expiration DATE NOT NULL,
SOPInstanceUUID VARCHAR(64) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL,
PRIMARY KEY (UUID)
);
But I obtain systematically a mistake on UUID. Do you know how to success it
with this column’s name?
Thanks,
Regards
FERLAY Mathieu