复古 护眼 海天 深邃 暗黑 默认

SHOW MIGRATION CHECK ALGORITHM

描述

SHOW MIGRATION CHECK ALGORITHM 语法用于查询数据迁移一致性校验算法。

语法

ShowMigrationCheckAlgorithm ::=
  'SHOW' 'MIGRATION' 'CHECK' 'ALGORITHMS'

返回值说明

说明
type 一致性校验算法类型
supported_database_types 支持数据库类型
description 说明

示例

  • 查询数据迁移一致性校验算法
SHOW MIGRATION CHECK ALGORITHMS;
mysql> SHOW MIGRATION CHECK ALGORITHMS;
+-------------+--------------------------------------------------------------+----------------------------+
| type        | supported_database_types                                     | description                |
+-------------+--------------------------------------------------------------+----------------------------+
| CRC32_MATCH | MySQL                                                        | Match CRC32 of records.    |
| DATA_MATCH  | SQL92,MySQL,MariaDB,PostgreSQL,openGauss,Oracle,SQLServer,H2 | Match raw data of records. |
+-------------+--------------------------------------------------------------+----------------------------+
2 rows in set (0.03 sec)

保留字

SHOWMIGRATIONCHECKALGORITHMS

相关链接