Access Migration SQL error 1064
Hi,
I'm very new to MySQL and want to make a MySQL backend database and run MS Access in the front end. I'm migrating my current MS Access database (which I did not design) to MySQL.
I get this error (or something like it) on most of my tables:
ERROR: Error executing 'CREATE TABLE IF NOT EXISTS `InvertData_TESTCopy3_be`.`tblPCRsamples` (
`VialID` VARCHAR(50) NULL COMMENT '',
`PCRPlate` VARCHAR(50) NOT NULL COMMENT '',
`PCRWell` VARCHAR(50) NOT NULL COMMENT '',
`PCRresult` VARCHAR(255) NULL COMMENT '',
`fivecycleredo` VARCHAR(10) NULL COMMENT '',
`FinalResult` VARCHAR(50) NULL COMMENT '',
PRIMARY KEY (`PCRPlate`, `PCRWell`) COMMENT '',
CONSTRAINT `{94D83037-86D5-49E4-B0FD-34AE34CEDE1A}`
FOREIGN KEY (`PCRWell`)
REFERENCES `InvertData_TESTCopy3_be`.`tblListWells` (`Well`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
CONSTRAINT `{E3A31516-8923-4698-A429-3F244CA968DF}`
FOREIGN KEY (`FinalResult`)
REFERENCES `InvertData_TESTCopy3_be`.`tblListPCRResults` (`FinalResult`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
CONSTRAINT `{80503C8F-1844-4E52-BC34-935DF141BFBB}`
FOREIGN KEY (`VialID`)
REFERENCES `InvertData_TESTCopy3_be`.`tblMaster` (`VialID`)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `{2D98A0ED-3A04-413D-976D-3787C91A9FCF}`
FOREIGN KEY (`PCRPlate`)
REFERENCES `InvertData_TESTCopy3_be`.`tblPCRplates` (`PCRPlate`)
ON DELETE CASCADE
ON UPDATE CASCADE)'
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COMMENT '',
CONSTRAINT `{94D83037-86D5-49E4-B0FD-34AE34CEDE1A}`
FOREIGN KE' at line 8.
SQL Error: 1064
It must be straightforward, but I don't know what's wrong with the syntax.
Thanks in advance.