Learn SQL
Inserting data in tables
51.3
Lesson

Inserting NULL records

Let’s say we want to add information about a student, for which the age information is not available. Look at the following query.

If we don’t have information about value for a column, when inserting a new record, we can simply add a NULL record in its place.