Introduction to basic Concepts of MySQL Relational Database

The following together to understand the basic concepts of MySQL relational database, I believe that you will benefit a lot after reading, the text in the essence is not much, hope that the basic concepts of MySQL relational database this short content is what you want.

1. Forms

A relational database consists of 'relationships', which are often called 'tables'.

Customers (customer)

CustomerIDNameAddressCity1 Jacky Cheung Earth Town

II. Column

In the above table, each column has a unique name, such as: Nam,City... Each column has an associated data type, such as CustomerID, which you can see as integer data, while other columns are string types, sometimes called fields or properties.

III. OK

Each row in the above table represents a customer, each row has the same format and fields, and a row is also called a record.

Fourth, value

The value of each column must be the same as the data type defined by the column.

5. Key

If we want to identify each row of records, we usually specify a column with a unique value, such as the CustomerID column in the above table, which does not allow duplicate values, and this iconic column is usually called a key or primary key.

After reading this article on the basic concepts of MySQL relational database, many readers will want to know more about it. If you need more industry information, you can follow our industry information section.