- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
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.
- Related Articles
- Compliance: Meaning & Significance
- What is Conformance Testing (Compliance Testing)
- HIPAA Compliance: Storage in the Cloud
- What do you mean by compliance specialist?
- C++ Standards Support in GCC
- Advertising Standards Council of India (ASCI)
- Why are e-wallet users angry about KYC compliance?
- What are Python coding standards/best practices?
- Who’s Who in the International Standards World
- Who’s Who in the Internet Standards World
- Differentiate between accounting standards and accounting concepts.
- Coding standards (style guide) for Python programs?
- Scripting standards for Automation Testing in RPA
- Ethical Standards in India and Other Countries
- Standards for maintaining Customer Repository Objects in SAP