mysql - 在MySQL Workbench中创建表

Question

我的问题是我正在尝试使用MySQL Workbench创建一个简单的表，但是当我执行生成的脚本时，它会引发以下错误：

Operation failed: There was an error while applying the SQL script to the database.
Executing:
CREATE TABLE `new_schema`.`new_table` (
  `idnew_table` INT NOT NULL AUTO_INCREMENT COMMENT '',
  PRIMARY KEY (`idnew_table`)  COMMENT '');

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 3
SQL Statement:
CREATE TABLE `new_schema`.`new_table` (
  `idnew_table` INT NOT NULL AUTO_INCREMENT COMMENT '',
  PRIMARY KEY (`idnew_table`)  COMMENT '')

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 3
SQL Statement:
CREATE TABLE `new_schema`.`new_table` (
  `idnew_table` INT NOT NULL AUTO_INCREMENT COMMENT '',
  PRIMARY KEY (`idnew_table`)  COMMENT '')

Answer 1

您的CREATE TABLE语法错误。如果您实际上并未添加评论，则无需添加评论。

CREATE TABLE `new_schema`.`new_table` (
  `idnew_table` INT NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT ''
)