为什么我在用mysql创建数据表时永远报错

CREATE TABLE user(
-> pin CHAR(32) NOT NULL,
-> id INT NOT NULL,
-> name VARCHAR NOT NULL,
-> caralod VARCHAR NOT NULL,
-> PRIMARY KEY ( pin )
-> );
报错ERROR 1064 (42000): 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 'NOT NULL,
caralod VARCHAR NOT NULL,
PRIMARY KEY ( pin )
)' at line 4

VARCHAR类型要指定长度,如VARCHAR(20)

试试下面这种

CREATE TABLE user(
-> pin CHAR(32) NOT NULL,
-> id INT NOT NULL,
-> name VARCHAR(20) NOT NULL,
-> caralod VARCHAR(20) NOT NULL,
-> PRIMARY KEY (pin)
-> );

CREATE TABLE user(
pin CHAR(32) NOT NULL,
id INT NOT NULL,
name VARCHAR(10) NOT NULL,
caralod VARCHAR(10) NOT NULL,
PRIMARY KEY (pin )
);