TiDBTiDB Docs Dash 2024

Jan 9 - Jan 12 (UTC)
Join us to improve docs and win a prize!
Sign InTry Free

Table Selector of TiDB Data Migration

Table selector provides a match rule based on wildcard characters for schema/table. To match a specified table, configure schema-pattern/table-pattern.

Wildcard character

Table selector uses the following two wildcard characters in schema-pattern/table-pattern:

  • The asterisk character (*, also called "star")

    • * matches zero or more characters. For example, doc* matches doc and document but not dodo.
    • * can only be placed at the end of the word. For example, doc* is supported, while do*c is not supported.
  • The question mark (?)

    ? matches exactly one character except the empty character.

Match rules

  • schema-pattern cannot be empty.
  • table-pattern can be empty. When you configure it as empty, only schema is matched according to schema-pattern.
  • When table-pattern is not empty, the schema is matched according to schema-pattern and table is matched according to table-pattern. Only when both schema and table are successfully matched, you can get the match result.

Usage examples

  • Matching all schemas and tables that have a schema_ prefix in the schema name:

    schema-pattern: "schema_*" table-pattern: ""
  • Matching all tables that have a schema_ prefix in the schema name and a table_ prefix in the table name:

    schema-pattern = "schema_*" table-pattern = "table_*"

Was this page helpful?

Download PDFRequest docs changesAsk questions on Discord
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Products
TiDB
TiDB Dedicated
TiDB Serverless
Pricing
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.