Junior — Middle
Can you explain the differences between a table, a column, and a row in a database?
sobes.tech AI
Answer from AI
In a database:
-
Table is a structure that stores data in the form of rows and columns, similar to an Excel sheet. It represents a set of related data.
-
Column is a single field in a table that defines the data type and contains values of one type for all records. For example, the "Name" column stores the names of all users.
-
Row (record) is a single entry in a table, consisting of values for all columns. For example, one row may contain data for a single user: name, age, email, etc.
Example:
| ID | Name | Age |
|---|---|---|
| 1 | Anna | 25 |
Here, the table is the entire structure, the column is "Name", and the row is the record with ID=1.