Row

How it is used

Used constantly when people talk about data volume and query results: 'the table has 40 million rows', 'the query returned no rows', '3 rows affected'. Rows are inserted, updated, deleted and locked. In theory books a row is also called a tuple.

Example sentences

1. The migration added a new row for every existing customer.

2. The UPDATE should touch one row, but it says 5,000 rows affected.

Common collocations

• insert a row
• return rows
• rows affected
• duplicate rows
• row count

Related terms

• tableA structure in a relational database that stores data about one kind of thing in rows and columns, for example all customers or all orders.
• columnA vertical part of a table with a name and a data type, holding one kind of information for every row, such as email or created_at.
• recordOne complete set of data about a single item, such as one customer or one invoice; in a relational table it is the same as a row.
• primary keyA column, or a set of columns, whose value uniquely identifies each row in a table. It cannot be empty and no two rows can share it.

More terms: Tables, Schemas and Database Objects

• schema
• data type
• NULL
• CREATE TABLE
• ALTER TABLE
• view
• stored procedure
• default value
• trigger
• migration