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

This article will explain in detail how to organize data in the database. Xiaobian thinks it is quite practical, so share it with you for reference. I hope you can gain something after reading this article.

Tables in a 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". Each record contains all the information in this row, just like all the information in a person's address book database, but the record does not have a special record name in the database. It is often indicated by the number of rows it is in. (Recommended learning: MySQL video tutorial)

A field is a unit smaller than a record. A collection of fields makes up a record. Each field describes a feature of the document, i.e., a data item, and has a unique field identifier for computer recognition.

field

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

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

But sometimes, the field is not a column in the table, such as using as to calculate the contents of a column and "store" it in another field.

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

id abc1 5 About how to organize data in the database is shared here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

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.