You learn quickly, great!
Sometimes you don't know all the data when you insert information into a database. SQL allows you to insert data with values for some columns and omit data for other columns at the same time.
To insert Chris of unknown age as a user with an ID of 6, use the command:
INSERT INTO user (id, name)
VALUES (6, 'Chris');
The new part after the table user,
(id, name), is the list of column names you will give values to. The expression
(6, 'Chris'), in turn, is the list of values for these columns. The number
6 is the value of the first specified column,
id. The text
'Chris' is the value of the second specified column,
name. The value for unknown in SQL is
NULL. A database inserts
NULL values for each column you omit in an
Warning: Sometimes, the database will not allow you to add incomplete data. This topic is beyond the scope of this course; we talk about it in the Creating Tables in SQL course.