mysql第二主键怎么写命令_怎样写三个Mysql表一个主键两个外键的命令

DROPTABLEIFEXISTSstudent;createtablestudent(SIdintnotnullauto_incrementprimarykey,SPasswordintunsignednotnull)defaultcharset=gb2312;DROPTABLEIFEXISTSinformation;createtab...

DROP TABLE IF EXISTS student;

create table student

(

SId int not null auto_increment primary key,

SPassword int unsigned not null

) default charset=gb2312;

DROP TABLE IF EXISTS information;

create table information (

SId int unsigned not null auto_increment primary key,

Class varchar(20) not null,

Name varchar(20) not null ,

Sex varchar(3) not null,

Age int not null,

Phone varchar(40) not null,

Jiguan varchar(10) not null,

SusheId varchar(10) not null

) engine =innodb default charset=gb2312;

DROP TABLE IF EXISTS score;

create table score (

SId int unsigned not null,

English int not null,

Java int not null,

Sum int not null,

foreign key (SId) references information(SId) on delete cascade on update cascade

)engine=innodb default charset=gb2312;

这三个表之间的集联操作，两个外键一个主键，，，高分悬赏

展开