Thanks Benny.

 

Best regard

 

FERLAY Mathieu

 

 

De : Wang, Ai-Min (Benny) [mailto:[email protected]] 
Envoyé : jeudi 16 mars 2017 08:42
À : [email protected]
Objet : RE: issue with a request

 

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] <mailto:[email protected]> 

 

From: mathieu ferlay [mailto:[email protected]] 
Sent: Thursday, March 16, 2017 3:39 PM
To: [email protected] 
<mailto:[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