Inserting Data into All Columns

This INSERT statement adds a new row to the titles table of the pubs database, giving a value for each column in the row:

INSERT titles
    VALUES ('BU2222', 'Faster!', 'business', '1389',
        NULL, NULL, NULL, NULL, 'ok', '06/14/95')

Notice that the data values are in the same order as the column names in the original CREATE TABLE statement (that is, first the ID number, then the name, the city, and finally the state). The VALUES data is surrounded by parentheses and all character data is enclosed in single quotation marks. Use a separate INSERT statement for each row that you add.