How do you write the code to create a student table in MySQL?

2 years ago
Liam
1 minute

In order to create a student table, you need to use the CREATE TABLE statement. Here is an example code for creating a student table named “students”:

CREATE TABLE students (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(50) NOT NULL,
  age INT,
  gender ENUM('男', '女'),
  major VARCHAR(50)
);

In the code above, we have defined the following columns:

  1. ID: Student ID, use INT data type, designate as primary key and auto increment using PRIMARY KEY and AUTO_INCREMENT properties.
  2. The student’s name is stored as a VARCHAR(50) data type and is specified as not null.
  3. age: the age of the student, stored as an integer.
  4. Gender: Student gender, using ENUM type, only allowed values are ‘male’ or ‘female’.
  5. Major: student’s field of study, stored as VARCHAR(50).

You can make appropriate adjustments and extensions based on your own needs. Please note that the above code is just an example, and may need to be changed according to specific requirements in actual applications.

bannerAds