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

Question

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

Answer 1

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