Updated on 2024-05-14 GMT+08:00

MySQL Compatibility Overview

This chapter compares the MySQL 5.7 compatibility mode in GaussDB (that is, when sql_compatibility is set to 'B', b_format_version is set to '5.7', and b_format_dev_version is set to 's1') with MySQL 5.7. Only compatibility features added later than GaussDB Kernel 503.0.0 are described. You are advised to view the specifications and restrictions of the features in Developer Guide.

GaussDB is compatible with MySQL in terms of data types, SQL functions, and database objects.

The underlying framework implementation of the GaussDB is different from that of MySQL. Therefore, there are still some differences between GaussDB and MySQL.