create table zrk
(
pid varchar(5) NOT NULL,
pname varchar(5) PRIMARY KEY,
pgender varchar(2) DEFAULT '男',
page number(3),
pgroup varchar(10) DEFAULT '其他',
pnumber varchar(20) NOT NULL,
pemail varchar(50),
ppostalcode varchar(6),
padress varchar(50),
pphoto BLOB
);
在MySQL里执行,错误信息如下
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 'numbe
r(3),
pgroup varchar(10) DEFAULT '其他',
pnumber varchar(20) NOT NULL,
pema' at line 6
大家帮忙看看,谢谢了
万分感激
(
pid varchar(5) NOT NULL,
pname varchar(5) PRIMARY KEY,
pgender varchar(2) DEFAULT '男',
page number(3),
pgroup varchar(10) DEFAULT '其他',
pnumber varchar(20) NOT NULL,
pemail varchar(50),
ppostalcode varchar(6),
padress varchar(50),
pphoto BLOB
);
在MySQL里执行,错误信息如下
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 'numbe
r(3),
pgroup varchar(10) DEFAULT '其他',
pnumber varchar(20) NOT NULL,
pema' at line 6
大家帮忙看看,谢谢了
万分感激
Access里的数据类型是不是不一样呢
create table zrk
(
pid varchar(5) NOT NULL,
pname varchar(5) PRIMARY KEY,
pgender varchar(2) DEFAULT '男',
page decimal(3,2),
pgroup varchar(10) DEFAULT '其他',
pnumber varchar(20) NOT NULL,
pemail varchar(50),
ppostalcode varchar(6),
padress varchar(50),
pphoto BLOB
);