Row
ELI5 — The Vibe Check
A row is one single record in a table. If your users table has 500 users, it has 500 rows. Each row holds all the data about one specific thing — one user, one order, one product.
Real Talk
A row (also called a record or tuple) is a single, horizontally organized set of data in a table. It represents one instance of the entity the table describes. Each row contains values for every column defined in the table schema.
When You'll Hear This
"Insert a new row when a user signs up." / "Delete the row with id = 42."
Related Terms
Column
A column is a category of data in a table. If a table is a spreadsheet, columns are the headers: 'Name', 'Email', 'Age'.
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.
INSERT
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.
Record
A record is just another word for a row. Developers love having five words for the same thing to keep you on your toes.
Table
A database table is exactly like a spreadsheet tab. It has columns across the top (name, email, age) and rows going down (one per person).