mysql workbench 1064_mysql - MySQL Workbench错误1064 - 堆栈内存溢出

大家！ 我是MySQL的新手。 我已经使用Workbench工具创建了一个新模型(我的意思是，我自己没有编写任何代码字符串)。 当尝试转发工程师时，我得到：

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 '')

ENGINE = InnoDB' at line 8

SQL Code:

-- -----------------------------------------------------

-- Table `university`.`CITY`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `university`.`CITY` (

`ID_CITY` INT NOT NULL COMMENT '',

`CNAME` TEXT(15) NULL COMMENT '',

`POPULATION` INT NULL COMMENT '',

PRIMARY KEY (`ID_CITY`) COMMENT '')

ENGINE = InnoDB

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

Fetching back view definitions in final form.

Nothing to fetch

此外，当尝试转发工程师默认的工作台模型“ sakila_full”时，我会得到相同的结果：

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 '',

INDEX `idx_actor_last_name` (`last_name` ASC) COMMENT '')

ENGINE ' at line 9

SQL Code:

-- -----------------------------------------------------

-- Table `sakila`.`actor`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `sakila`.`actor` (

`actor_id` SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '',

`first_name` VARCHAR(45) NOT NULL COMMENT '',

`last_name` VARCHAR(45) NOT NULL COMMENT '',

`last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '',

PRIMARY KEY (`actor_id`) COMMENT '',

INDEX `idx_actor_last_name` (`last_name` ASC) COMMENT '')

ENGINE = InnoDB

DEFAULT CHARACTER SET = utf8

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

Fetching back view definitions in final form.

Could not get definition for sakila.customer_list from server

Could not get definition for sakila.film_list from server

Could not get definition for sakila.nicer_but_slower_film_list from server

Could not get definition for sakila.staff_list from server

Could not get definition for sakila.sales_by_store from server

Could not get definition for sakila.sales_by_film_category from server

Could not get definition for sakila.actor_info from server

7 views were read back.

提前致谢！