create table Course(
Cno char(4) primary key,
Cname char(40),
Pre_Cno char(4),
-- 成绩
Credit smallint,
-- Pre_cno 参考Cno
foreign key(Pre_Cno) references Course(Cno)
)
character set =utf8
insert into Course values ('C01','英语','','4');
insert into Course values('C02','数据结构','C05','2');
insert into Course values('C03','数据库','C02','2');
insert into Course values('C04','DB_设计','C03','3');
insert into Course values('C05','C++','','3');
insert into Course values('C06','网络原理','C07','3');
insert into Course values('C07','操作系统','C05','3');
错误:
1452 - Cannot add or update a child row: a foreign key constraint fails (`s_t`.`course`, CONSTRAINT `course_ibfk_1` FOREIGN KEY (`Pre_Cno`) REFERENCES `course` (`Cno`))
解决办法:
外键错误
你先把所有外键删除了
加入数据后再建立