Product table

Write queries to list and filter products.

Adding items

To add items to the inventory you use INSERT. You enter name, quantity and location info.

INSERT INTO inventory (id, name, qty, location)
VALUES (1, 'Vidalı', 100, 'A1');

This query adds 100 screws to shelf A1.

The values given with VALUES are inserted into inventory as new rows.

Each inventory line is a row. Location info helps find the product on the shelf quickly.

Insert id=2, name='Bolt', qty=50, location='B2' into inventory.

Show example solution

INSERT INTO inventory (id, name, qty, location)
VALUES (2, 'Civata', 50, 'B2')

Values

INSERT INTO inventory (id, name, qty)
____ (2, 'Civata', 50);

Show answer

INSERT INTO inventory (id, name, qty)
VALUES (2, 'Civata', 50);