Basic concept of relational database and MySQL brief

Basic concept of the database "> Basic concepts of relational databases

Database :
An efficient solution for managing large amounts of information.
A library that organizes, stores, and manages data in accordance with its data structure .

Database Systems (dbs,database system):
Database (db,database) + Database management systems (Dbms,database MANAGEMENT System)

relational database
A database system built on a relational model.

Relational Model:
How the entity structure should be handled when the attributes of the entity (student) and entity in daily life (student's number, name, etc.) are saved to the database.
1, data structure can be stipulated, similar data, structure consistent, is a two-dimensional table.
2, the relationship between data can be set. The relationship between the entity and the entity.
Entity structure + Entity Contact

the concept of a relational database:
Database: The warehouse of the data.
Tables table: Data stored in a table, stored in a table of data, should have the same data format.
Rows and columns: Rows are used to record data, and columns are used to specify the data format.
Record: The data in the row.
Field: A column of data.
SQL: Data management system, the language used to manage the data, Structured Query Language (Structured Query language).

MySQL "> why use MySQL?

MySQL was developed by MySQL AB in Sweden and is currently a relational database product of Oracle (Oracle) (2008 MySQL AB was acquired by Sun, 2009 Sun was acquired by Oracle) and open source, free of charge.
The world's most popular open source database system, powerful enough to handle Web applications.

MySQL uses the C/s (client/server side) architecture.
Server-side: stores and manages databases.
Client: The program that issued the action request.
(mysqld server, MySQL client)

installation and use of MySQL and Navicat clients

http://blog.csdn.net/scgaliguodong123_/article/details/45392283

managing MySQL Servers

1, as a Windows service Management, service (SERVICES.MSC)
2. Command line Form

dos">Net start MySQLNet stop MySQL

3. Run the MYSQLD server program directly

basic process of database operation

Steps:
1, connection, authentication.
2, the client sends the operation instruction to the server side.
3, the server-side processing request instructions.
4, the server side returns processing results to the client.
5, the client displays the resulting results.

Operation MySQL

Via MySQL client, operate MySQL.
connection:MySQL (mysql.exe) –hlocalhost–p3306–uroot–pliguodong
exit:Exit quit \q

Basic concept of relational database and MySQL brief