04 MySQL Home

MySQL Documentation

MySQL is a relational database management system founded in 1995. We use it to store data in tables, rows and columns. MySQL is mainly used in web applications that available for Linux, Microsoft Windows, Mac OS and Solaris. What is MySQL

MySQL and other databases

1. MySQL and Oracle. Oracle is another relational database management system released in 1977. The main similarity between MySQL and Oracle is that they are both relational and suport SQL. The languages of implementation are C and C++ and they are among top 10 best databases in the world.
2. MySQL and Microsoft SQL Server. MSSQL is Microsoft developed RDBMS. Both MySQL and MSSQL support multiple programming languages.You can use both databases for Windows and Linux. MySQL works the best with PHP while MSSQL is mainly used with .NET.
3. MySQL and PostrgeSQL are similar in syntax, both support many same languages with a few differences and are both fast. However, MySQl is relational database while PostgreSQL is object-relational.
4. MySQL and MariaDB are both open source, relational databases. MariaDB was originally a part of MySQL project and thats why they share lots of similarities. They have the same syntax and similar indexing.

Usage of MySQL worldwide

While Oracle is the best database in the world, MySQL stays the most used database in web applications and takes the second place in the most popular databases around the world.

Summary of the documentation

In conclusion, MySQL is a relational database which means one can define relationships between the tables. Here are some advantages of using MySQL:

1. MySQL is well established and has more community support rather than other open sourse databases.
2. MySQL guarantees data validity despite of any errors and failures.
3. High performance
4. MySQL supports very large databaes up to hundreds of millions of records
5. MySQL has enhanced security mechanisms
6. MySQL works well with PHP, and many different platforms