create table FRIENDS
(
FNO numeric(2,0) not null,
FQQ numeric(5,0),
FSNO numeric(2,0),
FDATE datetime,
FSTATUS numeric(2,0),
QQ numeric(5,0),
index FSNOIndex(FSNO),
primary key (FNO),
check (fstatus in (1,0))
);
create table SUBGROUP
(
SNO numeric(2,0) not null,
SNAME varchar(20),
SDATE datetime,
QQ numeric(5,0),
primary key (SNO)
);
alter table SUBGROUP add constraint FK_SNO foreign key (SNO)
references FRIENDS (FSNO) ON UPDATE CASCADE ON DELETE RESTRICT;
insert into friends values('1', '2', '0', '2017-01-11 00:00:00', '0', '1'
);
表SUBGROUP添加外键引用的是FRENDS的一个列,为什么FRIENDS插入值时,SUBGROUP为什么对应的列没有更新?