old_tbl_name) } 7. 8. create_definition: 9. col_name column_definition 10. | [CONSTRAINT [symbol]] PRIMARY KEY [index_type] (index_col_name,...) 11. [index_option] ... 12. | {INDEX|KEY} 数据定义语句 (DDL) - 137 - 本文档使用 书栈(BookStack.CN) 构建 13. [index_option] ... 14. | [CONSTRAINT [symbol]] UNIQUE [INDEX|KEY] 15. [index_name] [index_type] (index_col_name,...) 16. [index_option] {FULLTEXT} [INDEX|KEY] [index_name] (index_col_name,...) 18. [index_option] ... 19. | [CONSTRAINT [symbol]] FOREIGN KEY 20. [index_name] (index_col_name,...) reference_definition 21. 22. column_definition:

special meanings, as described in the next section. Wildcards Each part of the name can be a wildcard symbol described in fnmatch(3): • * — matches zero or more characters • ? — matches one character • [a-z] PartitionNameList | ( �→ KeyOrIndex IfExists | 'CHECK' ) Identifier | 'FOREIGN' 'KEY' IfExists �→ Symbol ) | 'EXCHANGE' 'PARTITION' Identifier 'WITH' 'TABLE' TableName �→ WithValidationOpt | ( 'IMPORT' PartitionNameList | ( �→ KeyOrIndex IfExists | 'CHECK' ) Identifier | 'FOREIGN' 'KEY' IfExists �→ Symbol ) | 'EXCHANGE' 'PARTITION' Identifier 'WITH' 'TABLE' TableName �→ WithValidationOpt 1595 | ( 'IMPORT'

special meanings, as described in the next section. Wildcards Each part of the name can be a wildcard symbol described in fnmatch(3): • * — matches zero or more characters • ? — matches one character • [a-z] PartitionNameList | ( �→ KeyOrIndex IfExists | 'CHECK' ) Identifier | 'FOREIGN' 'KEY' IfExists �→ Symbol ) | 'EXCHANGE' 'PARTITION' Identifier 'WITH' 'TABLE' TableName �→ WithValidationOpt | ( 'IMPORT' PartitionNameList | ( �→ KeyOrIndex IfExists | 'CHECK' ) Identifier | 'FOREIGN' 'KEY' IfExists �→ Symbol ) | 'EXCHANGE' 'PARTITION' Identifier 'WITH' 'TABLE' TableName �→ WithValidationOpt | ( 'IMPORT'

special meanings, as described in the next section. Wildcards Each part of the name can be a wildcard symbol described in fnmatch(3): • * — matches zero or more characters • ? — matches one character • [a-z] PartitionNameList | ( �→ KeyOrIndex IfExists | 'CHECK' ) Identifier | 'FOREIGN' 'KEY' IfExists �→ Symbol ) | 'EXCHANGE' 'PARTITION' Identifier 'WITH' 'TABLE' TableName �→ WithValidationOpt | ( 'IMPORT' PartitionNameList | ( �→ KeyOrIndex IfExists | 'CHECK' ) Identifier | 'FOREIGN' 'KEY' IfExists �→ Symbol ) | 'EXCHANGE' 'PARTITION' Identifier 'WITH' 'TABLE' TableName �→ WithValidationOpt 1656 | ( 'IMPORT'

special meanings, as described in the next section. Wildcards Each part of the name can be a wildcard symbol described in fnmatch(3): • * — matches zero or more characters • ? — matches one character • [a-z] PartitionNameList | ( 2299 �→ KeyOrIndex IfExists | 'CHECK' ) Identifier | 'FOREIGN' 'KEY' IfExists �→ Symbol ) | 'EXCHANGE' 'PARTITION' Identifier 'WITH' 'TABLE' TableName �→ WithValidationOpt | ( 'IMPORT' 'SECONDARY_UNLOAD' Constraint ::= ConstraintKeywordOpt ConstraintElem ConstraintKeywordOpt ::= ( 'CONSTRAINT' Symbol? )? ConstraintElem ::= ( ( 'PRIMARY' 'KEY' | KeyOrIndex IfNotExists | 'UNIQUE' KeyOrIndexOpt )

IfExists PartitionNameList | ( KeyOrIndex IfExists | 'CHECK' ) Identifier | ' �→ FOREIGN' 'KEY' IfExists Symbol ) | 'EXCHANGE' 'PARTITION' Identifier 'WITH' 'TABLE' TableName WithValidationOpt | ( 'IMPORT' | IfExists PartitionNameList | ( KeyOrIndex IfExists | 'CHECK' ) Identifier | ' �→ FOREIGN' 'KEY' IfExists Symbol ) | 'EXCHANGE' 'PARTITION' Identifier 'WITH' 'TABLE' TableName WithValidationOpt | ( 'IMPORT' | 'SECONDARY_UNLOAD' Constraint ::= ConstraintKeywordOpt ConstraintElem ConstraintKeywordOpt ::= ( 'CONSTRAINT' Symbol? )? ConstraintElem ::= ( ( 'PRIMARY' 'KEY' | KeyOrIndex IfNotExists | 'UNIQUE' KeyOrIndexOpt )

IfExists PartitionNameList | ( KeyOrIndex IfExists | 'CHECK' ) Identifier | ' �→ FOREIGN' 'KEY' IfExists Symbol ) | 'EXCHANGE' 'PARTITION' Identifier 'WITH' 'TABLE' TableName WithValidationOpt | ( 'IMPORT' | IfExists PartitionNameList | ( KeyOrIndex IfExists | 'CHECK' ) Identifier | ' �→ FOREIGN' 'KEY' IfExists Symbol ) | 'EXCHANGE' 'PARTITION' Identifier 'WITH' 'TABLE' TableName WithValidationOpt | ( 'IMPORT' | 'SECONDARY_UNLOAD' Constraint ::= ConstraintKeywordOpt ConstraintElem ConstraintKeywordOpt ::= ( 'CONSTRAINT' Symbol? )? ConstraintElem ::= 1257 ( ( 'PRIMARY' 'KEY' | KeyOrIndex IfNotExists | 'UNIQUE' KeyOrIndexOpt

IfExists PartitionNameList | ( KeyOrIndex IfExists | 'CHECK' ) Identifier | ' �→ FOREIGN' 'KEY' IfExists Symbol ) | 'EXCHANGE' 'PARTITION' Identifier 'WITH' 'TABLE' TableName WithValidationOpt | ( 'IMPORT' | IfExists PartitionNameList | ( KeyOrIndex IfExists | 'CHECK' ) Identifier | ' �→ FOREIGN' 'KEY' IfExists Symbol ) | 'EXCHANGE' 'PARTITION' Identifier 'WITH' 'TABLE' TableName WithValidationOpt | ( 'IMPORT' | 'SECONDARY_UNLOAD' Constraint ::= ConstraintKeywordOpt ConstraintElem ConstraintKeywordOpt ::= ( 'CONSTRAINT' Symbol? )? ConstraintElem ::= ( ( 'PRIMARY' 'KEY' | KeyOrIndex IfNotExists | 'UNIQUE' KeyOrIndexOpt )

query rules: • ProxySQL tries to match the rules one by one in the ascending order of rule_id. • ^ symbol matches the beginning of a SQL statement and $ matches the end. For more information about ProxySQL However, note the following: • Wildcards including *, ?, and [] are supported. There can only be one * symbol in a wildcard match, and it must be at the end. For example, in table-pattern: "t_*", "t_*" indicates expressions and cannot start with the ~ symbol. • schema-pattern and table-pattern support both wildcards and regular expressions. Regular expressions must begin with the ~ symbol. 13.6.6.5.2 Parameter descriptions

query rules: • ProxySQL tries to match the rules one by one in the ascending order of rule_id. • ^ symbol matches the beginning of a SQL statement and $ matches the end. For more information about ProxySQL However, note the following: • Wildcards including *, ?, and [] are supported. There can only be one * symbol in a wildcard match, and it must be at the end. For example, in table-pattern: "t_*", "t_*" indicates expressions and cannot start with the ~ symbol. • schema-pattern and table-pattern support both wildcards and regular expressions. Regular expressions must begin with the ~ symbol. 13.6.6.5.2 Parameter descriptions