Shulou(Shulou.com)06/01 Report--

This article mainly introduces "what are the entry knowledge points of MySql". In the daily operation, I believe that many people have doubts about the entry knowledge points of MySql. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the questions of "what are the entry knowledge points of MySql?" Next, please follow the editor to study!

I. the introduction and development history of MySQL database.

In 1996, MySQL 1.0

Sun acquired MySQL on January 16, 2008.

Oracle acquired Sun on April 20, 2009.

MySQL is an open source relational database management system (RDBMS), which uses the most commonly used database management language-structured query language (SQL) for database management.

MySQL is open source, so anyone can download it under the license of General Public License and modify it according to their individual needs.

MySQL has attracted much attention because of its speed, reliability and adaptability. Most people agree that MySQL is the best choice for managing content without the need for transactional processing.

Introduction to MySQL

MySQL is a relational database management system developed by the Swedish company MySQLAB and currently belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is the best RDBMS (RelationalDatabase Management System, relational database management system) application software MySQL. SQL language is the most commonly used standardized language for accessing databases. MySQL software adopts the dual licensing policy, which is divided into community version and commercial version. Because of its small size, high speed and low total cost of ownership, especially open source, the development of small and medium-sized websites generally choose MySQL as the website database.

The difference between community version and enterprise version

The main differences are as follows.

1. The Enterprise Edition contains only stable features, while the Community Edition contains all the latest features of Mysql.

In other words, the community version is the beta version of the enterprise version, but the former has more features than the latter.

two。 The official support service is only for the enterprise version, and Mysql officials are not responsible for any problems that users have when using the community version.

How to download MySQL

Enter the MySQL official website (https://www.mysql.com)

Check the download at the bottom-https://dev.mysql.com/downloads/mysql/

Second, the classification of databases the advantages of relational and non-relational databases:

Complex query

You can easily use SQL statements to do very complex data queries between one table and multiple tables.

Thing support

So that the data access requirements with high security performance can be realized.

Advantages of non-relational databases:

Performance

NOSQL is based on key-value pairs, which can be thought of as the corresponding relationship between primary keys and values in a table that does not need to be parsed by the SQL layer, so it has high performance.

Expandability

It is also very easy to scale horizontally because there is no fortuitousness between key-value pairs of data.

III. Main operations

The operations of database tables include creating, modifying, deleting and viewing.

Data operations: including adding, modifying, deleting query referred to as crud

Crud:

Refers to the addition (Create) read query (Retrieve) update (Update) and delete (Delete) acronym of the word when doing calculation processing

At this point, the study of "what are the basic knowledge points of MySql" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.