由于C#的作业,又要折腾一下mysql,在写外键的时候出现了一些小小的问题,记录一下:
1.没有问题的 sql 语句
create database student_grades_db ;
use student_grades_db;
create table student (
id int primary key,
name varchar(45) not null,
gender varchar(10) not null
);
create table course (
id int primary key auto_increment,
name varchar(45) unique not null
) auto_increment=100;
2.出问题的地方:
create table grade (
stu_id int,
course_id int,
grade int not null,
primary key (stu_id, course_id),
constraint 'stu_id_fk' foreign key ('stu_id') references 'student' ('id'),
constraint 'course_id_fk' foreign key ('course_id') references 'course' ('id')
);
然后在这句上面
constraint 'stu_id_fk' foreign key ('stu_id') references 'student' ('id'),
一直报错
修改:把引号除去,就没有问题了
constraint stu_id_fk foreign key (stu_id) references student (id),
constraint course_id_fk foreign key (course_id) references course (id)