Part 3 of 5 · 1 min read
INSERT: adding a row
Writing one new record into a table.
Think of filing a brand-new form into a cabinet. Nothing already there changes. One new page is added.
In plain words: INSERT adds one new row to a table. It names the table, the columns being filled in, and the values for each column, in matching order.
A worked example. Recording a new order for customer 107.
The key lines.
INSERT INTO orders (order_id, customer_id, placed_on) VALUES (9001, 107, '2026-03-14');
INSERT
INSERT is the SQL statement that adds a new row to a table, with a value supplied for each named column.
Example: INSERT INTO orders (order_id, customer_id, placed_on) VALUES (9001, 107, '2026-03-14') adds one new order row.