MySQL Relational Database Management System

MySQL Documentation

The MySQL Documentation page is where a user can browse through various topics related to MySQL. It contains links to the reference manual as well as an error reference manual. There is a workbench link which brings the user to the workbench reference manual. Release notes can also be found there separated by Current and All. This looks like a good place to go if a person has a question about how to use MySQL.

MySQL vs Other Databases

When I did a search for how MySQL stacks up against other databases, I found O’Reilly, which is a learning platform. I have posted the link under references. According to O’Reilly, MySQL is fast with complex SELECT statements, handling multiple connections at one time, and many other queries such as ORDER BY and GROUP BY. This article only compared it to mSQL, but they do say in the beginning of the piece that there are benchmarks for Oracle, DB/2, and Microsoft SQL, that they could not publish due to legal reasons.

Usage of MySQL worldwide

According to DB-Engines.com MySQL ranks second in in the 395 systems that they tracked. Per Statista.com, “As of January 2020, around 56 percent of software developers worldwide work with MySQL databases, while about 36.1 percent of developers work with the open-source PostgreSQL databases, making these the two most widely used database technologies by developers around the globe.” I guess this means that if you are working with a database management system, DBMS, it is pretty likely MySQL.

Summary of the Documentation

From what I have read many DBMSs use similar code for their queries, therefore it is useful to learn at least one of them. Why not make it the most popular?

References

https://dev.mysql.com/doc/

https://www.oreilly.com/library/view/mysql-reference-manual/0596002653/ch01s09.html

https://db-engines.com/en/ranking

https://www.statista.com/topics/5157/database-software/#dossierKeyfigures