2110 lines
43 KiB
Plaintext
2110 lines
43 KiB
Plaintext
DROP DATABASE IF EXISTS test1;
|
|
CREATE DATABASE test1;
|
|
SELECT *,
|
|
LEFT( table_comment,
|
|
IF(INSTR(table_comment,'TMP_TABLE_ENGINE free') = 0
|
|
AND INSTR(table_comment,'number_of_replicas') = 0,
|
|
LENGTH(table_comment),
|
|
INSTR(table_comment,'TMP_TABLE_ENGINE free')
|
|
+ INSTR(table_comment,'number_of_replicas') - 1))
|
|
AS "user_comment",
|
|
'-----------------------------------------------------' AS "Separator"
|
|
FROM information_schema.tables
|
|
WHERE table_schema = 'information_schema'
|
|
AND table_name COLLATE utf8_general_ci <> 'profiling'
|
|
AND table_name COLLATE utf8_general_ci not like 'innodb_%'
|
|
AND table_name not like 'ndb%'
|
|
ORDER BY table_schema,table_name COLLATE utf8_general_ci;
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ALISQL_CLUSTER_CONSENSUS_MEMBERSHIP_CHANGE
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ALISQL_CLUSTER_CONSENSUS_STATUS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ALISQL_CLUSTER_GLOBAL
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ALISQL_CLUSTER_HEALTH
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ALISQL_CLUSTER_LEARNER_SOURCE
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ALISQL_CLUSTER_LOCAL
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ALISQL_CLUSTER_PREFETCH_CHANNEL
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME CHARACTER_SETS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME CHECK_CONSTRAINTS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME COLLATIONS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME COLLATION_CHARACTER_SET_APPLICABILITY
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME COLUMNS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME COLUMN_PRIVILEGES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME COLUMN_STATISTICS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME CONSENSUS_COMMIT_POSITION
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ENGINES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME EVENTS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME FILES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME INDEX_STATISTICS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME KEYWORDS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME KEY_COLUMN_USAGE
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME OPTIMIZER_TRACE
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME PARAMETERS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME PARTITIONS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME PLUGINS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME PROCESSLIST
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME REFERENTIAL_CONSTRAINTS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME RESOURCE_GROUPS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ROUTINES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME SCHEMATA
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME SCHEMA_PRIVILEGES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME STATISTICS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ST_GEOMETRY_COLUMNS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ST_SPATIAL_REFERENCE_SYSTEMS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ST_UNITS_OF_MEASURE
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME TABLES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME TABLESPACES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME TABLE_CONSTRAINTS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME TABLE_PRIVILEGES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME TABLE_STATISTICS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME TRIGGERS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME USER_PRIVILEGES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME VIEWS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME VIEW_ROUTINE_USAGE
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME VIEW_TABLE_USAGE
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
DROP USER testuser1@localhost;
|
|
CREATE USER testuser1@localhost;
|
|
GRANT SELECT ON test1.* TO testuser1@localhost;
|
|
# Establish connection testuser1 (user=testuser1)
|
|
SELECT *,
|
|
LEFT( table_comment,
|
|
IF(INSTR(table_comment,'TMP_TABLE_ENGINE free') = 0
|
|
AND INSTR(table_comment,'number_of_replicas') = 0,
|
|
LENGTH(table_comment),
|
|
INSTR(table_comment,'TMP_TABLE_ENGINE free')
|
|
+ INSTR(table_comment,'number_of_replicas') - 1))
|
|
AS "user_comment",
|
|
'-----------------------------------------------------' AS "Separator"
|
|
FROM information_schema.tables
|
|
WHERE table_schema = 'information_schema'
|
|
AND table_name COLLATE utf8_general_ci <> 'profiling'
|
|
AND table_name COLLATE utf8_general_ci not like 'innodb_%'
|
|
AND table_name not like 'ndb%'
|
|
ORDER BY table_schema,table_name COLLATE utf8_general_ci;
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ALISQL_CLUSTER_CONSENSUS_MEMBERSHIP_CHANGE
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ALISQL_CLUSTER_CONSENSUS_STATUS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ALISQL_CLUSTER_GLOBAL
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ALISQL_CLUSTER_HEALTH
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ALISQL_CLUSTER_LEARNER_SOURCE
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ALISQL_CLUSTER_LOCAL
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ALISQL_CLUSTER_PREFETCH_CHANNEL
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME CHARACTER_SETS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME CHECK_CONSTRAINTS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME COLLATIONS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME COLLATION_CHARACTER_SET_APPLICABILITY
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME COLUMNS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME COLUMN_PRIVILEGES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME COLUMN_STATISTICS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME CONSENSUS_COMMIT_POSITION
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ENGINES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME EVENTS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME FILES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME INDEX_STATISTICS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME KEYWORDS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME KEY_COLUMN_USAGE
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME OPTIMIZER_TRACE
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME PARAMETERS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME PARTITIONS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME PLUGINS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME PROCESSLIST
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME REFERENTIAL_CONSTRAINTS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME RESOURCE_GROUPS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ROUTINES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME SCHEMATA
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME SCHEMA_PRIVILEGES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME STATISTICS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ST_GEOMETRY_COLUMNS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ST_SPATIAL_REFERENCE_SYSTEMS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME ST_UNITS_OF_MEASURE
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME TABLES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME TABLESPACES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME TABLE_CONSTRAINTS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME TABLE_PRIVILEGES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME TABLE_STATISTICS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME TRIGGERS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME USER_PRIVILEGES
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME VIEWS
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME VIEW_ROUTINE_USAGE
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
TABLE_CATALOG def
|
|
TABLE_SCHEMA information_schema
|
|
TABLE_NAME VIEW_TABLE_USAGE
|
|
TABLE_TYPE SYSTEM VIEW
|
|
ENGINE NULL
|
|
VERSION 10
|
|
ROW_FORMAT NULL
|
|
TABLE_ROWS #TBLR#
|
|
AVG_ROW_LENGTH #ARL#
|
|
DATA_LENGTH #DL#
|
|
MAX_DATA_LENGTH #MDL#
|
|
INDEX_LENGTH #IL#
|
|
DATA_FREE #DF#
|
|
AUTO_INCREMENT #AI#
|
|
CREATE_TIME #CRT#
|
|
UPDATE_TIME #UT#
|
|
CHECK_TIME #CT#
|
|
TABLE_COLLATION NULL
|
|
CHECKSUM NULL
|
|
CREATE_OPTIONS #CO#
|
|
TABLE_COMMENT #TC#
|
|
user_comment
|
|
Separator -----------------------------------------------------
|
|
# Switch to connection default and close connection testuser1
|
|
DROP USER testuser1@localhost;
|
|
DROP DATABASE test1;
|