MySQL Forums
Forum List  »  MySQL Workbench

MySQL Workbench Synchronize error 1064 (COMMENT'')
Posted by: No Name
Date: September 23, 2015 03:05PM


I have some problems while synchronize between my model and my database.

The "COMMENT" keyword seems generate an error. I don't find any help about this keyword in the MySQL online manual.
PLease see an example of the error message I could see below :

Executing SQL script in server
ERROR: Error 1064: 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 5
SQL Code:
ALTER TABLE `electronic_components`.`manufacturer`
CHANGE COLUMN `idmanufacturer` `idmanufacturer` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key' ,
ADD COLUMN `name` VARCHAR(45) NULL DEFAULT NULL COMMENT 'manufacturer name' AFTER `idmanufacturer`,
ADD COLUMN `website` VARCHAR(45) NULL DEFAULT NULL COMMENT 'manufacturer website' AFTER `name`,

SQL script execution finished: statements: 3 succeeded, 1 failed

Fetching back view definitions in final form.
Nothing to fetch

Is anyone could have an idea about this problem ?


Guillaume J.

Options: ReplyQuote

Written By
MySQL Workbench Synchronize error 1064 (COMMENT'')
September 23, 2015 03:05PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.