MySQL Standards Compliance

The standards compliance tells how MySQL is related to the ANSI/ISO SQL standards. There are many versions of the SQL standard, and the phrase ‘SQL standard’ is used to refer to the current version of SQL standard at any point in time.

Following are the MySQL Standards Compliance −

  • MySQL server was originally designed to work with medium-sized databases (10 to 100 million rows or 100 MB per table) on small systems. But currently, it has been upgraded to work with terabyte-sized databases.

  • MySQL supports ODBC levels ranging from 0 to 3.5.1.

  • MySQL also supports high-availability database clustering, which can be achieved with the help of the ‘NDBCLUSTER’ storage engine.

  • A native JSON datatype, which has been defined as RFC 7159. This is based on the ECMAScript standard, ECMA-262.

  • Implements a subset of the SQL/JSON function which has been specified by a pre-publication draft of the SQ-2016 standard.

  • The MySQL server can be operated in different modes, and these modes can be applied differently to different clients. This depends on the value associated with the ‘sql_mode’ system variable.

  • The DBAs are allowed to set the global SQL mode so as to match the site server operating requirements. Every application can set its own SQL session mode depending on its requirements.

  • Depending on the mode of SQL, the syntax of MySQL also changes, along with the data validation check that is performed alongside.