Add New Rows with Values

Use the insert statement to add rows and values for columns in the row.

This insert statement adds a new row to the publishers table, giving a value for every column in the row.

insert into publishers 
values ("1622", "Jardin, Inc.", "Camden", "NJ")

The data values are typed in the same order as the column names in the original create table statement, that is, first the ID number, then the name, then the city, and, finally, the state. The values data is surrounded by parentheses, and all character data is enclosed in single or double quotes.

Use a separate insert statement for each row you add.