Inserting into specific columns

Insert values into only some columns.

Insert into all columns

If you give values for every column you can skip the column list; values follow the table order.

INSERT INTO products
VALUES (2, 'Defter', 12, 50, 'kırtasiye');

This query gives values for all columns in table order.

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

Skipping the column list is risky; if the table changes the query breaks. In production always list columns for safety.

Insert id=3 into products giving values for all columns.

Show example solution

INSERT INTO products
VALUES (3, 'Silgi', 2, 100, 'kırtasiye')

All columns

INSERT INTO products
____ (3, 'Silgi', 2, 100, 'kırtasiye');

Show answer

INSERT INTO products
VALUES (3, 'Silgi', 2, 100, 'kırtasiye');