SQL Language Support

Dolt's goal is to be compliant with the MySQL dialect, with every query and statement that works in MySQL behaving identically in Dolt.

For most syntax and technical questions, you should feel free to refer to the MySQL user manual.

Any deviation from the MySQL manual should be documented on this page, or else indicates a bug. Please file issues with any incompatibilities you discover.

This series of documents shows:

• ✅ Which SQL language features we support the same as MySQL

• 🟠 Where we support the feature but deviate from MySQL in some way

• ❌ Where we lack support for the SQL language feature.

This section is divided into five main categories:

1. Data Description: SQL features for describing and organizing data

2. Expressions, Functions, Operators: SQL expressions, functions and operators used in queries

3. Supported Statements: statements Dolt supports

4. Information Schema: Dolt support for MySQL information schema

5. Collations and Character Sets: SQL features for describing and comparing strings

6. System Variables: SQL features for configuring server behavior

7. Miscellaneous: miscellaneous SQL features