SHOW MIGRATION CHECK ALGORITHM

Description

The SHOW MIGRATION RULE syntax is used to query migration check algorithm.

Syntax

  1. ShowMigrationCheckAlgorithm ::=
  2. 'SHOW' 'MIGRATION' 'CHECK' 'ALGORITHMS'

Return Value Description

ColumnDescription
typemigration check algorithm type
supported_database_typessupported database type
descriptionDescription of migration check algorithm

Example

  • Query migration check algorithm
  1. SHOW MIGRATION CHECK ALGORITHMS;
  1. mysql> SHOW MIGRATION CHECK ALGORITHMS;
  2. +-------------+--------------------------------------------------------------+----------------------------+
  3. | type | supported_database_types | description |
  4. +-------------+--------------------------------------------------------------+----------------------------+
  5. | CRC32_MATCH | MySQL | Match CRC32 of records. |
  6. | DATA_MATCH | SQL92,MySQL,MariaDB,PostgreSQL,openGauss,Oracle,SQLServer,H2 | Match raw data of records. |
  7. +-------------+--------------------------------------------------------------+----------------------------+
  8. 2 rows in set (0.03 sec)

Reserved word

SHOW, MIGRATION, CHECK, ALGORITHMS