MySQL standards compliance

Standards compliance describes MySQL's relationship to the ANSI/ISO SQL standards. There are many versions of the SQL standard, and the term "SQL standard" is used to refer to the current version of the SQL standard at any point in time.

The following is MySQL's standards compliance:

• MySQL Server was originally designed to handle medium-sized databases (10 to 100 million per table) on small systems rows or 100MB). But it has been upgraded to handle large-capacity databases.

• MySQL supports various levels of ODBC from 0 to 3.5.1.

• MySQL also supports high-availability database clustering, which can be achieved through the "NDBCLUSTER" storage engine.

• Native JSON data type, defined as RFC 7159. This is based on

ECMAScript standard, ECMA-262.

Implements a subset of the SQL/JSON functions specified in the pre-release draft of the SQ-2016 standard.

MySQL server can run in different modes, and these modes can be applied to different clients. This depends on the value associated with the "sql_mode" system variable.

Allows DBAs to set global SQL patterns to match the operational requirements of the site server. Each application can set its own SQL session mode according to its requirements.

According to the SQL mode, the syntax of MySQL will also change, and data validation checks will be performed at the same time.

The above is the detailed content of MySQL standards compliance. For more information, please follow other related articles on the PHP Chinese website!