what is mysql database

MySQL database was originally an open source relational database management system. The original developer was the Swedish MySQL AB company. The company was acquired by Sun Microsystems in 2008; in 2009, Oracle acquired Sun Microsystems. Systems company, MySQL has become a product of Oracle.

The operating environment of this article: Windows 7 system, mysql version 8.0, Dell G3 computer.

What is the mysql database?

MySQL is a relational database management system developed by the Swedish MySQL AB company and is a product of Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is one of the best RDBMS (Relational Database Management System) application software.

MySQL (officially pronounced /maɪˌɛskjuːˈɛl/"My S-Q-L", but also often pronounced as /maɪˈsiːkwəl/"My Sequel") was originally an open source relational database management system. The original developer was Swedish MySQL AB, which was acquired by Sun Microsystems in 2008. In 2009, Oracle acquired Sun Microsystems, and MySQL became a product of Oracle.

MySQL has become the most popular open source database in the past due to its high performance, low cost, and good reliability, and is therefore widely used in small and medium-sized websites on the Internet. As MySQL continues to mature, it is gradually used in more large-scale websites and applications, such as Wikipedia, Google, and Facebook. The "M" in the very popular open source software combination LAMP refers to MySQL.

However, after being acquired by Oracle, Oracle significantly increased the price of the MySQL commercial version, and Oracle no longer supports the development of OpenSolaris, another free software project. This has led the free software community to question whether Oracle can still There are concerns that MySQL Community Edition (the only free version among MySQL) will continue to be supported. Michael Widenius, the founder of MySQL, established a branch project MariaDB based on MySQL. Some open source software that originally used MySQL gradually turned to MariaDB or other databases. For example, Wikipedia officially announced in 2013 that it would migrate from MySQL to MariaDB database [6].

MySQL’s license is now divided into free community edition and paid standard edition, enterprise edition, etc. [7]. Generally speaking, if MySQL is released in a non-open source project, or Oracle is required to provide technical support for MySQL, or some enterprise version tools or plug-ins of MySQL are used, or the MySQL source code is modified and used as closed source software, etc. , need to purchase the commercial version. If you just install and use MySQL, or even modify and use MySQL, regardless of whether it is charged or not; or if the software does not include MySQL and the user of the software installs MySQL by himself; or if MySQL is included in open source software products using the GPL agreement, you may use the community version in these cases MySQL.

mysql features

• Written in C and C, and tested using a variety of compilers to ensure the portability of the source code.

• Supports AIX, BSDi, FreeBSD, HP-UX, Linux, Mac OS, Novell NetWare, NetBSD, OpenBSD, OS/2 Wrap, Solaris, Windows and other operating systems.

• Provides APIs for multiple programming languages. These programming languages ​​include C, C, C#, VB.NET, Delphi, Eiffel, Java, Perl, PHP, Python, Ruby and Tcl, etc.

• Supports multi-threading, makes full use of CPU resources, and supports multiple users.

• Optimized SQL query algorithm, effectively improving query speed.

• It can be executed as a standalone application in a client-server network environment, or it can be embedded into other software as a library.

• Provides multi-language support. Common encodings such as Chinese GB 2312, BIG5, Japanese Shift JIS, etc. can be used as data table names and data column names.

• Provides multiple database connection channels such as TCP/IP, ODBC and JDBC.

• Provides management tools for managing, checking, and optimizing database operations.

• Can handle large databases with tens of millions of records.

[Related recommendations: mysql video tutorial]

The above is the detailed content of what is mysql database. For more information, please follow other related articles on the PHP Chinese website!