Migrating from MSSQL to MYSQL error 1064 MYSQL Workbench

Question

I am currently preparing a migration from MSSQL to MYSQL using MYSQL workbench.

The error I am receiving is as follows.

ERROR: Error executing 'CREATE TABLE IF NOT EXISTS `dbo`.`VendorGTG` (
  `VID` INT NOT NULL COMMENT '',
  `Attending` TINYINT(1) NULL DEFAULT 0 COMMENT '',
  `Name1` VARCHAR(50) NULL COMMENT '',
  `Name2` VARCHAR(50) NULL COMMENT '',
  `Inserted` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP COMMENT '',
  `NameTag` TINYINT(1) NULL DEFAULT 0 COMMENT '',
  PRIMARY KEY (`VID`)  COMMENT '')'
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 '')' at line 8.
SQL Error: 1064

@TTeeple Please read questions carefully before suggesting edits like that. This question DOES relate to SQL Server. — DavidG
– DavidG, Commented Aug 5, 2015 at 12:15
@DavidG I would argue that. OP is migrating from SQL Server but the error in question is MySQL related. — TTeeple
– TTeeple, Commented Aug 5, 2015 at 12:25
@TTeeple And yet the code posted is SQL Server syntax. Either way, it doesn't warrant an edit suggestion to remove the tag. — DavidG
– DavidG, Commented Aug 5, 2015 at 12:27
@DavidG COMMENT, TINYINT(1), encasing all the columns in quotes, that all screams MySQL syntax to me. — TTeeple
– TTeeple, Commented Aug 5, 2015 at 12:31
@TTeeple Because it's only partially converted from SQL Server syntax. Check my answer. — DavidG
– DavidG, Commented Aug 5, 2015 at 12:33

DavidG · Accepted Answer · 2015-08-05 12:12:30Z

1

MySQL doesn't have schemas like SQL Server, so remove that from your code:

CREATE TABLE IF NOT EXISTS VendorGTG (
  `VID` INT NOT NULL COMMENT '',
  `Attending` TINYINT(1) NULL DEFAULT 0 COMMENT '',
  `Name1` VARCHAR(50) NULL COMMENT '',
  `Name2` VARCHAR(50) NULL COMMENT '',
  `Inserted` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP COMMENT '',
  `NameTag` TINYINT(1) NULL DEFAULT 0 COMMENT '',
  PRIMARY KEY (`VID`)  COMMENT '')

answered Aug 5, 2015 at 12:12

DavidG

120k13 gold badges232 silver badges239 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Miłosz Bodzek · Accepted Answer · 2015-08-20 20:06:11Z

0

Problem is with COMMENT '' - just remove all occurence of that. Feel free to leave a comment under this bug http://bugs.mysql.com/bug.php?id=77910 We're working on it to fix it.

answered Aug 20, 2015 at 20:06

Miłosz Bodzek

1,3697 silver badges13 bronze badges

Collectives™ on Stack Overflow

Migrating from MSSQL to MYSQL error 1064 MYSQL Workbench

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related