03-02 INSERT no Value

01

We can specify what columns we want values inserted into.

Any column not specified will be NULL

INSERT INTO student(student_id,name) VALUES(3,'Claire');

Here we only specifiy student_id and name so major is NULL