mysql创建course表_关于mysql创建表的问题

createtableCourse(courseIdchar(5),subjectIdchar(4)notnull,courseNumberinteger,titlevarchar(50)notnull,numOfCreditsinteger,primarykey(courseId));--------------------------...

create table Course (

courseId char(5),

subjectId char(4) not null,

courseNumber integer,

title varchar(50) not null,

numOfCredits integer,

primary key (courseId)

);

----------------------------------------------

create table Student (

ssn char(9),

firstName varchar(25),

mi char(1),

lastName varchar(25),

phone char(11),

birthDate date,

street varchar(25),

zipCode char(5),

deptID char(4),

primary key(ssn)

);

-------------------------------------------------

create table Enrollment (

ssn char(9),

courseId char(5),

dateRegistered date,

grade char(1),

primary key (ssn,courseId),

foreign key (ssn) references Student,

foreign key (courseId) references Course

);

创建Enrollment的时候出错：Error 1005 (HY000)：Can't create table 'test.enrollment' (errno:150)

求指教……

展开