Table: PARTITIONS
[ Up |
Design | Data |
Csv ]
rows=94, start=0, range=20
[ 0-19 | 20-39 | 40-59 | 60-79 | 80-93 ]
| TABLE_CATALOG
| TABLE_SCHEMA
| TABLE_NAME
| PARTITION_NAME
| SUBPARTITION_NAME
| PARTITION_ORDINAL_POSITION
| SUBPARTITION_ORDINAL_POSITION
| PARTITION_METHOD
| SUBPARTITION_METHOD
| PARTITION_EXPRESSION
| SUBPARTITION_EXPRESSION
| PARTITION_DESCRIPTION
| TABLE_ROWS
| AVG_ROW_LENGTH
| DATA_LENGTH
| MAX_DATA_LENGTH
| INDEX_LENGTH
| DATA_FREE
| CREATE_TIME
| UPDATE_TIME
| CHECK_TIME
| CHECKSUM
| PARTITION_COMMENT
| NODEGROUP
| TABLESPACE_NAME
|
0
| def |
information_schema |
ALL_PLUGINS |
|
|
|
|
|
|
|
|
|
0 |
0 |
8192 |
4503599627288576 |
8192 |
0 |
2024-04-25 01:04:57 |
2024-04-25 01:04:57 |
|
|
|
|
|
1
| def |
information_schema |
APPLICABLE_ROLES |
|
|
|
|
|
|
|
|
|
0 |
1565 |
0 |
50330400 |
0 |
0 |
2024-04-25 01:04:57 |
|
|
|
|
|
|
2
| def |
information_schema |
CHARACTER_SETS |
|
|
|
|
|
|
|
|
|
0 |
384 |
0 |
50331648 |
0 |
0 |
2024-04-25 01:04:57 |
|
|
|
|
|
|
3
| def |
information_schema |
CHECK_CONSTRAINTS |
|
|
|
|
|
|
|
|
|
0 |
0 |
8192 |
4503599627288576 |
8192 |
0 |
2024-04-25 01:04:57 |
2024-04-25 01:04:57 |
|
|
|
|
|
4
| def |
information_schema |
COLLATIONS |
|
|
|
|
|
|
|
|
|
0 |
231 |
0 |
50331435 |
0 |
0 |
2024-04-25 01:04:57 |
|
|
|
|
|
|
5
| def |
information_schema |
COLLATION_CHARACTER_SET_APPLICABILITY |
|
|
|
|
|
|
|
|
|
0 |
195 |
0 |
50331645 |
0 |
0 |
2024-04-25 01:04:57 |
|
|
|
|
|
|
6
| def |
information_schema |
COLUMNS |
|
|
|
|
|
|
|
|
|
0 |
0 |
8192 |
4503599627288576 |
8192 |
0 |
2024-04-25 01:04:57 |
2024-04-25 01:04:57 |
|
|
|
|
|
7
| def |
information_schema |
COLUMN_PRIVILEGES |
|
|
|
|
|
|
|
|
|
0 |
3478 |
0 |
50330138 |
0 |
0 |
2024-04-25 01:04:57 |
|
|
|
|
|
|
8
| def |
information_schema |
ENABLED_ROLES |
|
|
|
|
|
|
|
|
|
0 |
388 |
0 |
50331360 |
0 |
0 |
2024-04-25 01:04:57 |
|
|
|
|
|
|
9
| def |
information_schema |
ENGINES |
|
|
|
|
|
|
|
|
|
0 |
732 |
0 |
50331588 |
0 |
0 |
2024-04-25 01:04:57 |
|
|
|
|
|
|
10
| def |
information_schema |
EVENTS |
|
|
|
|
|
|
|
|
|
0 |
0 |
8192 |
4503599627288576 |
8192 |
0 |
2024-04-25 01:04:57 |
2024-04-25 01:04:57 |
|
|
|
|
|
11
| def |
information_schema |
FILES |
|
|
|
|
|
|
|
|
|
0 |
4004 |
0 |
50330280 |
0 |
0 |
2024-04-25 01:04:57 |
|
|
|
|
|
|
12
| def |
information_schema |
GLOBAL_STATUS |
|
|
|
|
|
|
|
|
|
0 |
12484 |
0 |
50323004 |
0 |
0 |
2024-04-25 01:04:57 |
|
|
|
|
|
|
13
| def |
information_schema |
GLOBAL_VARIABLES |
|
|
|
|
|
|
|
|
|
0 |
12484 |
0 |
50323004 |
0 |
0 |
2024-04-25 01:04:57 |
|
|
|
|
|
|
14
| def |
information_schema |
KEYWORDS |
|
|
|
|
|
|
|
|
|
0 |
195 |
0 |
50331645 |
0 |
0 |
2024-04-25 01:04:57 |
|
|
|
|
|
|
15
| def |
information_schema |
KEY_CACHES |
|
|
|
|
|
|
|
|
|
0 |
660 |
0 |
50331600 |
0 |
0 |
2024-04-25 01:04:57 |
|
|
|
|
|
|
16
| def |
information_schema |
KEY_COLUMN_USAGE |
|
|
|
|
|
|
|
|
|
0 |
4638 |
0 |
50331576 |
0 |
0 |
2024-04-25 01:04:57 |
|
|
|
|
|
|
17
| def |
information_schema |
OPTIMIZER_TRACE |
|
|
|
|
|
|
|
|
|
0 |
0 |
8192 |
4503599627288576 |
8192 |
0 |
2024-04-25 01:04:57 |
2024-04-25 01:04:57 |
|
|
|
|
|
18
| def |
information_schema |
PARAMETERS |
|
|
|
|
|
|
|
|
|
0 |
0 |
8192 |
4503599627288576 |
8192 |
0 |
2024-04-25 01:04:57 |
2024-04-25 01:04:57 |
|
|
|
|
|
19
| def |
information_schema |
PARTITIONS |
|
|
|
|
|
|
|
|
|
0 |
0 |
8192 |
4503599627288576 |
8192 |
0 |
2024-04-25 01:04:57 |
2024-04-25 01:04:57 |
|
|
|
|
|
|
[ Delete All ]