A row is one complete record in a database table.
A row is one complete record in a database table.
Each row describes one item, person, event, or other stored thing. The values in that row belong together because they describe the same record.
In a users table, one row can represent one user.
Think of a row as one filled-out line on a form.
The labels across the top tell you what each piece of information means. One horizontal line then holds the complete information for one item.
A row keeps the values for one record together so software can work with that record as a unit.
Store the information that describes one user, order, product, or event.
Group related values such as an ID, name, and email address.
Let software read, update, or delete one complete record.
Give a query a record that the application can display or process.
Rows appear in every table that stores multiple records of the same kind.
A row can hold one user’s ID, name, email, and status.
A row can hold one order’s ID, customer, amount, and date.
A row can hold one product’s name, price, and inventory count.
A row can hold one recorded event and the time it happened.
Suppose a users table has these columns:
| id | name | status | |
|---|---|---|---|
| 42 | Alex | alex@example.com | active |
The complete line with ID 42 is one row. Together, its four values describe one user.
A query can find that one row:
SELECT id, name, email, status
FROM users
WHERE id = 42;The database returns the matching row as the query result.
A query selects rows from tables, and the backend turns those rows into an application response.
One complete record, such as one user or one order.
One type of information shared by every row in a table.
A collection of related rows organized by columns.
Another common word for the complete data represented by one row.
A row is horizontal data for one item; a column is vertical data for one attribute.
| ENGLISH TERM | 中文 | SIMPLE ENGLISH | 中文小白理解 |
|---|---|---|---|
| Row | 行 | One complete record in a database table. | 数据库表中的一条完整记录。 |
| Record | 记录 | A complete set of values about one item. | 描述一个对象的完整数据集合。 |
| Table | 表 | A structure that organizes related rows and columns. | 用行和列组织相关数据的结构。 |
| Column | 列 | One type of information stored for every row. | 每一行都保存的一种信息类型。 |
| Field | 字段 | A named place for one value in a record. | 记录中存放某个值的有名字的位置。 |
| Query | 查询 | A request to read or change database data. | 向数据库读取或修改数据的请求。 |
| SQL | 结构化查询语言 | A language used to work with relational databases. | 用来操作关系型数据库的语言。 |
A row is one complete record in a database table.
Columns describe the kinds of values; a row holds the values for one item.
SQL queries can select, update, or delete rows.