Skip to content
BENIBIX Learn

Row

Development🗃️ DatabasesDatabase Basics

Also known as Record, Database Row

One record in a table. It holds all the facts about one thing.

Think of it like

Think of it like one line in a class list. It holds all the facts on one pupil.

Example

When Lucy signs up, a new row is added to the customers table. It holds her id, her name and her city.

Why it matters

Rows are the real data. Each sign-up, sale and message becomes a new row.

Definition

A row is one record in a database table, like one customer or one order. It holds all the facts about that one thing. Each row has a value for every column, even if that value is empty. Rows are added with INSERT, changed with UPDATE and removed with DELETE. A table can hold anything from one row to billions.

Example code

sql
INSERT INTO customers (name, city)
VALUES ('Lucy', 'Lisbon');
This adds one new row for Lucy.

Common mistake

Storing the same fact in two rows. When one changes and the other does not, the data disagrees with itself.

Key takeaways

  1. 1
    One thing. A customer, an order, a message.
  2. 2
    A value per column. Even if it is empty.
  3. 3
    Insert, update, delete. The three ways rows change.