有人能找到這個MySQL程式碼中的錯誤嗎?(初學者)

Question

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'

Answer 1

Varchar需要一個長度:

CREATE TABLE `students`.`studentinfo` (
id int,
name varchar(100),
age int
)