Get the App
SLTechnology News&Howtos  ›  Database  › 

Introduction to MySQL-

Shulou Source: shulou.com Published: 2022-06-01 15:33:49 10月03日 Update

1. Background

* MySQL is a relational database management system developed by the Swedish company MySQL AB and currently under the umbrella of Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is the best RDBMS (relational database management system) application software.

* MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility.

* the SQL language used by MySQL 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.

two。 advantage

* support multiple platforms [AIX, FreeBSD, HP-UX, Linux, Mac OS, OpenBSD, Solaris, Windows.]

* support and provide multilingual API

* Open source, using the GPL protocol, you can modify the source code to develop your own MySQL system

* support standard SQL statements

* multiple storage engines are supported

* widely used [all global top20 websites apply MySQL except Microsoft's Live and Bing]

3. Release notes for MySQL version

4. The difference between MySQL Community Edition and Enterprise Edition

5. Features of MySQL Enterprise Edition

6. Comparison between mainstream versions and branches of MySQL

7. MySQL installation mode

* General system 2 installation package installation

* Source code compilation and installation

* self-compilation and installation is not recommended

* mainly used for kernel debugging

* platform installation package, such as rpm package [centos,redhat] or deb [debian,ubuntu] package

8. Summary

In order to demand-driven technology, there is no difference in technology itself, only in business.

Tags: Data database system management system support management source code website application development enterprise multiple platform technology standard version feature community language software Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Technology OPPO Reno Redmi NVidia macOS