SHOW MIGRATION LIST

Description

The SHOW MIGRATION LIST syntax is used to query migration job list.

Syntax

Grammar Railroad diagram

  1. ShowMigrationList ::=
  2.   'SHOW' 'MIGRATION' 'LIST'

Return Values Description

ColumnsDescription
idmigration job id
tablesmigration tables
job_item_countmigration job sharding number
activemigration job states
create_timemigration job create time
stop_timemigration job stop time

Example

  • Query migration job list
  1. SHOW MIGRATION LIST;
  1. mysql> SHOW MIGRATION LIST;
  2. +---------------------------------------+---------+----------------+--------+---------------------+---------------------+
  3. | id                                    | tables  | job_item_count | active | create_time         | stop_time           |
  4. +---------------------------------------+---------+----------------+--------+---------------------+---------------------+
  5. | j01013a38b0184e07c864627b5bb05da09ee0 | t_order | 1              | false  | 2022-10-31 18:18:24 | 2022-10-31 18:18:31 |
  6. +---------------------------------------+---------+----------------+--------+---------------------+---------------------+
  7. 1 row in set (0.28 sec)

Reserved word

SHOW, MIGRATION, LIST