# Row

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

**Field:** Software Development  
**Category:** Databases  
**Also known as:** Record, Database Row

## Think of it like

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

## 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

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

## Example code

```sql
INSERT INTO customers (name, city)
VALUES ('Lucy', 'Lisbon');
```

This adds one new row for Lucy.

## Why it matters

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

## Common mistake

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

## Three principles

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

## Related terms

- [Database Table](https://learn.benibix.com/term/development/database-table)
- [Column](https://learn.benibix.com/term/development/column)
- [Primary Key](https://learn.benibix.com/term/development/primary-key)
- [Structured Query Language (SQL)](https://learn.benibix.com/term/development/sql)
- [Tuple](https://learn.benibix.com/term/development/tuple)

---

Source: https://learn.benibix.com/term/development/row
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-19
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
