Shulou(Shulou.com)06/01 Report--

Let's learn about the MySQL relational database table. I believe you will benefit a lot after reading it. The text is not much in the essence. I hope the short content of the MySQL relational database table is what you want.

CustomerIDNameAddressCity1 Zhang Bai Road Changsha 2 Zhang Black Road Hangzhou 3 Wang Huang Road Beijing

MySQL is a relational database, which is also called a table. If you look at the above tables, you can find:

① column: columns have unique names, such as CustomerID,City, they all contain different data, and they all have a related data type, CustomerID is integer data, Name,City and so on is character data.

② lines: each line represents every customer, each line has the same format, and a line is also called a record.

③ value: each row consists of a single value for each column, which must be of the same data type as the column in which it resides.

④ key: how to identify each customer, that is, each line. Names are generally not recommended, for example, there may be multiple people with the same name in a Name column. Then you need to assign a unique value to each customer, such as CustomerID in the above table, which is called a key or primary key, and the primary key may contain multiple columns.

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.