sql - MySQL Workbench missing closing parenthesis -


this code generated in workbench after creating model synchronizing server. after trying synchronize model, workbench say: operation has completed errors. put code "query window" workbench , see highlighted syntax error on line primary key (idgroup) comment ''. why code incorrect? thanks!

set @old_unique_checks=@@unique_checks, unique_checks=0; set @old_foreign_key_checks=@@foreign_key_checks, foreign_key_checks=0; set @old_sql_mode=@@sql_mode, sql_mode='traditional,allow_invalid_dates';  create table if not exists `everest_journal_db`.`groups` (   `idgroup` int(11) not null auto_increment comment '',   `titlegroup` varchar(45) not null comment '',   primary key (`idgroup`)  comment ''   ) engine = innodb default character set = utf8 collate = utf8_general_ci;  drop table if exists `everest_journal_db`.`table_from_workbench` ;  drop table if exists `everest_journal_db`.`simple_table` ;   set sql_mode=@old_sql_mode; set foreign_key_checks=@old_foreign_key_checks; set unique_checks=@old_unique_checks; 

yes, know it, it's bug. temporary workaround remove occurence of comment ''. feel free leave comment under bug. we're working on fix it, stay tuned upcoming release.


Comments

Popular posts from this blog

java - WARN : org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/board/] in DispatcherServlet with name 'appServlet' -

html - Outlook 2010 Anchor (url/address/link) -

android - How to create dynamically Fragment pager adapter -