Row (Record)

A row is a single record in a database table — one complete entry, such as one user or one order. Each row holds a value for every column in the table.

SQL

Rows are sometimes called records or tuples. When you run a query, the result is itself a set of rows that match your request.

You add new rows with INSERT, change existing rows with UPDATE, and remove them with DELETE.

Examples

SQL

INSERT INTO users (id, name, age)
VALUES (1, 'Alice', 30);

Output:

1 row added.

id  name   age
--  -----  ---
1   Alice  30

Learn it in a lesson

See also

Back to the Dictionary