Row

A row in a database table represents a single record or entry containing values for each column, maintaining data consistency within the table.

A row, also known as a record or tuple, contains actual data stored in the database. Each row in a table corresponds to a real-world entity. For example, in a Students table, a row might represent a single student with details like name, age, and course.

Rows ensure that the database stores individual instances of data while adhering to table constraints and relationships. Each row must comply with column definitions (e.g., data types and constraints).

Example SQL Query (Inserting a Row into a Table):

INSERT INTO Students (student_id, name, age, course)
VALUES (1, 'Alice Johnson', 21, 'Computer Science');

This inserts a new student record into the Students table.

To retrieve all rows from the table:

SELECT * FROM Students;

Each row returned will represent a separate student.