UNIT 1:First to know MySQL

This term,we get a new lessons which means "数据库原理与应用".Yeah,it's about MySQL.

For me,there are something valued to be discussed.

At first,what is database?

Database is a storehouse which according to the data structure organizes, stores and manages data.The concept of database was put forward sixty years ago.But database technology is developing very fast.

The development of database is divided into four phases：

Manual management phase

File system phase

Database system phase

Advanced database phase

There are three kinds of database：

Hierarchical database

Network database

Relational database

Second,what are table data-type and primary key.

In a database, tables are collections of a series of two-dimensional arrays and logical structure for storing data and operating data.It consists of vertical columns and horizontal rows. The line is called the record which is the unit of data. Columns are called fields, and each column represents a property of a record, with corresponding information description.

Here is a table.

name	number	······	······	lesson	grade
May	01	······	······	math	85
Jack	02	······	······	math	90
······	······	······	······	······	······

Data type determines the storage format of data in the computer, representing different types of information.

The primary key, also known as the master code, is used to uniquely identify every record in the table. The primary key can be a column or a multiple column.

Then,we need to know the Database System.

DBMS(DataBase Management System) is the software used by users to create, manage and maintain the database. It is located between the user and the operating system and manages the database uniformly.

DBA(DataBase Application) can meet the higher requirements for data management.

Last,what is MySQL?

MySQL is a relational database management system.

MySQL software adopts a dual authorization policy, divided into community version and commercial version, because of its small size, fast speed, low overall cost, especially the characteristics of open source, the development of small and medium-sized websites generally choose MySQL as a website database.

Advantages of MySQL:

(1) speed: fast running speed.

(2) price: MySQL is free for most personal use.

(3) Easy to use: Compared with other large-scale database settings and management, its complexity is low, easy to learn

(4) Portability: Ability to work on many different systems platforms, such as Windows, Linux, Unix, Mac OS, etc.

(5) Rich interfaces: provide APIs for languages like C, C++, Eiffel, java, perl, php, python, ruby, and TCL.

(6) Supporting Query Language: MySQL can leverage standard SQL syntax and applications that support ODBC (Open Database Connection).

(7) Security and connectivity: very flexible and secure privilege and password systems that allow host-based authentication. When connecting to the server, all cipher transfers are encrypted, thus ensuring password security. And because MySQL is networked, it can be accessed anywhere on the Internet to improve the efficiency of data sharing.

So we understand so much about database, but how do we learn MySQL? See you next time!