Difference between MySQL and mSQL

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 :

S.NO.	mSQL	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.
8.	Programming languages supported by mSQL are C, C++, Delphi, Java, Perl, PHP, Tcl.	Programming languages supported by MySQL are Ada, C, C#, C++, D, Delphi, Eiffel, Erlang, Haskell, Java, JavaScript (Node.js), Objective-C, OCaml, Perl, PHP, Python, Ruby, Scheme, Tcl.
9.	It does not support server-side scripting.	It supports server-side scripting using JavaScript.
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.