Code Lab BetaBUILD. RUN. DISCOVER.
Code Lab is in development. New lessons and improvements are on the way. Progress can be deleted.
Loading…
Code Lab is in development. New lessons and improvements are on the way. Progress can be deleted.
Loading…
Code Lab is in development. New lessons and improvements are on the way. Progress can be deleted.
SQL / POSTGRESQL / Learn / LESSON 02
One INSERT can add several rows: VALUES (...), (...). Columns are shared across rows. This is shorter than separate INSERT statements.
Small example:
INSERT INTO items (id, name, category, qty, price) VALUES (91, 'A', 'home', 1, 1), (92, 'B', 'home', 2, 2);
Starting tables for this task. Grading checks final state on other datasets too.
| id | name | category | qty | price |
|---|---|---|---|---|
| 1 | Pen | tools | 10 | 1.5 |
| 2 | Notebook | books | 5 | 3 |
| 3 | Mug | home | 2 | 8 |
| 4 | Sticker | NULL | 0 | 0.5 |
| 5 | Lamp | home | 1 | 25 |
| 6 | Book Atlas | books | 3 | 12 |
Expected verify columns: id, name, category, qty, price · row order is checked
Expected final state (displayed data):
Loading…One INSERT can add several rows: VALUES (...), (...). Columns are shared across rows. This is shorter than separate INSERT statements.
QUERY STANDBY
›