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
