sql语句创建外键关联的完整实例

use school;

create table student(

id int (10) not null primary key ,

name varchar (30) default null ,

tid int (10) default null ,

key `fktid` (`tid`),

constraint `fktid` foreign key (`tid`) references `teacher` (`id`)

)engine=innodb default charset=utf8

insert into student values (1, '小明' ,1);

insert into student values (2, '小红' ,1);

insert into student values (3, '小刚' ,1);

insert into student values (4, '小王' ,1);

insert into student values (5, '小智' ,1);

select * from student;

create table teacher (

id int (10) primary key not null ,

name varchar (30) default null

)engine=innodb default charset=utf8

insert into teacher values (1, '陈老师' );

select * from teacher;

key `fktid` (`tid`),

constraint `fktid` foreign key (`tid`) references `teacher` (`id`)