在SQLyog中写了一段建表语句
create table reader(
newsid int primary key,
readerid int,
readerName varchar(50),
hits int,
firstreadtime date,
lastreadtime date,
cjmc varchar(20),
cjdh varchar(20),
)
执行时出现下面的错误:Error Code : 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 ')' at line 10
(0 ms taken)
怎么回事?
create table reader(
newsid int primary key,
readerid int,
readerName varchar(50),
hits int,
firstreadtime date,
lastreadtime date,
cjmc varchar(20),
cjdh varchar(20),
)
执行时出现下面的错误:Error Code : 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 ')' at line 10
(0 ms taken)
怎么回事?
)
多了个,号
newsid int primary key,
readerid int,
readerName varchar(50),
hits int,
firstreadtime date,
lastreadtime date,
cjmc varchar(20),
cjdh varchar(20));