use gradem;
create table student
(sno char(10) primary key,
sname varchar(8),
ssex char(2) default '男',
sbirthday date default '2002-01-01',
sid varchar(18),
saddress varchar(30),
spostcode char(6),
sphone char(18) default '不详',
spstatus varchar(20),
sfloor char(10),
sroom char(5),
sbedno char(2),
tuixue tinyint(1) not null default 0,
xiuxue tinyint(1) not null default 0,
smemo text,
classno char(8)
);
sroom char(5),
sbedno char(2),
tuixue tinyint(1) not null default 0,
xiuxue tinyint(1) not null default 0,
smemo text,
classno char(8)
)
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 ',
sbirthday date default '2002-01-01',
sid varchar(18),
saddress varchar(30' at line 4
时间: 0s
ssex char(2) default '男', 男后面的符号错了