TABLE_CATALOG
varchar(64)
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
TABLE_SCHEMA
varchar(64)
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
def - mysql def - information_schema def - performance_schema def - sys def - phpmyadmin def - fiscco def - nome_do_banco fiscco - def information_schema - def mysql - def nome_do_banco - def performance_schema - def phpmyadmin - def sys - def
TABLE_NAME
varchar(64)
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
PARTITION_NAME
varchar(64)
utf8mb3_tolower_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
SUBPARTITION_NAME
varchar(64)
utf8mb3_tolower_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
PARTITION_ORDINAL_POSITION
int
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
SUBPARTITION_ORDINAL_POSITION
int
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
PARTITION_METHOD
varchar(13)
utf8mb3_general_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
SUBPARTITION_METHOD
varchar(13)
utf8mb3_general_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
PARTITION_EXPRESSION
varchar(2048)
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
SUBPARTITION_EXPRESSION
varchar(2048)
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
PARTITION_DESCRIPTION
text
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
TABLE_ROWS
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
AVG_ROW_LENGTH
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
DATA_LENGTH
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
MAX_DATA_LENGTH
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
INDEX_LENGTH
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
DATA_FREE
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
CREATE_TIME
timestamp
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
UPDATE_TIME
datetime
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
CHECK_TIME
datetime
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
CHECKSUM
bigint
= > >= < <= != LIKE LIKE %...% NOT LIKE IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
PARTITION_COMMENT
text
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
NODEGROUP
varchar(256)
utf8mb3_general_ci
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
TABLESPACE_NAME
varchar(268)
utf8mb3_bin
LIKE LIKE %...% NOT LIKE = != REGEXP REGEXP ^...$ NOT REGEXP = '' != '' IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL
