mysql 建資料庫 建表

建立資料庫：create database td character set =utf8；use database td；//在資料庫td中建立表

create table tb_student (
Student_ID int auto_increment primary key, 
Student_Name varchar(20), 
Sex char(1), 
Birthday varchar(10)
) engine=innodb default character set =utf8 auto_increment =100;//指定儲存引擎和字元集  create table tb_subject (
Subject_ID int auto_increment primary key, 
Subject_Name varchar(50)
) engine=innodb default character set =utf8;

create table tb_score (
ID int auto_increment primary key,
Student_ID int,
Subject_ID int,
Score decimal(10,2),
foreign key (Student_ID) references tb_student(Student_ID),//外鍵
foreign key (Subject_ID) references tb_subject(Subject_ID)
) engine=innodb default character set =utf8;