INSERT

INSERT INTO adds a row. Name the columns, then give the values in the same order.

Examplesql

Insert several rows at once by separating the value lists with commas.

Examplesql

Remember: the practice database is rebuilt on every Run, so your inserts disappear next time. A real database keeps them.

Quick check

Which statement adds a new row?

INSERT INTOADD ROWUPDATE TABLE

Your turn: write the code

Insert a product with id 7, name 'Stapler', price 6.5 and category 'Stationery', then select the name of the product with id 7.

Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.

Tip: use the left and right arrow keys to move between lessons.