求问mysql建立表格时报错的问题，检查不出来错哪里了

Question

这个：

mysql> CREATE TABLE Review21

-> (name varchar,

-> review varchar,

-> useful_num int,

-> funny_num int,

-> cool_num int,

-> time_review time,

-> pic int);

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 ',

review varchar,

useful_num int,

funny_num int,

cool_num int,

time_review time,' at line 2

拜托各位大佬指点一下！感谢！

Answer 1

CREATE TABLE Review21
(name varchar(10),
review varchar(10),
useful_num int,
funny_num int,
cool_num int,
time_review time,
piccc int);

varchar必须指定长度