MySQL database 1-Basic concepts and installation

A . the emergence and development of data management technologies:

1. Manual Management Phase - low efficiency and high cost ( text)

2. file System stage - easy to store, fast processing, rich in data form (text, sound, picture ...) tape, disk)

3. Database System phase - easy to maintain massive data, faster operations and processing, secure data, and manage data using programming languages

Two . Common concepts in relational databases

1. Database and database management system

Database management Systems -Databases Manager System (DBMS)- Tools for managing data (eg:mysql, SQL Server, Oracle ... )

2. Common concepts of relational databases

The most popular databases in the world are relational databases, which are characterized by the fact that data is stored in tabular form.

Include: Field (title), tuple, row (record), column

Course Number	Course Name	Hours	Average score

Data redundancy: Data that can exist without real existence is called data redundancy

Completeness: Correctness of data

Loss of integrity: data is out of the wrong

Primary key: cannot be duplicated (uniquely identifying entity), primary key cannot be empty

Null / Duplicate primary key: Loss of entity integrity

FOREIGN key: The data on this column originates from other tables and cannot be scrambled.

Reference to nonexistent data: loss of referential integrity

Type (name must be character data type), range (gender must be male or female), malformed (ID number must be ): Lost domain integrity

3. Introduction to Structured Query Language SQL

Structured queries language (Structured query Language)

Category: Data definition language (DDL) -creat, alter, drop

       Data Manipulation language (dml - increased ( insert delete Span style= "font-family: the song Body;" ), update ( update ), query ( select

Data Control Language (DCL) - allocation (Grant), Recycling (Revoke ), deny (deny)

Three about MySql

Development history: Developed by Swedish Myysql AB , currently owned by Oracle company

Features: Open source, less resource-intensive, suitable for a variety of programming languages, support for client access

Version:

MYSQL Community Server Community version, open source free, but does not provide official technical support

MYSQL Enterprise Edition Corporate version, payable, can be tried for up to a Day

MySQL Cluster cluster edition, open source free, can encapsulate several MYSQL servers into one server.

MYSQL Cluster CGE Premium Cluster edition, payable

Four MySql Download and install

Download MySql steps:

1. Login to MySql official website www.mysql.com
2. Enter the download module
3. Select Community Edition -Community
4. Select Download under MySql Community Server
5. Find the latest version recommended by the official web
6. Choose a graphical installation package -MYSQL Installer MSL Download

To install the MySql Step:

1. If you have previously installed Mysql on this machine , please uninstall

2. Click Install File

3. Select Accept license to start the installation process

4. Select the installation mode for the custom installation

5. go to the installation process

6. complete the installation and go to the Configuration Wizard

MySQL database 1-Basic concepts and installation