Skip to content

Row

In one line

A row (also called a record or tuple) is a single data entry in a table — one value for each column.

In simple words

A row is one record in a table. If a table has columns id, name, and email, then a row is one complete set of values for those columns — for example, (1, 'Ada', '[email protected]').

Each row represents one entity in the real world: one user, one product, one order. The collection of all rows in a table is the dataset.

Rows are also called records or tuples. In SQL, you add rows with INSERT, modify them with UPDATE, and remove them with DELETE.

Example

sql
-- One row in the users table
INSERT INTO users (id, name, email)
VALUES (1, 'Ada Lovelace', '[email protected]');

This inserts a single row — one record with values for id, name, and email.

Related terms

Related Resources

Related Lessons

Decode error messages

Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.

View errors

← Back to glossary