Research Documentation 04 Mysql

4R MySQL

MySQL Documentation

MySQL Documentation

MySQL vs Other Databases

Both MySQL and SQL server use the SQL language to manage relational databases. One big difference that I saw is that while SQL server supports multiple languages including French, English, Japanese, Chinese, Spanish, and more. MySQL only supports the english language. This surprised me considering how popular MySQL is worldwide. MySQL is free and open sourced, while SQL Server is owned by Microsoft and is not free. There is a free version of SQL Server called SQL Server 2022 express though. There are of course other database management systems available such as PostgreSQL, MariaDB, IBM Db2 etc.

Usage of MySQL worldwide

According to towards data science MySQL is the second most used database engine worldwide coming in just behind Oracle. And is the most popular free database in the industry.

Summary

Each DBMS has it's own pros and cons. Which one a company uses comes down to their individual needs, and is beyond my ability at this point to discern. I think I'll just focus on trying to get my queries working.