Create a table for MySQL database

Create Database: Create Database TD Character Set = utf8; Use Database TD; // create a table in database 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; // specify the storage engine and Character Set 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
Foreign key (subject_id) References tb_subject (subject_id)
) Engine = InnoDB default Character Set = utf8;