mysql建表时报errno150错误。

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错误。

foreign key (fk_teacher) references test(teacher_id)

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

第三个表的建表语句不规范.我改了一下并测试可以了. 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`) )