创建表失败，求解

[rogerliu0303]

CREATE TABLE ads_geo_info
(
status tinyint not null,
pinyin varchar not null,
pgid int not null,
name varchar(100) not null,
gid int not null auto_increment,
addtime datetime not null,
primary key (gid)
)

哪里有问题啊，创建失败，说有语法错误。新手，请各位指教

[rucypli]

CREATE TABLE ads_geo_info
(
status tinyint not null,
pinyin varchar(10) not null,
pgid int not null,
name varchar(100) not null,
gid int not null auto_increment,
addtime datetime not null,
primary key (gid)
)




pinyin varchar(10) not null,

[afeiqiang]

pinyin varchar not null,
varchar 后面应该标明长度 varchar(n)

[ACMAIN_CHM]

#1楼 正解。 VARCHAR（M）加标明长度。