mysql建表时报errno150错误。

答案:2 悬赏:0 手机版

解决时间 2021-01-26 10:54

提问者网友：战皆罪
2021-01-26 04:44

create database mydb;
use mydb;
create table teacher (
teacher_id int not null,
teacher_password varchar(128),
teacher_name varchar(50),
primary key (teacher_id)
);

create table student (
student_id int(10) ,
student_password varchar(50),
primary key (student_id)
);
create table testpaper (
tp_id int not null,
tp_name varchar(50),
schoiceValue int,
mchoiceValue int,
torfValue int ,
studentScore float,
fk_teacher int,
primary key (tp_id),
foreign key (fk_teacher) references test(teacher_id)
);

建立testpaper表时报errno150错误。

最佳答案

五星知识达人网友：雪起风沙痕
2021-01-26 05:45

foreign key (fk_teacher) references test(teacher_id)

改成
foreign key (fk_teacher) references teacher(teacher_id)

全部回答

1楼网友：duile
2021-01-26 06:25

第三个表的建表语句不规范.我改了一下并测试可以了. create table `enroll` ( `ssn` char(9) not null, `courseid` char(5) not null, primary key (`ssn`,`courseid`), foreign key (`ssn`) references `student` (`ssn`), foreign key (`courseid`) references `course` (`courseid`) )

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息