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', 'ada@example.com').
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
-- One row in the users table
INSERT INTO users (id, name, email)
VALUES (1, 'Ada Lovelace', 'ada@example.com');This inserts a single row — one record with values for id, name, and email.
Related terms
Related Resources
Related Lessons
- Insert, Update, Delete
Learn how to add, modify, and remove rows.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.