INSERT
ELI5 — The Vibe Check
INSERT is how you add new data to a database. It is the 'Create' in CRUD. You tell it which table, which columns, and what values to put in. One INSERT = one new row added to the table.
Real Talk
INSERT is the SQL statement for adding new rows to a table. It specifies the target table, column names, and corresponding values. It can insert a single row or multiple rows in one statement. It triggers any DEFAULT values and validates all constraints.
Show Me The Code
INSERT INTO users (name, email, created_at)
VALUES ('Alex', 'alex@example.com', NOW());
When You'll Hear This
"INSERT a new row when the user submits the signup form." / "Bulk insert 1000 rows at once for performance."
Related Terms
CRUD (Create, Read, Update, Delete)
CRUD is the four things you can do to data: Create it, Read it, Update it, Delete it. Literally every app ever made is just CRUD in a trenchcoat.
DELETE
DELETE removes rows from a table. It is the 'Delete' in CRUD. Like UPDATE, you MUST use a WHERE clause — without it, you delete everything in the table.
Row
A row is one single record in a table. If your users table has 500 users, it has 500 rows.
SELECT
SELECT is how you ask a database to give you data. It is the 'Read' in CRUD.
UPDATE
UPDATE changes existing data in a table. It is the 'Update' in CRUD.