CREATE TABLE `students`.`studentinfo` (
id int,
name varchar,
age int
);
ENGINE = InnoDB
COMMENT = 'test';

我正在使用MySQL工作台，我试图创建一个名为学生的表。然而，我的代码给出了错误信息

Operation failed: There was an error while applying the SQL script to the database.
Executing:
CREATE TABLE `students`.`studentinfo` (
id int,
name varchar,
age int
);
ENGINE = InnoDB
COMMENT = 'test';

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 ',
age int
)' at line 3
SQL Statement:
CREATE TABLE `students`.`studentinfo` (
id int,
name varchar,
age int
)

我试图通过移除表来解决这个问题，像这样:

CREATE TABLE `students`.`studentinfo` (
)
ENGINE = InnoDB
COMMENT = 'test';

即使这样，它仍然不起作用!它给出了相同的错误信息:

Operation failed: There was an error while applying the SQL script to the database.
Executing:
CREATE TABLE `students`.`studentinfo` (
)
ENGINE = InnoDB
COMMENT = 'test';



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 ')
ENGINE = InnoDB
COMMENT = 'test'' at line 2
SQL Statement:
CREATE TABLE `students`.`studentinfo` (
)
ENGINE = InnoDB
COMMENT = 'test'