本文共 869 字,大约阅读时间需要 2 分钟。
创建students表关联country,position,gender三张表
create table country( cid int primary key auto_increment, cname varchar(10) NOT NULL)ENGINE=INNODB DEFAULT CHARSET=utf8; create table `position`( pid int primary key auto_increment, pname varchar(10) NOT NULL)ENGINE=INNODB DEFAULT CHARSET=utf8;create table Gender( gid int primary key auto_increment, gname varchar(10) NOT NULL)ENGINE=INNODB DEFAULT CHARSET=utf8;create table students( sid int primary key auto_increment, sname varchar(100) not null, countryId int, positionId int, GenderId int, Capability int, constraint fk_stu_cid foreign key(countryId) references country(cid), constraint fk_stu_pid foreign key(positionId) references `position`(pid), constraint fk_stu_gid foreign key(GenderId) references Gender(gid) )ENGINE=INNODB DEFAULT CHARSET=utf8; insert into students(sname,countryId,positionId,GenderId,Capability
转载地址:http://wvwci.baihongyu.com/