Create a student table with the student id, name, and marks as attributes where the student id is the primary key

 

In this post, we are going to Create a student table with the student id, name, and marks as attributes where the student id is the primary key in "MySQL". This project is given by CBSE in term II Practical File.

Here is the code:

create table student
(
student_id varchar(10) primary key not NOT NULL;
name varchar(30)
marks integer(5)
);