Tables in a database organize data in rows and columns. Each row is called each column.

Tables in the database organize data in rows and columns. Each row is called a record and each column is called a field.

We call each row in the table a "record" , and each record contains all the information in this row, like All information about a person in the address book database, but the record does not have a special record name in the database. The row number where it is located is often used to indicate which record it is. (Recommended learning: MySQL video tutorial)

Fields are smaller units than records. A collection of fields forms a record . Each field describes a certain part of the document. A feature is a data item and has a unique field identifier that is recognized by computers.

Field (field)

A member that represents a variable associated with an object or class.

In the database, most of the time, the "columns" of the table are called "fields", and each field contains information about a certain topic. Just like in the "Address Book" database, "Name" and "Contact Number" are attributes common to all rows in the table, so these columns are called the "Name" field and "Contact Number" field.

But sometimes, the fields are not columns in the table. For example, as is used to calculate the contents of the column and "store" it in another field.

For example: There is only column "ID" in a table "T", and the content is "int" value "1". Using "select id, id * 5 as abc from T", the result is

id abc
1 5

For more MySQL related technical articles, please visit the MySQL Tutorial column to learn!

The above is the detailed content of Tables in a database organize data in rows and columns. Each row is called each column.. For more information, please follow other related articles on the PHP Chinese website!