1. mSQL :
Mini SQL, or mSQL, is a lightweight database engine designed to provide fast access to stored data with low memory requirements. As its name implies, mSQL offers a subset of SQL as its query interface.
2. MySQL :
MySQL is an open-source relational database management system (RDBMS) based on Structured Query Language (SQL). It is developed and managed by Oracle Corporation and initially released on 23 May, 1995. It is widely being used in many small and large scale industrial applications and capable of handling a large volume of data.
Difference between mSQL and MySQL :
|1.||It was developed By Hughes Technologies in 1994.||It was developed By Oracle in 1995.|
|2.||It is commercial.||It is open-source.|
|3.||Server operating systems for mSQL are AIX, HP-UX, Linux, OS X, Solaris SPARC/x86, Windows.||Server operating systems for MySQL are FreeBSD, Linux, OS X, Solaris, Windows.|
|4.||Its primary database model is Relational DBMS.||Its primary database model is also Relational DBMS.|
|5.||It supports XML.||It does not support XML.|
|6.||A subset of ANSI SQL is implemented.||It supports SQL.|
|7.||APIs and other access methods for mSQL are JDBC, ODBC.||APIs and other access methods for MySQL are ADO.NET, JDBC, ODBC, Proprietary native API.|
|10.||It does not support Triggers.||It supports Triggers.|
|11.||It does not support partitioning methods.||It supports partitioning methods using Horizontal partitioning, Sharding with MySQL Cluster or MySQL Fabric.|
|12.||It does not provide the concept of Referential Integrity. Hence, there are no Foreign Keys.||It provides the concept of Referential Integrity. Hence, there are Foreign Keys.|
|13.||It does not support ACID properties.||It supports ACID properties.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- MySQL | Common MySQL Queries
- Difference between MySQL and MS SQL Server
- Difference between MySQL and PostgreSQL
- Difference between MySQL and SQLite
- Difference Between MySQL and MariaDB
- Difference between Cassandra and MySQL
- Difference between Alibaba Cloud AnalyticDB for MySQL and Amazon Neptune
- Difference between MySQL and dBASE
- Difference between CouchDB and MySQL
- Difference between Couchbase and MySQL
- Difference between Derby and MySQL
- Difference between Adabas and Alibaba Cloud AnalyticDB for MySQL
- Difference between PouchDB and MySQL
- Difference between MySQL and IBM Db2
- Difference between Redis and MySQL
- Difference between Oracle and MySQL
- Difference between MySQL and HBase
- Difference between Neo4j and MySQL
- MySQL | LEAD() and LAG() Function
- MySQL | DATABASE() and CURRENT_USER() Functions
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.