Before talking about the guide, we should know several concepts. In a database, the rows and columns of a table have special names. Each column is called a field, and each field contains information about a certain topic, just like the name and contact number in the address book database. These are the attributes of all rows in the table, so we call these columns name fields and contact phone number fields.

Before talking about the guide, we should know several concepts. In a database, the rows and columns of a table have special names. Each column is called a field, and each field contains information about a topic, just like the name and contact number in the address book database. These are the attributes of all rows in the table, so these columns are called name fields and contact phone number fields.

We call each row in the table a record, and each record contains all the information of this row, just like all the information of someone in the address book database, but there is no special record name in the database. Which record is it?

The data stored at the intersection of table rows and columns in the database is called value, which is the most basic storage unit in the database. Its location should be defined by the records and fields in the table. In the table of the address book, you can see that the intersection value of the first record and the company field is the intersection value of the record where Wang Lan of China People's Bank Shanghai Branch is located and the telephone number.