SQL Step-by-Step (2) Table basics

The basics of a table

A relational database usually contains more than one table. A database is actually a collection of tables, and the data or information of a database is stored in a table. A table is a logical structure for storing and manipulating data, and each table represents an object that is meaningful to the user. For example, in a corporate database, there are employee tables, Department tables, inventory tables, sales tables, payroll, and so on. What we often see is a table, which is made up of rows and columns, and we can identify the data by name. The column contains the name of the column, the data type, and other properties of the column, and the row contains the records or data for the column. Here is a report card, where the name, language, mathematics, English are columns, and the row contains the data of the table, that is, each individual's subjects score:

78

85

name	language	math	English
Wang Xiaodong	100	87
Zhangliu	92	95
Ziyun fly	65	89	86
	98	67	75