create table student(
number char(5) not null unique,
stuName char(8) not null,
age smallint default 20,
sex char(2),
department char(20) default c1 20 for age,
constraint c2 check(sex in ('male','female'))
);
服务器: 消息 170,级别 15,状态 1,行 8
第 8 行: '20' 附近有语法错误-----在网上搜了半天,一直没有什么头绪,各位能不能指点一下,像出现这类问题,我们如何去解决?
number char(5) not null unique,
stuName char(8) not null,
age smallint default 20,
sex char(2),
department char(20) default c1 20 for age,
constraint c2 check(sex in ('male','female'))
);
服务器: 消息 170,级别 15,状态 1,行 8
第 8 行: '20' 附近有语法错误-----在网上搜了半天,一直没有什么头绪,各位能不能指点一下,像出现这类问题,我们如何去解决?
number char(5) not null unique,
stuName char(8) not null,
age smallint default 20,
sex char(2),
department char(20),constraint c2 check(sex in ('male','female'))
);
number char(5) not null unique,
stuName char(8) not null,
age smallint default 20,
sex char(2), department char(20),
default c1 20 for age, 这句你想作什么?constraint c2 check(sex in ('male','female'))
);
number char(5) not null unique,
stuName char(8) not null,
age smallint,
sex char(2),
department char(20)
default c1 20 for age,
constraint c2 check(sex in ('male','female'))
);
上面我不加,它同样也会报错
number char(5) not null unique,
stuName char(8) not null,
age smallint default 20,
sex char(2),
department char(20),
constraint c2 check(sex in ('male','female'))
);
number char(5) not null unique,
stuName char(8) not null,
age smallint constraint c1 default 20 ,--在這里定義"c1"
sex char(2),
department char(20)
constraint c2 check(sex in ('male','female'))
);