What are rows in database tables?

A row (record) in a database table is a single instance of data containing values for each of the columns in that table.

Imagine a table as a spreadsheet:

Column 1	Column 2	Column 3
Value A1	Value B1	Value C1
Value A2	Value B2	Value C2
Value A3	Value B3	Value C3

Each horizontal line (for example, Value A1 | Value B1 | Value C1) represents a single row.

Each row has a unique identifier, often called a primary key, which guarantees that each row in the table is unique.

Rows are used to store specific objects or events described by the table. For example, in a Users table, each row will contain information about a specific user.

Database operations (CRUD - Create, Read, Update, Delete) are performed on rows:

• Create: Adding a new row.
• Read: Retrieving one or more rows.
• Update: Modifying data in existing rows.
• Delete: Removing one or more rows.

In relational databases, rows are also used to link data between different tables through the use of foreign keys.