1SQL is the language. It outlines syntax that allows you to write queries that manage relational
2databases. Nothing more.
3MySQL meanwhile is a database system that runs on a server. It implements the SQL language,
4allowing you to write queries using its syntax to manage MySQL databases.
1MySQL is a relational database vendor which uses SQL language
2on the other hand SQL is a query language which deals with database.
1/* Differences Table
2Parameter MariaDB MySQL
3Storage Engines MariaDB has 12 new storage engines that you won't find in MySQL. Fewer options for storage
4Speed Improvements MariaDB shows an improved speed when compared to MySQL. Slower speed
5Initial release 2009 1995
6Server operating systems FreeBSD, Linux, Solaris, Windows FreeBSD, Linux, OS X, Solaris, Windows
7Faster cache/indexes An INSERT statement can be completed 24% faster Slower
8Larger and Faster Connection Pool Advanced thread pool capable of running faster and supporting up to 200,000+ connections. Cannot support up to 200,000 connections per time.
9Improved Replication Safer and faster. Updates 2x faster Community edition allows a static number of threads to be connected. MySQL's enterprise plan comes with thread capabilities.
10New Features/Extensions Comes with new features and extensions including the JSON, WITH and KILL statements. The new MariaDB features are not provided in MySQL.
11Missing Features Lacks some of the features provided by the MySQL enterprise edition. Offers alternative open-source plugins. The Enterprise Edition of MySQL uses a proprietary code. Only users of MySQL Enterprise Edition have access to this.
12Priority code Doesn't allow access to this propriety content and is a closed source. Uses some proprietary code in its Enterprise Edition.
13Data Masking No Yes
14Dynamic columns No Yes
15Monitoring SQLyog MySQL workbench
16Routing MariaDB MaxScale Mysql Router
17Analytics MariaDB ColumnStore No
18Secondary database model Document store and Graph DBMS Document store
19Git hub stars 2.8 k 4k
20Forks 868 1.6 K
21Famous companies using Nrise, Accenture, Docplanner, Grooveshark. Airbnb, Uber Technogloeis, Netflix, Dropbox.
22*/
1• SQL is a standard language for
2retrieving and manipulating structured
3databases. On the contrary,
4MySQL is a relational database management
5system, like SQL Server, Oracle or
6IBM DB2, that is used to manage SQL
7databases.