MySQL – getting to know MySQL

Time:2021-1-29

1.1 why use database

Database (store data)
Txt, Excel, word can also store data, but there are many limitations.
Database is the most core existing DBA in all software systems

Operating system, data structure and algorithm must be well understood

1.2 what is database

Database (DB, database)
Concept: data warehouse,Software, installed on the operating system, can store a lot of data. Five million!
Function: store data, manage data

1.3 database classification

Relational databaseGenerally speaking, it is row and column (SQL)

  • MySQL,Orable,Sql Server,DB2,SQLlite
  • Through the relationship between tables, rows and columns to store data.

Non relational database: roughly{ key:value }(NoSQL,Not Only SQL)

  • Redis,MongoDB
  • Non relational database, object storage, through the object’s own properties to determine.

DBMS (database management system)

  • Database management software, scientific and effective management of our data. Maintain and acquire data;
  • Mysql, database management system!

1.4 introduction to MySQL

MySQL is aRelational database management system
Former: Swedish MySQL AB company.
After: data is owned by Oracle.
MySQL is one of the best RDBMS (relational database management system) application software.
Open source database software.
Small size, fast speed, low total cost of ownership.
Small and medium sized websites, or large websites (clusters)
Official website:MySQL official website
5.7 stability
8.0

1.5 install MySQL

Here I’m taking the MAC installation process as an example, and the installed version is 8.0.2
Installation process:Configuring MySQL on MAC

This work adoptsCC agreementReprint must indicate the author and the link of this article