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

Reply via email to