Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Inserting and updating NULLs
4. Review: Inserting partial data
Conditions in UPDATE and DELETE
Updating the list of columns in one query
Using values from another column
Return rows in INSERT, UPDATE, DELETE
Summary

Instruction

Okay, let's get started! Previously in this course, we talked about how you can insert data into a table by providing values for only some of the columns.

For example, suppose the teacher would like to insert the date (November 10, 2018) of a written history exam for the student Tom Muller, id = 11, and the score of his oral history exam. This is not all the data that could be inserted into the table (we could insert the date of the oral exam, for example). Let's see how to write this query:

INSERT INTO exam (id, student_id, subject, written_exam_date, oral_exam_score)VALUES
(16, 11, 'History', '2018-11-10', 20); 

After the table name (exam), only some of the column names (id, student_id, subject, written_exam_date, oral_exam_score) are listed. Likewise, only the values for those columns are given.

Recall that the database inserts NULLs into each column you omit in an INSERT statement. If you have several columns with NULLs, it is convenient to omit them.

Warning: Sometimes the database will not allow you to add incomplete data. This topic is beyond the scope of this course – you can learn about it in our Creating Tables in SQL course.

Exercise

Add a new student with id = 11 to the student table. The teacher knows only his last name: Barry.
Don't use NULL when inserting this data.