基本问题

-- Creating a table named "students" and adding 3 columns
-- Setting the PRIMARY KEY to the student_id column
CREATE TABLE students (
    student_id INT PRIMARY KEY, 
    name VARCHAR (20),
    major VARCHAR (20)
);

SELECT * FROM students;

-- Inserting data into the table 
INSERT INTO students VALUES (3, 'Matt', 'Biology');

-- Inserting data into the table by specifying what column we are filling
INSERT INTO students(student_id, name) VALUES (4, 'Bob');