创建教师表时出现:ora-02270:此列列表的唯一关键字或主键不匹配
teacher表要引入subject表的主键作为外键
--创建科目表
create table subject (
subid number(5),
subname varchar2(50)
);
--插入数据
insert into subject(subid,subname) values(101,'语文');
insert into subject(subid,subname) values(102,'数学');
insert into subject(subid,subname) values(103,'英语');
select * from subject;
--创建教师表
create table teacher(
tid number(5) primary key,
tname varchar2(50),
age number(5),
sex varchar2(5),
subid number(5) references subject(subid)
);
不知道哪里错了,怎么改
subject表要有主键,这个主键字段就是外键关联的字段,把subid设置为主键就可以了
subject 表 subid 设置为主键
create table subject (
subid number(5) primary key,
subname varchar2(50)
);