| 1 |
SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; |
| 2 |
SELECT * FROM information_schema.columns |
| 3 |
WHERE table_schema = 'information_schema' |
| 4 |
AND table_name <> 'PROFILING' AND table_name not like 'INNODB_%' AND table_name not like 'ndb%' |
| 5 |
ORDER BY table_schema, |
| 6 |
table_name COLLATE utf8_general_ci, |
| 7 |
ordinal_position; |
| 8 |
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT GENERATION_EXPRESSION SRS_ID |
| 9 |
def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS USER 1 NULL YES varchar 97 291 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(97) select NULL |
| 10 |
def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS HOST 2 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 11 |
def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS GRANTEE 3 NULL YES varchar 97 388 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(97) select NULL |
| 12 |
def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS GRANTEE_HOST 4 NULL YES varchar 256 1024 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(256) select NULL |
| 13 |
def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS ROLE_NAME 5 NULL YES varchar 255 1020 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(255) select NULL |
| 14 |
def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS ROLE_HOST 6 NULL YES varchar 256 1024 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(256) select NULL |
| 15 |
def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS IS_GRANTABLE 7 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 16 |
def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS IS_DEFAULT 8 NULL YES varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 17 |
def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS IS_MANDATORY 9 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 18 |
def information_schema APPLICABLE_ROLES USER 1 NULL YES varchar 97 291 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(97) select NULL |
| 19 |
def information_schema APPLICABLE_ROLES HOST 2 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 20 |
def information_schema APPLICABLE_ROLES GRANTEE 3 NULL YES varchar 97 388 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(97) select NULL |
| 21 |
def information_schema APPLICABLE_ROLES GRANTEE_HOST 4 NULL YES varchar 256 1024 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(256) select NULL |
| 22 |
def information_schema APPLICABLE_ROLES ROLE_NAME 5 NULL YES varchar 255 1020 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(255) select NULL |
| 23 |
def information_schema APPLICABLE_ROLES ROLE_HOST 6 NULL YES varchar 256 1024 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(256) select NULL |
| 24 |
def information_schema APPLICABLE_ROLES IS_GRANTABLE 7 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 25 |
def information_schema APPLICABLE_ROLES IS_DEFAULT 8 NULL YES varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 26 |
def information_schema APPLICABLE_ROLES IS_MANDATORY 9 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 27 |
def information_schema CHARACTER_SETS CHARACTER_SET_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 28 |
def information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 29 |
def information_schema CHARACTER_SETS DESCRIPTION 3 NULL NO varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(2048) select NULL |
| 30 |
def information_schema CHARACTER_SETS MAXLEN 4 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 31 |
def information_schema CHECK_CONSTRAINTS CONSTRAINT_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 32 |
def information_schema CHECK_CONSTRAINTS CONSTRAINT_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 33 |
def information_schema CHECK_CONSTRAINTS CONSTRAINT_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 34 |
def information_schema CHECK_CONSTRAINTS CHECK_CLAUSE 4 NULL NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL |
| 35 |
def information_schema COLLATIONS COLLATION_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 36 |
def information_schema COLLATIONS CHARACTER_SET_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 37 |
def information_schema COLLATIONS ID 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 38 |
def information_schema COLLATIONS IS_DEFAULT 4 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 39 |
def information_schema COLLATIONS IS_COMPILED 5 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 40 |
def information_schema COLLATIONS SORTLEN 6 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 41 |
def information_schema COLLATIONS PAD_ATTRIBUTE 7 NULL NO enum 9 27 NULL NULL NULL utf8mb3 utf8mb3_bin enum('PAD SPACE','NO PAD') select NULL |
| 42 |
def information_schema COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 43 |
def information_schema COLLATION_CHARACTER_SET_APPLICABILITY CHARACTER_SET_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 44 |
def information_schema COLUMNS TABLE_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 45 |
def information_schema COLUMNS TABLE_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 46 |
def information_schema COLUMNS TABLE_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 47 |
def information_schema COLUMNS COLUMN_NAME 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 48 |
def information_schema COLUMNS ORDINAL_POSITION 5 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 49 |
def information_schema COLUMNS COLUMN_DEFAULT 6 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL |
| 50 |
def information_schema COLUMNS IS_NULLABLE 7 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 51 |
def information_schema COLUMNS DATA_TYPE 8 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL |
| 52 |
def information_schema COLUMNS CHARACTER_MAXIMUM_LENGTH 9 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 53 |
def information_schema COLUMNS CHARACTER_OCTET_LENGTH 10 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 54 |
def information_schema COLUMNS NUMERIC_PRECISION 11 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 55 |
def information_schema COLUMNS NUMERIC_SCALE 12 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 56 |
def information_schema COLUMNS DATETIME_PRECISION 13 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 57 |
def information_schema COLUMNS CHARACTER_SET_NAME 14 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 58 |
def information_schema COLUMNS COLLATION_NAME 15 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 59 |
def information_schema COLUMNS COLUMN_TYPE 16 NULL NO mediumtext 16777215 16777215 NULL NULL NULL utf8mb3 utf8mb3_bin mediumtext select NULL |
| 60 |
def information_schema COLUMNS COLUMN_KEY 17 NULL NO enum 3 9 NULL NULL NULL utf8mb3 utf8mb3_bin enum('','PRI','UNI','MUL') select NULL |
| 61 |
def information_schema COLUMNS EXTRA 18 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 62 |
def information_schema COLUMNS PRIVILEGES 19 NULL YES varchar 154 462 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(154) select NULL |
| 63 |
def information_schema COLUMNS COLUMN_COMMENT 20 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL |
| 64 |
def information_schema COLUMNS GENERATION_EXPRESSION 21 NULL NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL |
| 65 |
def information_schema COLUMNS SRS_ID 22 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 66 |
def information_schema COLUMNS_EXTENSIONS TABLE_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 67 |
def information_schema COLUMNS_EXTENSIONS TABLE_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 68 |
def information_schema COLUMNS_EXTENSIONS TABLE_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 69 |
def information_schema COLUMNS_EXTENSIONS COLUMN_NAME 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 70 |
def information_schema COLUMNS_EXTENSIONS ENGINE_ATTRIBUTE 5 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL |
| 71 |
def information_schema COLUMNS_EXTENSIONS SECONDARY_ENGINE_ATTRIBUTE 6 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL |
| 72 |
def information_schema COLUMN_PRIVILEGES GRANTEE 1 NO varchar 97 292 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(292) select NULL |
| 73 |
def information_schema COLUMN_PRIVILEGES TABLE_CATALOG 2 NO varchar 170 512 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(512) select NULL |
| 74 |
def information_schema COLUMN_PRIVILEGES TABLE_SCHEMA 3 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 75 |
def information_schema COLUMN_PRIVILEGES TABLE_NAME 4 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 76 |
def information_schema COLUMN_PRIVILEGES COLUMN_NAME 5 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 77 |
def information_schema COLUMN_PRIVILEGES PRIVILEGE_TYPE 6 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 78 |
def information_schema COLUMN_PRIVILEGES IS_GRANTABLE 7 NO varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 79 |
def information_schema COLUMN_STATISTICS SCHEMA_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 80 |
def information_schema COLUMN_STATISTICS TABLE_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 81 |
def information_schema COLUMN_STATISTICS COLUMN_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 82 |
def information_schema COLUMN_STATISTICS HISTOGRAM 4 NULL NO json NULL NULL NULL NULL NULL NULL NULL json select NULL |
| 83 |
def information_schema ENABLED_ROLES ROLE_NAME 1 NULL YES varchar 255 1020 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(255) select NULL |
| 84 |
def information_schema ENABLED_ROLES ROLE_HOST 2 NULL YES varchar 255 1020 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(255) select NULL |
| 85 |
def information_schema ENABLED_ROLES IS_DEFAULT 3 NULL YES varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 86 |
def information_schema ENABLED_ROLES IS_MANDATORY 4 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 87 |
def information_schema ENGINES ENGINE 1 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 88 |
def information_schema ENGINES SUPPORT 2 NO varchar 2 8 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(8) select NULL |
| 89 |
def information_schema ENGINES COMMENT 3 NO varchar 26 80 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(80) select NULL |
| 90 |
def information_schema ENGINES TRANSACTIONS 4 YES varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 91 |
def information_schema ENGINES XA 5 YES varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 92 |
def information_schema ENGINES SAVEPOINTS 6 YES varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 93 |
def information_schema EVENTS EVENT_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 94 |
def information_schema EVENTS EVENT_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 95 |
def information_schema EVENTS EVENT_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 96 |
def information_schema EVENTS DEFINER 4 NULL NO varchar 288 864 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(288) select NULL |
| 97 |
def information_schema EVENTS TIME_ZONE 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL |
| 98 |
def information_schema EVENTS EVENT_BODY 6 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 99 |
def information_schema EVENTS EVENT_DEFINITION 7 NULL NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL |
| 100 |
def information_schema EVENTS EVENT_TYPE 8 NO varchar 9 27 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(9) select NULL |
| 101 |
def information_schema EVENTS EXECUTE_AT 9 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL |
| 102 |
def information_schema EVENTS INTERVAL_VALUE 10 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 103 |
def information_schema EVENTS INTERVAL_FIELD 11 NULL YES enum 18 54 NULL NULL NULL utf8mb3 utf8mb3_bin enum('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','MICROSECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE','HOUR_SECOND','MINUTE_SECOND','DAY_MICROSECOND','HOUR_MICROSECOND','MINUTE_MICROSECOND','SECOND_MICROSECOND') select NULL |
| 104 |
def information_schema EVENTS SQL_MODE 12 NULL NO set 520 1560 NULL NULL NULL utf8mb3 utf8mb3_bin set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12','NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL') select NULL |
| 105 |
def information_schema EVENTS STARTS 13 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL |
| 106 |
def information_schema EVENTS ENDS 14 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL |
| 107 |
def information_schema EVENTS STATUS 15 NULL NO enum 18 54 NULL NULL NULL utf8mb3 utf8mb3_bin enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') select NULL |
| 108 |
def information_schema EVENTS ON_COMPLETION 16 NO varchar 12 36 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(12) select NULL |
| 109 |
def information_schema EVENTS CREATED 17 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL |
| 110 |
def information_schema EVENTS LAST_ALTERED 18 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL |
| 111 |
def information_schema EVENTS LAST_EXECUTED 19 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL |
| 112 |
def information_schema EVENTS EVENT_COMMENT 20 NULL NO varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL |
| 113 |
def information_schema EVENTS ORIGINATOR 21 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 114 |
def information_schema EVENTS CHARACTER_SET_CLIENT 22 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 115 |
def information_schema EVENTS COLLATION_CONNECTION 23 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 116 |
def information_schema EVENTS DATABASE_COLLATION 24 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 117 |
def information_schema FILES FILE_ID 1 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 118 |
def information_schema FILES FILE_NAME 2 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL |
| 119 |
def information_schema FILES FILE_TYPE 3 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 120 |
def information_schema FILES TABLESPACE_NAME 4 NULL NO varchar 268 804 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(268) select NULL |
| 121 |
def information_schema FILES TABLE_CATALOG 5 NO char 0 0 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(0) select NULL |
| 122 |
def information_schema FILES TABLE_SCHEMA 6 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 123 |
def information_schema FILES TABLE_NAME 7 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 124 |
def information_schema FILES LOGFILE_GROUP_NAME 8 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 125 |
def information_schema FILES LOGFILE_GROUP_NUMBER 9 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 126 |
def information_schema FILES ENGINE 10 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 127 |
def information_schema FILES FULLTEXT_KEYS 11 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 128 |
def information_schema FILES DELETED_ROWS 12 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 129 |
def information_schema FILES UPDATE_COUNT 13 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 130 |
def information_schema FILES FREE_EXTENTS 14 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 131 |
def information_schema FILES TOTAL_EXTENTS 15 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 132 |
def information_schema FILES EXTENT_SIZE 16 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 133 |
def information_schema FILES INITIAL_SIZE 17 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 134 |
def information_schema FILES MAXIMUM_SIZE 18 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 135 |
def information_schema FILES AUTOEXTEND_SIZE 19 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 136 |
def information_schema FILES CREATION_TIME 20 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 137 |
def information_schema FILES LAST_UPDATE_TIME 21 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 138 |
def information_schema FILES LAST_ACCESS_TIME 22 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 139 |
def information_schema FILES RECOVER_TIME 23 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 140 |
def information_schema FILES TRANSACTION_COUNTER 24 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 141 |
def information_schema FILES VERSION 25 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 142 |
def information_schema FILES ROW_FORMAT 26 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 143 |
def information_schema FILES TABLE_ROWS 27 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 144 |
def information_schema FILES AVG_ROW_LENGTH 28 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 145 |
def information_schema FILES DATA_LENGTH 29 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 146 |
def information_schema FILES MAX_DATA_LENGTH 30 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 147 |
def information_schema FILES INDEX_LENGTH 31 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 148 |
def information_schema FILES DATA_FREE 32 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 149 |
def information_schema FILES CREATE_TIME 33 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 150 |
def information_schema FILES UPDATE_TIME 34 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 151 |
def information_schema FILES CHECK_TIME 35 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 152 |
def information_schema FILES CHECKSUM 36 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 153 |
def information_schema FILES STATUS 37 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 154 |
def information_schema FILES EXTRA 38 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 155 |
def information_schema KEYWORDS WORD 1 NULL YES varchar 128 512 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(128) select NULL |
| 156 |
def information_schema KEYWORDS RESERVED 2 NULL YES int NULL NULL 10 0 NULL NULL NULL int select NULL |
| 157 |
def information_schema KEY_COLUMN_USAGE CONSTRAINT_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 158 |
def information_schema KEY_COLUMN_USAGE CONSTRAINT_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 159 |
def information_schema KEY_COLUMN_USAGE CONSTRAINT_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 160 |
def information_schema KEY_COLUMN_USAGE TABLE_CATALOG 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 161 |
def information_schema KEY_COLUMN_USAGE TABLE_SCHEMA 5 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 162 |
def information_schema KEY_COLUMN_USAGE TABLE_NAME 6 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 163 |
def information_schema KEY_COLUMN_USAGE COLUMN_NAME 7 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 164 |
def information_schema KEY_COLUMN_USAGE ORDINAL_POSITION 8 0 NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 165 |
def information_schema KEY_COLUMN_USAGE POSITION_IN_UNIQUE_CONSTRAINT 9 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 166 |
def information_schema KEY_COLUMN_USAGE REFERENCED_TABLE_SCHEMA 10 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 167 |
def information_schema KEY_COLUMN_USAGE REFERENCED_TABLE_NAME 11 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 168 |
def information_schema KEY_COLUMN_USAGE REFERENCED_COLUMN_NAME 12 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 169 |
def information_schema OPTIMIZER_TRACE QUERY 1 NO varchar 21845 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(65535) select NULL |
| 170 |
def information_schema OPTIMIZER_TRACE TRACE 2 NO varchar 21845 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(65535) select NULL |
| 171 |
def information_schema OPTIMIZER_TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE 3 NO int NULL NULL NULL NULL NULL NULL NULL int select NULL |
| 172 |
def information_schema OPTIMIZER_TRACE INSUFFICIENT_PRIVILEGES 4 NO tinyint NULL NULL NULL NULL NULL NULL NULL tinyint(1) select NULL |
| 173 |
def information_schema PARAMETERS SPECIFIC_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 174 |
def information_schema PARAMETERS SPECIFIC_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 175 |
def information_schema PARAMETERS SPECIFIC_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 176 |
def information_schema PARAMETERS ORDINAL_POSITION 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 177 |
def information_schema PARAMETERS PARAMETER_MODE 5 NULL YES varchar 5 15 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(5) select NULL |
| 178 |
def information_schema PARAMETERS PARAMETER_NAME 6 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 179 |
def information_schema PARAMETERS DATA_TYPE 7 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL |
| 180 |
def information_schema PARAMETERS CHARACTER_MAXIMUM_LENGTH 8 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 181 |
def information_schema PARAMETERS CHARACTER_OCTET_LENGTH 9 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 182 |
def information_schema PARAMETERS NUMERIC_PRECISION 10 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 183 |
def information_schema PARAMETERS NUMERIC_SCALE 11 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 184 |
def information_schema PARAMETERS DATETIME_PRECISION 12 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 185 |
def information_schema PARAMETERS CHARACTER_SET_NAME 13 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 186 |
def information_schema PARAMETERS COLLATION_NAME 14 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 187 |
def information_schema PARAMETERS DTD_IDENTIFIER 15 NULL NO mediumtext 16777215 16777215 NULL NULL NULL utf8mb3 utf8mb3_bin mediumtext select NULL |
| 188 |
def information_schema PARAMETERS ROUTINE_TYPE 16 NULL NO enum 9 27 NULL NULL NULL utf8mb3 utf8mb3_bin enum('FUNCTION','PROCEDURE') select NULL |
| 189 |
def information_schema PARTITIONS TABLE_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 190 |
def information_schema PARTITIONS TABLE_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 191 |
def information_schema PARTITIONS TABLE_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 192 |
def information_schema PARTITIONS PARTITION_NAME 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 193 |
def information_schema PARTITIONS SUBPARTITION_NAME 5 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 194 |
def information_schema PARTITIONS PARTITION_ORDINAL_POSITION 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 195 |
def information_schema PARTITIONS SUBPARTITION_ORDINAL_POSITION 7 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 196 |
def information_schema PARTITIONS PARTITION_METHOD 8 NULL YES varchar 13 39 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(13) select NULL |
| 197 |
def information_schema PARTITIONS SUBPARTITION_METHOD 9 NULL YES varchar 13 39 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(13) select NULL |
| 198 |
def information_schema PARTITIONS PARTITION_EXPRESSION 10 NULL YES varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL |
| 199 |
def information_schema PARTITIONS SUBPARTITION_EXPRESSION 11 NULL YES varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL |
| 200 |
def information_schema PARTITIONS PARTITION_DESCRIPTION 12 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL |
| 201 |
def information_schema PARTITIONS TABLE_ROWS 13 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 202 |
def information_schema PARTITIONS AVG_ROW_LENGTH 14 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 203 |
def information_schema PARTITIONS DATA_LENGTH 15 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 204 |
def information_schema PARTITIONS MAX_DATA_LENGTH 16 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 205 |
def information_schema PARTITIONS INDEX_LENGTH 17 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 206 |
def information_schema PARTITIONS DATA_FREE 18 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 207 |
def information_schema PARTITIONS CREATE_TIME 19 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL |
| 208 |
def information_schema PARTITIONS UPDATE_TIME 20 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL |
| 209 |
def information_schema PARTITIONS CHECK_TIME 21 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL |
| 210 |
def information_schema PARTITIONS CHECKSUM 22 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 211 |
def information_schema PARTITIONS PARTITION_COMMENT 23 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL |
| 212 |
def information_schema PARTITIONS NODEGROUP 24 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 213 |
def information_schema PARTITIONS TABLESPACE_NAME 25 NULL YES varchar 268 804 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(268) select NULL |
| 214 |
def information_schema PLUGINS PLUGIN_NAME 1 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 215 |
def information_schema PLUGINS PLUGIN_VERSION 2 NO varchar 6 20 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(20) select NULL |
| 216 |
def information_schema PLUGINS PLUGIN_STATUS 3 NO varchar 3 10 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(10) select NULL |
| 217 |
def information_schema PLUGINS PLUGIN_TYPE 4 NO varchar 26 80 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(80) select NULL |
| 218 |
def information_schema PLUGINS PLUGIN_TYPE_VERSION 5 NO varchar 6 20 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(20) select NULL |
| 219 |
def information_schema PLUGINS PLUGIN_LIBRARY 6 YES varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 220 |
def information_schema PLUGINS PLUGIN_LIBRARY_VERSION 7 YES varchar 6 20 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(20) select NULL |
| 221 |
def information_schema PLUGINS PLUGIN_AUTHOR 8 YES varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 222 |
def information_schema PLUGINS PLUGIN_DESCRIPTION 9 YES varchar 21845 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(65535) select NULL |
| 223 |
def information_schema PLUGINS PLUGIN_LICENSE 10 YES varchar 26 80 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(80) select NULL |
| 224 |
def information_schema PLUGINS LOAD_OPTION 11 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 225 |
def information_schema PROCESSLIST ID 1 NO bigint NULL NULL NULL NULL NULL NULL NULL bigint unsigned select NULL |
| 226 |
def information_schema PROCESSLIST USER 2 NO varchar 10 32 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(32) select NULL |
| 227 |
def information_schema PROCESSLIST HOST 3 NO varchar 87 261 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(261) select NULL |
| 228 |
def information_schema PROCESSLIST DB 4 YES varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 229 |
def information_schema PROCESSLIST COMMAND 5 NO varchar 5 16 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(16) select NULL |
| 230 |
def information_schema PROCESSLIST TIME 6 NO int NULL NULL NULL NULL NULL NULL NULL int select NULL |
| 231 |
def information_schema PROCESSLIST STATE 7 YES varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 232 |
def information_schema PROCESSLIST INFO 8 YES varchar 21845 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(65535) select NULL |
| 233 |
def information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 234 |
def information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 235 |
def information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 236 |
def information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_CATALOG 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 237 |
def information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_SCHEMA 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 238 |
def information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_NAME 6 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 239 |
def information_schema REFERENTIAL_CONSTRAINTS MATCH_OPTION 7 NULL NO enum 7 21 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NONE','PARTIAL','FULL') select NULL |
| 240 |
def information_schema REFERENTIAL_CONSTRAINTS UPDATE_RULE 8 NULL NO enum 11 33 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NO ACTION','RESTRICT','CASCADE','SET NULL','SET DEFAULT') select NULL |
| 241 |
def information_schema REFERENTIAL_CONSTRAINTS DELETE_RULE 9 NULL NO enum 11 33 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NO ACTION','RESTRICT','CASCADE','SET NULL','SET DEFAULT') select NULL |
| 242 |
def information_schema REFERENTIAL_CONSTRAINTS TABLE_NAME 10 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 243 |
def information_schema REFERENTIAL_CONSTRAINTS REFERENCED_TABLE_NAME 11 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 244 |
def information_schema RESOURCE_GROUPS RESOURCE_GROUP_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 245 |
def information_schema RESOURCE_GROUPS RESOURCE_GROUP_TYPE 2 NULL NO enum 6 18 NULL NULL NULL utf8mb3 utf8mb3_bin enum('SYSTEM','USER') select NULL |
| 246 |
def information_schema RESOURCE_GROUPS RESOURCE_GROUP_ENABLED 3 NULL NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(1) select NULL |
| 247 |
def information_schema RESOURCE_GROUPS VCPU_IDS 4 NULL YES blob 65535 65535 NULL NULL NULL NULL NULL blob select NULL |
| 248 |
def information_schema RESOURCE_GROUPS THREAD_PRIORITY 5 NULL NO int NULL NULL 10 0 NULL NULL NULL int select NULL |
| 249 |
def information_schema ROLE_COLUMN_GRANTS GRANTOR 1 NULL YES varchar 97 291 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(97) select NULL |
| 250 |
def information_schema ROLE_COLUMN_GRANTS GRANTOR_HOST 2 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 251 |
def information_schema ROLE_COLUMN_GRANTS GRANTEE 3 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) select NULL |
| 252 |
def information_schema ROLE_COLUMN_GRANTS GRANTEE_HOST 4 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) select NULL |
| 253 |
def information_schema ROLE_COLUMN_GRANTS TABLE_CATALOG 5 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 254 |
def information_schema ROLE_COLUMN_GRANTS TABLE_SCHEMA 6 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select NULL |
| 255 |
def information_schema ROLE_COLUMN_GRANTS TABLE_NAME 7 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select NULL |
| 256 |
def information_schema ROLE_COLUMN_GRANTS COLUMN_NAME 8 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select NULL |
| 257 |
def information_schema ROLE_COLUMN_GRANTS PRIVILEGE_TYPE 9 NO set 31 93 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','References') select NULL |
| 258 |
def information_schema ROLE_COLUMN_GRANTS IS_GRANTABLE 10 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 259 |
def information_schema ROLE_ROUTINE_GRANTS GRANTOR 1 NULL YES varchar 97 291 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(97) select NULL |
| 260 |
def information_schema ROLE_ROUTINE_GRANTS GRANTOR_HOST 2 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 261 |
def information_schema ROLE_ROUTINE_GRANTS GRANTEE 3 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) select NULL |
| 262 |
def information_schema ROLE_ROUTINE_GRANTS GRANTEE_HOST 4 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) select NULL |
| 263 |
def information_schema ROLE_ROUTINE_GRANTS SPECIFIC_CATALOG 5 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 264 |
def information_schema ROLE_ROUTINE_GRANTS SPECIFIC_SCHEMA 6 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select NULL |
| 265 |
def information_schema ROLE_ROUTINE_GRANTS SPECIFIC_NAME 7 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) select NULL |
| 266 |
def information_schema ROLE_ROUTINE_GRANTS ROUTINE_CATALOG 8 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 267 |
def information_schema ROLE_ROUTINE_GRANTS ROUTINE_SCHEMA 9 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select NULL |
| 268 |
def information_schema ROLE_ROUTINE_GRANTS ROUTINE_NAME 10 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(64) select NULL |
| 269 |
def information_schema ROLE_ROUTINE_GRANTS PRIVILEGE_TYPE 11 NO set 27 81 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('Execute','Alter Routine','Grant') select NULL |
| 270 |
def information_schema ROLE_ROUTINE_GRANTS IS_GRANTABLE 12 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 271 |
def information_schema ROLE_TABLE_GRANTS GRANTOR 1 NULL YES varchar 97 291 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(97) select NULL |
| 272 |
def information_schema ROLE_TABLE_GRANTS GRANTOR_HOST 2 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 273 |
def information_schema ROLE_TABLE_GRANTS GRANTEE 3 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) select NULL |
| 274 |
def information_schema ROLE_TABLE_GRANTS GRANTEE_HOST 4 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) select NULL |
| 275 |
def information_schema ROLE_TABLE_GRANTS TABLE_CATALOG 5 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 276 |
def information_schema ROLE_TABLE_GRANTS TABLE_SCHEMA 6 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select NULL |
| 277 |
def information_schema ROLE_TABLE_GRANTS TABLE_NAME 7 NO char 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin char(64) select NULL |
| 278 |
def information_schema ROLE_TABLE_GRANTS PRIVILEGE_TYPE 8 NO set 98 294 NULL NULL NULL utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') select NULL |
| 279 |
def information_schema ROLE_TABLE_GRANTS IS_GRANTABLE 9 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 280 |
def information_schema ROUTINES SPECIFIC_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 281 |
def information_schema ROUTINES ROUTINE_CATALOG 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 282 |
def information_schema ROUTINES ROUTINE_SCHEMA 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 283 |
def information_schema ROUTINES ROUTINE_NAME 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 284 |
def information_schema ROUTINES ROUTINE_TYPE 5 NULL NO enum 9 27 NULL NULL NULL utf8mb3 utf8mb3_bin enum('FUNCTION','PROCEDURE') select NULL |
| 285 |
def information_schema ROUTINES DATA_TYPE 6 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL |
| 286 |
def information_schema ROUTINES CHARACTER_MAXIMUM_LENGTH 7 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 287 |
def information_schema ROUTINES CHARACTER_OCTET_LENGTH 8 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 288 |
def information_schema ROUTINES NUMERIC_PRECISION 9 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 289 |
def information_schema ROUTINES NUMERIC_SCALE 10 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 290 |
def information_schema ROUTINES DATETIME_PRECISION 11 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 291 |
def information_schema ROUTINES CHARACTER_SET_NAME 12 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 292 |
def information_schema ROUTINES COLLATION_NAME 13 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 293 |
def information_schema ROUTINES DTD_IDENTIFIER 14 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL |
| 294 |
def information_schema ROUTINES ROUTINE_BODY 15 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 295 |
def information_schema ROUTINES ROUTINE_DEFINITION 16 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL |
| 296 |
def information_schema ROUTINES EXTERNAL_NAME 17 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 297 |
def information_schema ROUTINES EXTERNAL_LANGUAGE 18 SQL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL |
| 298 |
def information_schema ROUTINES PARAMETER_STYLE 19 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 299 |
def information_schema ROUTINES IS_DETERMINISTIC 20 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 300 |
def information_schema ROUTINES SQL_DATA_ACCESS 21 NULL NO enum 17 51 NULL NULL NULL utf8mb3 utf8mb3_bin enum('CONTAINS SQL','NO SQL','READS SQL DATA','MODIFIES SQL DATA') select NULL |
| 301 |
def information_schema ROUTINES SQL_PATH 22 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 302 |
def information_schema ROUTINES SECURITY_TYPE 23 NULL NO enum 7 21 NULL NULL NULL utf8mb3 utf8mb3_bin enum('DEFAULT','INVOKER','DEFINER') select NULL |
| 303 |
def information_schema ROUTINES CREATED 24 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL |
| 304 |
def information_schema ROUTINES LAST_ALTERED 25 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL |
| 305 |
def information_schema ROUTINES SQL_MODE 26 NULL NO set 520 1560 NULL NULL NULL utf8mb3 utf8mb3_bin set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12','NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL') select NULL |
| 306 |
def information_schema ROUTINES ROUTINE_COMMENT 27 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL |
| 307 |
def information_schema ROUTINES DEFINER 28 NULL NO varchar 288 864 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(288) select NULL |
| 308 |
def information_schema ROUTINES CHARACTER_SET_CLIENT 29 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 309 |
def information_schema ROUTINES COLLATION_CONNECTION 30 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 310 |
def information_schema ROUTINES DATABASE_COLLATION 31 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 311 |
def information_schema SCHEMATA CATALOG_NAME 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 312 |
def information_schema SCHEMATA SCHEMA_NAME 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 313 |
def information_schema SCHEMATA DEFAULT_CHARACTER_SET_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 314 |
def information_schema SCHEMATA DEFAULT_COLLATION_NAME 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 315 |
def information_schema SCHEMATA SQL_PATH 5 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 316 |
def information_schema SCHEMATA DEFAULT_ENCRYPTION 6 NULL NO enum 3 9 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NO','YES') select NULL |
| 317 |
def information_schema SCHEMATA_EXTENSIONS CATALOG_NAME 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 318 |
def information_schema SCHEMATA_EXTENSIONS SCHEMA_NAME 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 319 |
def information_schema SCHEMATA_EXTENSIONS OPTIONS 3 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 320 |
def information_schema SCHEMA_PRIVILEGES GRANTEE 1 NO varchar 97 292 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(292) select NULL |
| 321 |
def information_schema SCHEMA_PRIVILEGES TABLE_CATALOG 2 NO varchar 170 512 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(512) select NULL |
| 322 |
def information_schema SCHEMA_PRIVILEGES TABLE_SCHEMA 3 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 323 |
def information_schema SCHEMA_PRIVILEGES PRIVILEGE_TYPE 4 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 324 |
def information_schema SCHEMA_PRIVILEGES IS_GRANTABLE 5 NO varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 325 |
def information_schema STATISTICS TABLE_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 326 |
def information_schema STATISTICS TABLE_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 327 |
def information_schema STATISTICS TABLE_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 328 |
def information_schema STATISTICS NON_UNIQUE 4 0 NO int NULL NULL 10 0 NULL NULL NULL int select NULL |
| 329 |
def information_schema STATISTICS INDEX_SCHEMA 5 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 330 |
def information_schema STATISTICS INDEX_NAME 6 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 331 |
def information_schema STATISTICS SEQ_IN_INDEX 7 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 332 |
def information_schema STATISTICS COLUMN_NAME 8 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 333 |
def information_schema STATISTICS COLLATION 9 NULL YES varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(1) select NULL |
| 334 |
def information_schema STATISTICS CARDINALITY 10 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 335 |
def information_schema STATISTICS SUB_PART 11 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 336 |
def information_schema STATISTICS PACKED 12 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 337 |
def information_schema STATISTICS NULLABLE 13 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 338 |
def information_schema STATISTICS INDEX_TYPE 14 NO varchar 11 33 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(11) select NULL |
| 339 |
def information_schema STATISTICS COMMENT 15 NO varchar 8 24 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(8) select NULL |
| 340 |
def information_schema STATISTICS INDEX_COMMENT 16 NULL NO varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL |
| 341 |
def information_schema STATISTICS IS_VISIBLE 17 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 342 |
def information_schema STATISTICS EXPRESSION 18 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL |
| 343 |
def information_schema ST_GEOMETRY_COLUMNS TABLE_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 344 |
def information_schema ST_GEOMETRY_COLUMNS TABLE_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 345 |
def information_schema ST_GEOMETRY_COLUMNS TABLE_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 346 |
def information_schema ST_GEOMETRY_COLUMNS COLUMN_NAME 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 347 |
def information_schema ST_GEOMETRY_COLUMNS SRS_NAME 5 NULL YES varchar 80 240 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(80) select NULL |
| 348 |
def information_schema ST_GEOMETRY_COLUMNS SRS_ID 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 349 |
def information_schema ST_GEOMETRY_COLUMNS GEOMETRY_TYPE_NAME 7 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL |
| 350 |
def information_schema ST_SPATIAL_REFERENCE_SYSTEMS SRS_NAME 1 NULL NO varchar 80 240 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(80) select NULL |
| 351 |
def information_schema ST_SPATIAL_REFERENCE_SYSTEMS SRS_ID 2 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 352 |
def information_schema ST_SPATIAL_REFERENCE_SYSTEMS ORGANIZATION 3 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 353 |
def information_schema ST_SPATIAL_REFERENCE_SYSTEMS ORGANIZATION_COORDSYS_ID 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 354 |
def information_schema ST_SPATIAL_REFERENCE_SYSTEMS DEFINITION 5 NULL NO varchar 4096 12288 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(4096) select NULL |
| 355 |
def information_schema ST_SPATIAL_REFERENCE_SYSTEMS DESCRIPTION 6 NULL YES varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL |
| 356 |
def information_schema ST_UNITS_OF_MEASURE UNIT_NAME 1 NULL YES varchar 255 1020 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(255) select NULL |
| 357 |
def information_schema ST_UNITS_OF_MEASURE UNIT_TYPE 2 NULL YES varchar 7 28 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(7) select NULL |
| 358 |
def information_schema ST_UNITS_OF_MEASURE CONVERSION_FACTOR 3 NULL YES double NULL NULL 22 NULL NULL NULL NULL double select NULL |
| 359 |
def information_schema ST_UNITS_OF_MEASURE DESCRIPTION 4 NULL YES varchar 255 1020 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(255) select NULL |
| 360 |
def information_schema TABLES TABLE_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 361 |
def information_schema TABLES TABLE_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 362 |
def information_schema TABLES TABLE_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 363 |
def information_schema TABLES TABLE_TYPE 4 NULL NO enum 11 33 NULL NULL NULL utf8mb3 utf8mb3_bin enum('BASE TABLE','VIEW','SYSTEM VIEW') select NULL |
| 364 |
def information_schema TABLES ENGINE 5 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 365 |
def information_schema TABLES VERSION 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int select NULL |
| 366 |
def information_schema TABLES ROW_FORMAT 7 NULL YES enum 10 30 NULL NULL NULL utf8mb3 utf8mb3_bin enum('Fixed','Dynamic','Compressed','Redundant','Compact','Paged') select NULL |
| 367 |
def information_schema TABLES TABLE_ROWS 8 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 368 |
def information_schema TABLES AVG_ROW_LENGTH 9 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 369 |
def information_schema TABLES DATA_LENGTH 10 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 370 |
def information_schema TABLES MAX_DATA_LENGTH 11 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 371 |
def information_schema TABLES INDEX_LENGTH 12 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 372 |
def information_schema TABLES DATA_FREE 13 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 373 |
def information_schema TABLES AUTO_INCREMENT 14 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL |
| 374 |
def information_schema TABLES CREATE_TIME 15 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL |
| 375 |
def information_schema TABLES UPDATE_TIME 16 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL |
| 376 |
def information_schema TABLES CHECK_TIME 17 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL |
| 377 |
def information_schema TABLES TABLE_COLLATION 18 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 378 |
def information_schema TABLES CHECKSUM 19 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL |
| 379 |
def information_schema TABLES CREATE_OPTIONS 20 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL |
| 380 |
def information_schema TABLES TABLE_COMMENT 21 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_general_ci text select NULL |
| 381 |
def information_schema TABLESPACES TABLESPACE_NAME 1 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 382 |
def information_schema TABLESPACES ENGINE 2 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 383 |
def information_schema TABLESPACES TABLESPACE_TYPE 3 YES varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 384 |
def information_schema TABLESPACES LOGFILE_GROUP_NAME 4 YES varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 385 |
def information_schema TABLESPACES EXTENT_SIZE 5 YES bigint NULL NULL NULL NULL NULL NULL NULL bigint unsigned select NULL |
| 386 |
def information_schema TABLESPACES AUTOEXTEND_SIZE 6 YES bigint NULL NULL NULL NULL NULL NULL NULL bigint unsigned select NULL |
| 387 |
def information_schema TABLESPACES MAXIMUM_SIZE 7 YES bigint NULL NULL NULL NULL NULL NULL NULL bigint unsigned select NULL |
| 388 |
def information_schema TABLESPACES NODEGROUP_ID 8 YES bigint NULL NULL NULL NULL NULL NULL NULL bigint unsigned select NULL |
| 389 |
def information_schema TABLESPACES TABLESPACE_COMMENT 9 YES varchar 682 2048 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(2048) select NULL |
| 390 |
def information_schema TABLESPACES_EXTENSIONS TABLESPACE_NAME 1 NULL NO varchar 268 804 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(268) select NULL |
| 391 |
def information_schema TABLESPACES_EXTENSIONS ENGINE_ATTRIBUTE 2 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL |
| 392 |
def information_schema TABLES_EXTENSIONS TABLE_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 393 |
def information_schema TABLES_EXTENSIONS TABLE_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 394 |
def information_schema TABLES_EXTENSIONS TABLE_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 395 |
def information_schema TABLES_EXTENSIONS ENGINE_ATTRIBUTE 4 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL |
| 396 |
def information_schema TABLES_EXTENSIONS SECONDARY_ENGINE_ATTRIBUTE 5 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL |
| 397 |
def information_schema TABLE_CONSTRAINTS CONSTRAINT_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 398 |
def information_schema TABLE_CONSTRAINTS CONSTRAINT_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 399 |
def information_schema TABLE_CONSTRAINTS CONSTRAINT_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 400 |
def information_schema TABLE_CONSTRAINTS TABLE_SCHEMA 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 401 |
def information_schema TABLE_CONSTRAINTS TABLE_NAME 5 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 402 |
def information_schema TABLE_CONSTRAINTS CONSTRAINT_TYPE 6 NO varchar 11 33 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(11) select NULL |
| 403 |
def information_schema TABLE_CONSTRAINTS ENFORCED 7 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(3) select NULL |
| 404 |
def information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 405 |
def information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 406 |
def information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 407 |
def information_schema TABLE_CONSTRAINTS_EXTENSIONS TABLE_NAME 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 408 |
def information_schema TABLE_CONSTRAINTS_EXTENSIONS ENGINE_ATTRIBUTE 5 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL |
| 409 |
def information_schema TABLE_CONSTRAINTS_EXTENSIONS SECONDARY_ENGINE_ATTRIBUTE 6 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL |
| 410 |
def information_schema TABLE_PRIVILEGES GRANTEE 1 NO varchar 97 292 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(292) select NULL |
| 411 |
def information_schema TABLE_PRIVILEGES TABLE_CATALOG 2 NO varchar 170 512 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(512) select NULL |
| 412 |
def information_schema TABLE_PRIVILEGES TABLE_SCHEMA 3 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 413 |
def information_schema TABLE_PRIVILEGES TABLE_NAME 4 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 414 |
def information_schema TABLE_PRIVILEGES PRIVILEGE_TYPE 5 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 415 |
def information_schema TABLE_PRIVILEGES IS_GRANTABLE 6 NO varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 416 |
def information_schema TRIGGERS TRIGGER_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 417 |
def information_schema TRIGGERS TRIGGER_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 418 |
def information_schema TRIGGERS TRIGGER_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 419 |
def information_schema TRIGGERS EVENT_MANIPULATION 4 NULL NO enum 6 18 NULL NULL NULL utf8mb3 utf8mb3_bin enum('INSERT','UPDATE','DELETE') select NULL |
| 420 |
def information_schema TRIGGERS EVENT_OBJECT_CATALOG 5 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 421 |
def information_schema TRIGGERS EVENT_OBJECT_SCHEMA 6 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 422 |
def information_schema TRIGGERS EVENT_OBJECT_TABLE 7 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 423 |
def information_schema TRIGGERS ACTION_ORDER 8 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL |
| 424 |
def information_schema TRIGGERS ACTION_CONDITION 9 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 425 |
def information_schema TRIGGERS ACTION_STATEMENT 10 NULL NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL |
| 426 |
def information_schema TRIGGERS ACTION_ORIENTATION 11 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 427 |
def information_schema TRIGGERS ACTION_TIMING 12 NULL NO enum 6 18 NULL NULL NULL utf8mb3 utf8mb3_bin enum('BEFORE','AFTER') select NULL |
| 428 |
def information_schema TRIGGERS ACTION_REFERENCE_OLD_TABLE 13 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 429 |
def information_schema TRIGGERS ACTION_REFERENCE_NEW_TABLE 14 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL |
| 430 |
def information_schema TRIGGERS ACTION_REFERENCE_OLD_ROW 15 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 431 |
def information_schema TRIGGERS ACTION_REFERENCE_NEW_ROW 16 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 432 |
def information_schema TRIGGERS CREATED 17 NULL NO timestamp NULL NULL NULL NULL 2 NULL NULL timestamp(2) select NULL |
| 433 |
def information_schema TRIGGERS SQL_MODE 18 NULL NO set 520 1560 NULL NULL NULL utf8mb3 utf8mb3_bin set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12','NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL') select NULL |
| 434 |
def information_schema TRIGGERS DEFINER 19 NULL NO varchar 288 864 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(288) select NULL |
| 435 |
def information_schema TRIGGERS CHARACTER_SET_CLIENT 20 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 436 |
def information_schema TRIGGERS COLLATION_CONNECTION 21 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 437 |
def information_schema TRIGGERS DATABASE_COLLATION 22 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 438 |
def information_schema USER_ATTRIBUTES USER 1 NO char 32 96 NULL NULL NULL utf8mb3 utf8mb3_bin char(32) select NULL |
| 439 |
def information_schema USER_ATTRIBUTES HOST 2 NO char 255 255 NULL NULL NULL ascii ascii_general_ci char(255) select NULL |
| 440 |
def information_schema USER_ATTRIBUTES ATTRIBUTE 3 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb4 utf8mb4_bin longtext select NULL |
| 441 |
def information_schema USER_PRIVILEGES GRANTEE 1 NO varchar 97 292 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(292) select NULL |
| 442 |
def information_schema USER_PRIVILEGES TABLE_CATALOG 2 NO varchar 170 512 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(512) select NULL |
| 443 |
def information_schema USER_PRIVILEGES PRIVILEGE_TYPE 3 NO varchar 21 64 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 444 |
def information_schema USER_PRIVILEGES IS_GRANTABLE 4 NO varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL |
| 445 |
def information_schema VIEWS TABLE_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 446 |
def information_schema VIEWS TABLE_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 447 |
def information_schema VIEWS TABLE_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 448 |
def information_schema VIEWS VIEW_DEFINITION 4 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL |
| 449 |
def information_schema VIEWS CHECK_OPTION 5 NULL YES enum 8 24 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NONE','LOCAL','CASCADED') select NULL |
| 450 |
def information_schema VIEWS IS_UPDATABLE 6 NULL YES enum 3 9 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NO','YES') select NULL |
| 451 |
def information_schema VIEWS DEFINER 7 NULL YES varchar 288 864 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(288) select NULL |
| 452 |
def information_schema VIEWS SECURITY_TYPE 8 NULL YES varchar 7 21 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(7) select NULL |
| 453 |
def information_schema VIEWS CHARACTER_SET_CLIENT 9 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 454 |
def information_schema VIEWS COLLATION_CONNECTION 10 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 455 |
def information_schema VIEW_ROUTINE_USAGE TABLE_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 456 |
def information_schema VIEW_ROUTINE_USAGE TABLE_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 457 |
def information_schema VIEW_ROUTINE_USAGE TABLE_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 458 |
def information_schema VIEW_ROUTINE_USAGE SPECIFIC_CATALOG 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 459 |
def information_schema VIEW_ROUTINE_USAGE SPECIFIC_SCHEMA 5 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 460 |
def information_schema VIEW_ROUTINE_USAGE SPECIFIC_NAME 6 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL |
| 461 |
def information_schema VIEW_TABLE_USAGE VIEW_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 462 |
def information_schema VIEW_TABLE_USAGE VIEW_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 463 |
def information_schema VIEW_TABLE_USAGE VIEW_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 464 |
def information_schema VIEW_TABLE_USAGE TABLE_CATALOG 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 465 |
def information_schema VIEW_TABLE_USAGE TABLE_SCHEMA 5 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 466 |
def information_schema VIEW_TABLE_USAGE TABLE_NAME 6 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8_bin varchar(64) select NULL |
| 467 |
########################################################################## |
| 468 |
# Show the quotient of CHARACTER_OCTET_LENGTH and CHARACTER_MAXIMUM_LENGTH |
| 469 |
########################################################################## |
| 470 |
SELECT DISTINCT |
| 471 |
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 472 |
DATA_TYPE, |
| 473 |
CHARACTER_SET_NAME, |
| 474 |
COLLATION_NAME |
| 475 |
FROM information_schema.columns |
| 476 |
WHERE table_schema = 'information_schema' |
| 477 |
AND table_name <> 'PROFILING' AND table_name not like 'INNODB_%' AND table_name not like 'ndb%' |
| 478 |
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH = 1 |
| 479 |
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE; |
| 480 |
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME |
| 481 |
1.0000 blob NULL NULL |
| 482 |
1.0000 char ascii ascii_general_ci |
| 483 |
1.0000 longtext utf8mb3 utf8mb3_bin |
| 484 |
1.0000 mediumtext utf8mb3 utf8mb3_bin |
| 485 |
1.0000 text utf8mb3 utf8mb3_bin |
| 486 |
1.0000 text utf8mb3 utf8mb3_general_ci |
| 487 |
1.0000 longtext utf8mb4 utf8mb4_bin |
| 488 |
SELECT DISTINCT |
| 489 |
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 490 |
DATA_TYPE, |
| 491 |
CHARACTER_SET_NAME, |
| 492 |
COLLATION_NAME |
| 493 |
FROM information_schema.columns |
| 494 |
WHERE table_schema = 'information_schema' |
| 495 |
AND table_name <> 'PROFILING' AND table_name not like 'INNODB_%' AND table_name not like 'ndb%' |
| 496 |
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH <> 1 |
| 497 |
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE; |
| 498 |
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME |
| 499 |
3.0000 char utf8mb3 utf8mb3_bin |
| 500 |
3.0000 enum utf8mb3 utf8mb3_bin |
| 501 |
3.0000 set utf8mb3 utf8mb3_bin |
| 502 |
3.0000 varchar utf8mb3 utf8mb3_bin |
| 503 |
3.0000 char utf8mb3 utf8mb3_general_ci |
| 504 |
3.0000 set utf8mb3 utf8mb3_general_ci |
| 505 |
3.0000 varchar utf8mb3 utf8mb3_general_ci |
| 506 |
3.0029 varchar utf8mb3 utf8mb3_general_ci |
| 507 |
3.0103 varchar utf8mb3 utf8mb3_general_ci |
| 508 |
3.0118 varchar utf8mb3 utf8mb3_general_ci |
| 509 |
3.0476 varchar utf8mb3 utf8mb3_general_ci |
| 510 |
3.0769 varchar utf8mb3 utf8mb3_general_ci |
| 511 |
3.2000 varchar utf8mb3 utf8mb3_general_ci |
| 512 |
3.3333 varchar utf8mb3 utf8mb3_general_ci |
| 513 |
4.0000 varchar utf8mb3 utf8mb3_general_ci |
| 514 |
3.0000 varchar utf8mb3 utf8mb3_tolower_ci |
| 515 |
4.0000 varchar utf8mb4 utf8mb4_0900_ai_ci |
| 516 |
SELECT DISTINCT |
| 517 |
CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 518 |
DATA_TYPE, |
| 519 |
CHARACTER_SET_NAME, |
| 520 |
COLLATION_NAME |
| 521 |
FROM information_schema.columns |
| 522 |
WHERE table_schema = 'information_schema' |
| 523 |
AND table_name <> 'PROFILING' AND table_name not like 'INNODB_%' AND table_name not like 'ndb%' |
| 524 |
AND CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH IS NULL |
| 525 |
ORDER BY CHARACTER_SET_NAME, COLLATION_NAME, COL_CML, DATA_TYPE; |
| 526 |
COL_CML DATA_TYPE CHARACTER_SET_NAME COLLATION_NAME |
| 527 |
NULL bigint NULL NULL |
| 528 |
NULL binary NULL NULL |
| 529 |
NULL datetime NULL NULL |
| 530 |
NULL double NULL NULL |
| 531 |
NULL int NULL NULL |
| 532 |
NULL json NULL NULL |
| 533 |
NULL timestamp NULL NULL |
| 534 |
NULL tinyint NULL NULL |
| 535 |
NULL char utf8mb3 utf8mb3_general_ci |
| 536 |
--> CHAR(0) is allowed (see manual), and here both CHARACHTER_* values |
| 537 |
--> are 0, which is intended behavior, and the result of 0 / 0 IS NULL |
| 538 |
SELECT CHARACTER_OCTET_LENGTH / CHARACTER_MAXIMUM_LENGTH AS COL_CML, |
| 539 |
TABLE_SCHEMA, |
| 540 |
TABLE_NAME, |
| 541 |
COLUMN_NAME, |
| 542 |
DATA_TYPE, |
| 543 |
CHARACTER_MAXIMUM_LENGTH, |
| 544 |
CHARACTER_OCTET_LENGTH, |
| 545 |
CHARACTER_SET_NAME, |
| 546 |
COLLATION_NAME, |
| 547 |
COLUMN_TYPE |
| 548 |
FROM information_schema.columns |
| 549 |
WHERE table_schema = 'information_schema' |
| 550 |
AND table_name <> 'PROFILING' AND table_name not like 'INNODB_%' AND table_name not like 'ndb%' |
| 551 |
ORDER BY TABLE_SCHEMA, TABLE_NAME COLLATE utf8_general_ci, ORDINAL_POSITION; |
| 552 |
COL_CML TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE |
| 553 |
3.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS USER varchar 97 291 utf8mb3 utf8mb3_general_ci varchar(97) |
| 554 |
3.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS HOST varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 555 |
4.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS GRANTEE varchar 97 388 utf8mb4 utf8mb4_0900_ai_ci varchar(97) |
| 556 |
4.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS GRANTEE_HOST varchar 256 1024 utf8mb4 utf8mb4_0900_ai_ci varchar(256) |
| 557 |
4.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS ROLE_NAME varchar 255 1020 utf8mb4 utf8mb4_0900_ai_ci varchar(255) |
| 558 |
4.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS ROLE_HOST varchar 256 1024 utf8mb4 utf8mb4_0900_ai_ci varchar(256) |
| 559 |
3.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS IS_GRANTABLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 560 |
3.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS IS_DEFAULT varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 561 |
3.0000 information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS IS_MANDATORY varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 562 |
3.0000 information_schema APPLICABLE_ROLES USER varchar 97 291 utf8mb3 utf8mb3_general_ci varchar(97) |
| 563 |
3.0000 information_schema APPLICABLE_ROLES HOST varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 564 |
4.0000 information_schema APPLICABLE_ROLES GRANTEE varchar 97 388 utf8mb4 utf8mb4_0900_ai_ci varchar(97) |
| 565 |
4.0000 information_schema APPLICABLE_ROLES GRANTEE_HOST varchar 256 1024 utf8mb4 utf8mb4_0900_ai_ci varchar(256) |
| 566 |
4.0000 information_schema APPLICABLE_ROLES ROLE_NAME varchar 255 1020 utf8mb4 utf8mb4_0900_ai_ci varchar(255) |
| 567 |
4.0000 information_schema APPLICABLE_ROLES ROLE_HOST varchar 256 1024 utf8mb4 utf8mb4_0900_ai_ci varchar(256) |
| 568 |
3.0000 information_schema APPLICABLE_ROLES IS_GRANTABLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 569 |
3.0000 information_schema APPLICABLE_ROLES IS_DEFAULT varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 570 |
3.0000 information_schema APPLICABLE_ROLES IS_MANDATORY varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 571 |
3.0000 information_schema CHARACTER_SETS CHARACTER_SET_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 572 |
3.0000 information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 573 |
3.0000 information_schema CHARACTER_SETS DESCRIPTION varchar 2048 6144 utf8mb3 utf8mb3_general_ci varchar(2048) |
| 574 |
NULL information_schema CHARACTER_SETS MAXLEN int NULL NULL NULL NULL int unsigned |
| 575 |
3.0000 information_schema CHECK_CONSTRAINTS CONSTRAINT_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 576 |
3.0000 information_schema CHECK_CONSTRAINTS CONSTRAINT_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 577 |
3.0000 information_schema CHECK_CONSTRAINTS CONSTRAINT_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 578 |
1.0000 information_schema CHECK_CONSTRAINTS CHECK_CLAUSE longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext |
| 579 |
3.0000 information_schema COLLATIONS COLLATION_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 580 |
3.0000 information_schema COLLATIONS CHARACTER_SET_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 581 |
NULL information_schema COLLATIONS ID bigint NULL NULL NULL NULL bigint unsigned |
| 582 |
3.0000 information_schema COLLATIONS IS_DEFAULT varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 583 |
3.0000 information_schema COLLATIONS IS_COMPILED varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 584 |
NULL information_schema COLLATIONS SORTLEN int NULL NULL NULL NULL int unsigned |
| 585 |
3.0000 information_schema COLLATIONS PAD_ATTRIBUTE enum 9 27 utf8mb3 utf8mb3_bin enum('PAD SPACE','NO PAD') |
| 586 |
3.0000 information_schema COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 587 |
3.0000 information_schema COLLATION_CHARACTER_SET_APPLICABILITY CHARACTER_SET_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 588 |
3.0000 information_schema COLUMNS TABLE_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 589 |
3.0000 information_schema COLUMNS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 590 |
3.0000 information_schema COLUMNS TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 591 |
3.0000 information_schema COLUMNS COLUMN_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 592 |
NULL information_schema COLUMNS ORDINAL_POSITION int NULL NULL NULL NULL int unsigned |
| 593 |
1.0000 information_schema COLUMNS COLUMN_DEFAULT text 65535 65535 utf8mb3 utf8mb3_bin text |
| 594 |
3.0000 information_schema COLUMNS IS_NULLABLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 595 |
1.0000 information_schema COLUMNS DATA_TYPE longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext |
| 596 |
NULL information_schema COLUMNS CHARACTER_MAXIMUM_LENGTH bigint NULL NULL NULL NULL bigint |
| 597 |
NULL information_schema COLUMNS CHARACTER_OCTET_LENGTH bigint NULL NULL NULL NULL bigint |
| 598 |
NULL information_schema COLUMNS NUMERIC_PRECISION bigint NULL NULL NULL NULL bigint unsigned |
| 599 |
NULL information_schema COLUMNS NUMERIC_SCALE bigint NULL NULL NULL NULL bigint unsigned |
| 600 |
NULL information_schema COLUMNS DATETIME_PRECISION int NULL NULL NULL NULL int unsigned |
| 601 |
3.0000 information_schema COLUMNS CHARACTER_SET_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 602 |
3.0000 information_schema COLUMNS COLLATION_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 603 |
1.0000 information_schema COLUMNS COLUMN_TYPE mediumtext 16777215 16777215 utf8mb3 utf8mb3_bin mediumtext |
| 604 |
3.0000 information_schema COLUMNS COLUMN_KEY enum 3 9 utf8mb3 utf8mb3_bin enum('','PRI','UNI','MUL') |
| 605 |
3.0000 information_schema COLUMNS EXTRA varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 606 |
3.0000 information_schema COLUMNS PRIVILEGES varchar 154 462 utf8mb3 utf8mb3_general_ci varchar(154) |
| 607 |
1.0000 information_schema COLUMNS COLUMN_COMMENT text 65535 65535 utf8mb3 utf8mb3_bin text |
| 608 |
1.0000 information_schema COLUMNS GENERATION_EXPRESSION longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext |
| 609 |
NULL information_schema COLUMNS SRS_ID int NULL NULL NULL NULL int unsigned |
| 610 |
3.0000 information_schema COLUMNS_EXTENSIONS TABLE_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 611 |
3.0000 information_schema COLUMNS_EXTENSIONS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 612 |
3.0000 information_schema COLUMNS_EXTENSIONS TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 613 |
3.0000 information_schema COLUMNS_EXTENSIONS COLUMN_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 614 |
NULL information_schema COLUMNS_EXTENSIONS ENGINE_ATTRIBUTE json NULL NULL NULL NULL json |
| 615 |
NULL information_schema COLUMNS_EXTENSIONS SECONDARY_ENGINE_ATTRIBUTE json NULL NULL NULL NULL json |
| 616 |
3.0103 information_schema COLUMN_PRIVILEGES GRANTEE varchar 97 292 utf8mb3 utf8mb3_general_ci varchar(292) |
| 617 |
3.0118 information_schema COLUMN_PRIVILEGES TABLE_CATALOG varchar 170 512 utf8mb3 utf8mb3_general_ci varchar(512) |
| 618 |
3.0476 information_schema COLUMN_PRIVILEGES TABLE_SCHEMA varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 619 |
3.0476 information_schema COLUMN_PRIVILEGES TABLE_NAME varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 620 |
3.0476 information_schema COLUMN_PRIVILEGES COLUMN_NAME varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 621 |
3.0476 information_schema COLUMN_PRIVILEGES PRIVILEGE_TYPE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 622 |
3.0000 information_schema COLUMN_PRIVILEGES IS_GRANTABLE varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(3) |
| 623 |
3.0000 information_schema COLUMN_STATISTICS SCHEMA_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 624 |
3.0000 information_schema COLUMN_STATISTICS TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 625 |
3.0000 information_schema COLUMN_STATISTICS COLUMN_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 626 |
NULL information_schema COLUMN_STATISTICS HISTOGRAM json NULL NULL NULL NULL json |
| 627 |
4.0000 information_schema ENABLED_ROLES ROLE_NAME varchar 255 1020 utf8mb4 utf8mb4_0900_ai_ci varchar(255) |
| 628 |
4.0000 information_schema ENABLED_ROLES ROLE_HOST varchar 255 1020 utf8mb4 utf8mb4_0900_ai_ci varchar(255) |
| 629 |
3.0000 information_schema ENABLED_ROLES IS_DEFAULT varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 630 |
3.0000 information_schema ENABLED_ROLES IS_MANDATORY varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 631 |
3.0476 information_schema ENGINES ENGINE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 632 |
4.0000 information_schema ENGINES SUPPORT varchar 2 8 utf8mb3 utf8mb3_general_ci varchar(8) |
| 633 |
3.0769 information_schema ENGINES COMMENT varchar 26 80 utf8mb3 utf8mb3_general_ci varchar(80) |
| 634 |
3.0000 information_schema ENGINES TRANSACTIONS varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(3) |
| 635 |
3.0000 information_schema ENGINES XA varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(3) |
| 636 |
3.0000 information_schema ENGINES SAVEPOINTS varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(3) |
| 637 |
3.0000 information_schema EVENTS EVENT_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 638 |
3.0000 information_schema EVENTS EVENT_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 639 |
3.0000 information_schema EVENTS EVENT_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 640 |
3.0000 information_schema EVENTS DEFINER varchar 288 864 utf8mb3 utf8mb3_bin varchar(288) |
| 641 |
3.0000 information_schema EVENTS TIME_ZONE varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 642 |
3.0000 information_schema EVENTS EVENT_BODY varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 643 |
1.0000 information_schema EVENTS EVENT_DEFINITION longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext |
| 644 |
3.0000 information_schema EVENTS EVENT_TYPE varchar 9 27 utf8mb3 utf8mb3_general_ci varchar(9) |
| 645 |
NULL information_schema EVENTS EXECUTE_AT datetime NULL NULL NULL NULL datetime |
| 646 |
3.0000 information_schema EVENTS INTERVAL_VALUE varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 647 |
3.0000 information_schema EVENTS INTERVAL_FIELD enum 18 54 utf8mb3 utf8mb3_bin enum('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','MICROSECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE','HOUR_SECOND','MINUTE_SECOND','DAY_MICROSECOND','HOUR_MICROSECOND','MINUTE_MICROSECOND','SECOND_MICROSECOND') |
| 648 |
3.0000 information_schema EVENTS SQL_MODE set 520 1560 utf8mb3 utf8mb3_bin set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12','NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL') |
| 649 |
NULL information_schema EVENTS STARTS datetime NULL NULL NULL NULL datetime |
| 650 |
NULL information_schema EVENTS ENDS datetime NULL NULL NULL NULL datetime |
| 651 |
3.0000 information_schema EVENTS STATUS enum 18 54 utf8mb3 utf8mb3_bin enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') |
| 652 |
3.0000 information_schema EVENTS ON_COMPLETION varchar 12 36 utf8mb3 utf8mb3_general_ci varchar(12) |
| 653 |
NULL information_schema EVENTS CREATED timestamp NULL NULL NULL NULL timestamp |
| 654 |
NULL information_schema EVENTS LAST_ALTERED timestamp NULL NULL NULL NULL timestamp |
| 655 |
NULL information_schema EVENTS LAST_EXECUTED datetime NULL NULL NULL NULL datetime |
| 656 |
3.0000 information_schema EVENTS EVENT_COMMENT varchar 2048 6144 utf8mb3 utf8mb3_bin varchar(2048) |
| 657 |
NULL information_schema EVENTS ORIGINATOR int NULL NULL NULL NULL int unsigned |
| 658 |
3.0000 information_schema EVENTS CHARACTER_SET_CLIENT varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 659 |
3.0000 information_schema EVENTS COLLATION_CONNECTION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 660 |
3.0000 information_schema EVENTS DATABASE_COLLATION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 661 |
NULL information_schema FILES FILE_ID bigint NULL NULL NULL NULL bigint |
| 662 |
1.0000 information_schema FILES FILE_NAME text 65535 65535 utf8mb3 utf8mb3_bin text |
| 663 |
3.0000 information_schema FILES FILE_TYPE varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 664 |
3.0000 information_schema FILES TABLESPACE_NAME varchar 268 804 utf8mb3 utf8mb3_bin varchar(268) |
| 665 |
NULL information_schema FILES TABLE_CATALOG char 0 0 utf8mb3 utf8mb3_general_ci char(0) |
| 666 |
NULL information_schema FILES TABLE_SCHEMA binary 0 0 NULL NULL binary(0) |
| 667 |
NULL information_schema FILES TABLE_NAME binary 0 0 NULL NULL binary(0) |
| 668 |
3.0000 information_schema FILES LOGFILE_GROUP_NAME varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 669 |
NULL information_schema FILES LOGFILE_GROUP_NUMBER bigint NULL NULL NULL NULL bigint |
| 670 |
3.0000 information_schema FILES ENGINE varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 671 |
NULL information_schema FILES FULLTEXT_KEYS binary 0 0 NULL NULL binary(0) |
| 672 |
NULL information_schema FILES DELETED_ROWS binary 0 0 NULL NULL binary(0) |
| 673 |
NULL information_schema FILES UPDATE_COUNT binary 0 0 NULL NULL binary(0) |
| 674 |
NULL information_schema FILES FREE_EXTENTS bigint NULL NULL NULL NULL bigint |
| 675 |
NULL information_schema FILES TOTAL_EXTENTS bigint NULL NULL NULL NULL bigint |
| 676 |
NULL information_schema FILES EXTENT_SIZE bigint NULL NULL NULL NULL bigint |
| 677 |
NULL information_schema FILES INITIAL_SIZE bigint NULL NULL NULL NULL bigint |
| 678 |
NULL information_schema FILES MAXIMUM_SIZE bigint NULL NULL NULL NULL bigint |
| 679 |
NULL information_schema FILES AUTOEXTEND_SIZE bigint NULL NULL NULL NULL bigint |
| 680 |
NULL information_schema FILES CREATION_TIME binary 0 0 NULL NULL binary(0) |
| 681 |
NULL information_schema FILES LAST_UPDATE_TIME binary 0 0 NULL NULL binary(0) |
| 682 |
NULL information_schema FILES LAST_ACCESS_TIME binary 0 0 NULL NULL binary(0) |
| 683 |
NULL information_schema FILES RECOVER_TIME binary 0 0 NULL NULL binary(0) |
| 684 |
NULL information_schema FILES TRANSACTION_COUNTER binary 0 0 NULL NULL binary(0) |
| 685 |
NULL information_schema FILES VERSION bigint NULL NULL NULL NULL bigint |
| 686 |
3.0000 information_schema FILES ROW_FORMAT varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 687 |
NULL information_schema FILES TABLE_ROWS binary 0 0 NULL NULL binary(0) |
| 688 |
NULL information_schema FILES AVG_ROW_LENGTH binary 0 0 NULL NULL binary(0) |
| 689 |
NULL information_schema FILES DATA_LENGTH binary 0 0 NULL NULL binary(0) |
| 690 |
NULL information_schema FILES MAX_DATA_LENGTH binary 0 0 NULL NULL binary(0) |
| 691 |
NULL information_schema FILES INDEX_LENGTH binary 0 0 NULL NULL binary(0) |
| 692 |
NULL information_schema FILES DATA_FREE bigint NULL NULL NULL NULL bigint |
| 693 |
NULL information_schema FILES CREATE_TIME binary 0 0 NULL NULL binary(0) |
| 694 |
NULL information_schema FILES UPDATE_TIME binary 0 0 NULL NULL binary(0) |
| 695 |
NULL information_schema FILES CHECK_TIME binary 0 0 NULL NULL binary(0) |
| 696 |
NULL information_schema FILES CHECKSUM binary 0 0 NULL NULL binary(0) |
| 697 |
3.0000 information_schema FILES STATUS varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 698 |
3.0000 information_schema FILES EXTRA varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 699 |
4.0000 information_schema KEYWORDS WORD varchar 128 512 utf8mb4 utf8mb4_0900_ai_ci varchar(128) |
| 700 |
NULL information_schema KEYWORDS RESERVED int NULL NULL NULL NULL int |
| 701 |
3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 702 |
3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 703 |
3.0000 information_schema KEY_COLUMN_USAGE CONSTRAINT_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 704 |
3.0000 information_schema KEY_COLUMN_USAGE TABLE_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 705 |
3.0000 information_schema KEY_COLUMN_USAGE TABLE_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 706 |
3.0000 information_schema KEY_COLUMN_USAGE TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 707 |
3.0000 information_schema KEY_COLUMN_USAGE COLUMN_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 708 |
NULL information_schema KEY_COLUMN_USAGE ORDINAL_POSITION int NULL NULL NULL NULL int unsigned |
| 709 |
NULL information_schema KEY_COLUMN_USAGE POSITION_IN_UNIQUE_CONSTRAINT int NULL NULL NULL NULL int unsigned |
| 710 |
3.0000 information_schema KEY_COLUMN_USAGE REFERENCED_TABLE_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 711 |
3.0000 information_schema KEY_COLUMN_USAGE REFERENCED_TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 712 |
3.0000 information_schema KEY_COLUMN_USAGE REFERENCED_COLUMN_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 713 |
3.0000 information_schema OPTIMIZER_TRACE QUERY varchar 21845 65535 utf8mb3 utf8mb3_general_ci varchar(65535) |
| 714 |
3.0000 information_schema OPTIMIZER_TRACE TRACE varchar 21845 65535 utf8mb3 utf8mb3_general_ci varchar(65535) |
| 715 |
NULL information_schema OPTIMIZER_TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE int NULL NULL NULL NULL int |
| 716 |
NULL information_schema OPTIMIZER_TRACE INSUFFICIENT_PRIVILEGES tinyint NULL NULL NULL NULL tinyint(1) |
| 717 |
3.0000 information_schema PARAMETERS SPECIFIC_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 718 |
3.0000 information_schema PARAMETERS SPECIFIC_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 719 |
3.0000 information_schema PARAMETERS SPECIFIC_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 720 |
NULL information_schema PARAMETERS ORDINAL_POSITION bigint NULL NULL NULL NULL bigint unsigned |
| 721 |
3.0000 information_schema PARAMETERS PARAMETER_MODE varchar 5 15 utf8mb3 utf8mb3_bin varchar(5) |
| 722 |
3.0000 information_schema PARAMETERS PARAMETER_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 723 |
1.0000 information_schema PARAMETERS DATA_TYPE longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext |
| 724 |
NULL information_schema PARAMETERS CHARACTER_MAXIMUM_LENGTH bigint NULL NULL NULL NULL bigint |
| 725 |
NULL information_schema PARAMETERS CHARACTER_OCTET_LENGTH bigint NULL NULL NULL NULL bigint |
| 726 |
NULL information_schema PARAMETERS NUMERIC_PRECISION int NULL NULL NULL NULL int unsigned |
| 727 |
NULL information_schema PARAMETERS NUMERIC_SCALE bigint NULL NULL NULL NULL bigint |
| 728 |
NULL information_schema PARAMETERS DATETIME_PRECISION int NULL NULL NULL NULL int unsigned |
| 729 |
3.0000 information_schema PARAMETERS CHARACTER_SET_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 730 |
3.0000 information_schema PARAMETERS COLLATION_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 731 |
1.0000 information_schema PARAMETERS DTD_IDENTIFIER mediumtext 16777215 16777215 utf8mb3 utf8mb3_bin mediumtext |
| 732 |
3.0000 information_schema PARAMETERS ROUTINE_TYPE enum 9 27 utf8mb3 utf8mb3_bin enum('FUNCTION','PROCEDURE') |
| 733 |
3.0000 information_schema PARTITIONS TABLE_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 734 |
3.0000 information_schema PARTITIONS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 735 |
3.0000 information_schema PARTITIONS TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 736 |
3.0000 information_schema PARTITIONS PARTITION_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 737 |
3.0000 information_schema PARTITIONS SUBPARTITION_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 738 |
NULL information_schema PARTITIONS PARTITION_ORDINAL_POSITION int NULL NULL NULL NULL int unsigned |
| 739 |
NULL information_schema PARTITIONS SUBPARTITION_ORDINAL_POSITION int NULL NULL NULL NULL int unsigned |
| 740 |
3.0000 information_schema PARTITIONS PARTITION_METHOD varchar 13 39 utf8mb3 utf8mb3_general_ci varchar(13) |
| 741 |
3.0000 information_schema PARTITIONS SUBPARTITION_METHOD varchar 13 39 utf8mb3 utf8mb3_general_ci varchar(13) |
| 742 |
3.0000 information_schema PARTITIONS PARTITION_EXPRESSION varchar 2048 6144 utf8mb3 utf8mb3_bin varchar(2048) |
| 743 |
3.0000 information_schema PARTITIONS SUBPARTITION_EXPRESSION varchar 2048 6144 utf8mb3 utf8mb3_bin varchar(2048) |
| 744 |
1.0000 information_schema PARTITIONS PARTITION_DESCRIPTION text 65535 65535 utf8mb3 utf8mb3_bin text |
| 745 |
NULL information_schema PARTITIONS TABLE_ROWS bigint NULL NULL NULL NULL bigint unsigned |
| 746 |
NULL information_schema PARTITIONS AVG_ROW_LENGTH bigint NULL NULL NULL NULL bigint unsigned |
| 747 |
NULL information_schema PARTITIONS DATA_LENGTH bigint NULL NULL NULL NULL bigint unsigned |
| 748 |
NULL information_schema PARTITIONS MAX_DATA_LENGTH bigint NULL NULL NULL NULL bigint unsigned |
| 749 |
NULL information_schema PARTITIONS INDEX_LENGTH bigint NULL NULL NULL NULL bigint unsigned |
| 750 |
NULL information_schema PARTITIONS DATA_FREE bigint NULL NULL NULL NULL bigint unsigned |
| 751 |
NULL information_schema PARTITIONS CREATE_TIME timestamp NULL NULL NULL NULL timestamp |
| 752 |
NULL information_schema PARTITIONS UPDATE_TIME datetime NULL NULL NULL NULL datetime |
| 753 |
NULL information_schema PARTITIONS CHECK_TIME datetime NULL NULL NULL NULL datetime |
| 754 |
NULL information_schema PARTITIONS CHECKSUM bigint NULL NULL NULL NULL bigint |
| 755 |
1.0000 information_schema PARTITIONS PARTITION_COMMENT text 65535 65535 utf8mb3 utf8mb3_bin text |
| 756 |
3.0000 information_schema PARTITIONS NODEGROUP varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 757 |
3.0000 information_schema PARTITIONS TABLESPACE_NAME varchar 268 804 utf8mb3 utf8mb3_bin varchar(268) |
| 758 |
3.0476 information_schema PLUGINS PLUGIN_NAME varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 759 |
3.3333 information_schema PLUGINS PLUGIN_VERSION varchar 6 20 utf8mb3 utf8mb3_general_ci varchar(20) |
| 760 |
3.3333 information_schema PLUGINS PLUGIN_STATUS varchar 3 10 utf8mb3 utf8mb3_general_ci varchar(10) |
| 761 |
3.0769 information_schema PLUGINS PLUGIN_TYPE varchar 26 80 utf8mb3 utf8mb3_general_ci varchar(80) |
| 762 |
3.3333 information_schema PLUGINS PLUGIN_TYPE_VERSION varchar 6 20 utf8mb3 utf8mb3_general_ci varchar(20) |
| 763 |
3.0476 information_schema PLUGINS PLUGIN_LIBRARY varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 764 |
3.3333 information_schema PLUGINS PLUGIN_LIBRARY_VERSION varchar 6 20 utf8mb3 utf8mb3_general_ci varchar(20) |
| 765 |
3.0476 information_schema PLUGINS PLUGIN_AUTHOR varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 766 |
3.0000 information_schema PLUGINS PLUGIN_DESCRIPTION varchar 21845 65535 utf8mb3 utf8mb3_general_ci varchar(65535) |
| 767 |
3.0769 information_schema PLUGINS PLUGIN_LICENSE varchar 26 80 utf8mb3 utf8mb3_general_ci varchar(80) |
| 768 |
3.0476 information_schema PLUGINS LOAD_OPTION varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 769 |
NULL information_schema PROCESSLIST ID bigint NULL NULL NULL NULL bigint unsigned |
| 770 |
3.2000 information_schema PROCESSLIST USER varchar 10 32 utf8mb3 utf8mb3_general_ci varchar(32) |
| 771 |
3.0000 information_schema PROCESSLIST HOST varchar 87 261 utf8mb3 utf8mb3_general_ci varchar(261) |
| 772 |
3.0476 information_schema PROCESSLIST DB varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 773 |
3.2000 information_schema PROCESSLIST COMMAND varchar 5 16 utf8mb3 utf8mb3_general_ci varchar(16) |
| 774 |
NULL information_schema PROCESSLIST TIME int NULL NULL NULL NULL int |
| 775 |
3.0476 information_schema PROCESSLIST STATE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 776 |
3.0000 information_schema PROCESSLIST INFO varchar 21845 65535 utf8mb3 utf8mb3_general_ci varchar(65535) |
| 777 |
3.0000 information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 778 |
3.0000 information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 779 |
3.0000 information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 780 |
3.0000 information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 781 |
3.0000 information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 782 |
3.0000 information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 783 |
3.0000 information_schema REFERENTIAL_CONSTRAINTS MATCH_OPTION enum 7 21 utf8mb3 utf8mb3_bin enum('NONE','PARTIAL','FULL') |
| 784 |
3.0000 information_schema REFERENTIAL_CONSTRAINTS UPDATE_RULE enum 11 33 utf8mb3 utf8mb3_bin enum('NO ACTION','RESTRICT','CASCADE','SET NULL','SET DEFAULT') |
| 785 |
3.0000 information_schema REFERENTIAL_CONSTRAINTS DELETE_RULE enum 11 33 utf8mb3 utf8mb3_bin enum('NO ACTION','RESTRICT','CASCADE','SET NULL','SET DEFAULT') |
| 786 |
3.0000 information_schema REFERENTIAL_CONSTRAINTS TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 787 |
3.0000 information_schema REFERENTIAL_CONSTRAINTS REFERENCED_TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 788 |
3.0000 information_schema RESOURCE_GROUPS RESOURCE_GROUP_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 789 |
3.0000 information_schema RESOURCE_GROUPS RESOURCE_GROUP_TYPE enum 6 18 utf8mb3 utf8mb3_bin enum('SYSTEM','USER') |
| 790 |
NULL information_schema RESOURCE_GROUPS RESOURCE_GROUP_ENABLED tinyint NULL NULL NULL NULL tinyint(1) |
| 791 |
1.0000 information_schema RESOURCE_GROUPS VCPU_IDS blob 65535 65535 NULL NULL blob |
| 792 |
NULL information_schema RESOURCE_GROUPS THREAD_PRIORITY int NULL NULL NULL NULL int |
| 793 |
3.0000 information_schema ROLE_COLUMN_GRANTS GRANTOR varchar 97 291 utf8mb3 utf8mb3_general_ci varchar(97) |
| 794 |
3.0000 information_schema ROLE_COLUMN_GRANTS GRANTOR_HOST varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 795 |
3.0000 information_schema ROLE_COLUMN_GRANTS GRANTEE char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 796 |
1.0000 information_schema ROLE_COLUMN_GRANTS GRANTEE_HOST char 255 255 ascii ascii_general_ci char(255) |
| 797 |
3.0000 information_schema ROLE_COLUMN_GRANTS TABLE_CATALOG varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 798 |
3.0000 information_schema ROLE_COLUMN_GRANTS TABLE_SCHEMA char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 799 |
3.0000 information_schema ROLE_COLUMN_GRANTS TABLE_NAME char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 800 |
3.0000 information_schema ROLE_COLUMN_GRANTS COLUMN_NAME char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 801 |
3.0000 information_schema ROLE_COLUMN_GRANTS PRIVILEGE_TYPE set 31 93 utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','References') |
| 802 |
3.0000 information_schema ROLE_COLUMN_GRANTS IS_GRANTABLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 803 |
3.0000 information_schema ROLE_ROUTINE_GRANTS GRANTOR varchar 97 291 utf8mb3 utf8mb3_general_ci varchar(97) |
| 804 |
3.0000 information_schema ROLE_ROUTINE_GRANTS GRANTOR_HOST varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 805 |
3.0000 information_schema ROLE_ROUTINE_GRANTS GRANTEE char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 806 |
1.0000 information_schema ROLE_ROUTINE_GRANTS GRANTEE_HOST char 255 255 ascii ascii_general_ci char(255) |
| 807 |
3.0000 information_schema ROLE_ROUTINE_GRANTS SPECIFIC_CATALOG varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 808 |
3.0000 information_schema ROLE_ROUTINE_GRANTS SPECIFIC_SCHEMA char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 809 |
3.0000 information_schema ROLE_ROUTINE_GRANTS SPECIFIC_NAME char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 810 |
3.0000 information_schema ROLE_ROUTINE_GRANTS ROUTINE_CATALOG varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 811 |
3.0000 information_schema ROLE_ROUTINE_GRANTS ROUTINE_SCHEMA char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 812 |
3.0000 information_schema ROLE_ROUTINE_GRANTS ROUTINE_NAME char 64 192 utf8mb3 utf8mb3_general_ci char(64) |
| 813 |
3.0000 information_schema ROLE_ROUTINE_GRANTS PRIVILEGE_TYPE set 27 81 utf8mb3 utf8mb3_general_ci set('Execute','Alter Routine','Grant') |
| 814 |
3.0000 information_schema ROLE_ROUTINE_GRANTS IS_GRANTABLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 815 |
3.0000 information_schema ROLE_TABLE_GRANTS GRANTOR varchar 97 291 utf8mb3 utf8mb3_general_ci varchar(97) |
| 816 |
3.0000 information_schema ROLE_TABLE_GRANTS GRANTOR_HOST varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 817 |
3.0000 information_schema ROLE_TABLE_GRANTS GRANTEE char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 818 |
1.0000 information_schema ROLE_TABLE_GRANTS GRANTEE_HOST char 255 255 ascii ascii_general_ci char(255) |
| 819 |
3.0000 information_schema ROLE_TABLE_GRANTS TABLE_CATALOG varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 820 |
3.0000 information_schema ROLE_TABLE_GRANTS TABLE_SCHEMA char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 821 |
3.0000 information_schema ROLE_TABLE_GRANTS TABLE_NAME char 64 192 utf8mb3 utf8mb3_bin char(64) |
| 822 |
3.0000 information_schema ROLE_TABLE_GRANTS PRIVILEGE_TYPE set 98 294 utf8mb3 utf8mb3_general_ci set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') |
| 823 |
3.0000 information_schema ROLE_TABLE_GRANTS IS_GRANTABLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 824 |
3.0000 information_schema ROUTINES SPECIFIC_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 825 |
3.0000 information_schema ROUTINES ROUTINE_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 826 |
3.0000 information_schema ROUTINES ROUTINE_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 827 |
3.0000 information_schema ROUTINES ROUTINE_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 828 |
3.0000 information_schema ROUTINES ROUTINE_TYPE enum 9 27 utf8mb3 utf8mb3_bin enum('FUNCTION','PROCEDURE') |
| 829 |
1.0000 information_schema ROUTINES DATA_TYPE longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext |
| 830 |
NULL information_schema ROUTINES CHARACTER_MAXIMUM_LENGTH bigint NULL NULL NULL NULL bigint |
| 831 |
NULL information_schema ROUTINES CHARACTER_OCTET_LENGTH bigint NULL NULL NULL NULL bigint |
| 832 |
NULL information_schema ROUTINES NUMERIC_PRECISION int NULL NULL NULL NULL int unsigned |
| 833 |
NULL information_schema ROUTINES NUMERIC_SCALE int NULL NULL NULL NULL int unsigned |
| 834 |
NULL information_schema ROUTINES DATETIME_PRECISION int NULL NULL NULL NULL int unsigned |
| 835 |
3.0000 information_schema ROUTINES CHARACTER_SET_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 836 |
3.0000 information_schema ROUTINES COLLATION_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 837 |
1.0000 information_schema ROUTINES DTD_IDENTIFIER longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext |
| 838 |
3.0000 information_schema ROUTINES ROUTINE_BODY varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 839 |
1.0000 information_schema ROUTINES ROUTINE_DEFINITION longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext |
| 840 |
NULL information_schema ROUTINES EXTERNAL_NAME binary 0 0 NULL NULL binary(0) |
| 841 |
3.0000 information_schema ROUTINES EXTERNAL_LANGUAGE varchar 64 192 utf8mb3 utf8mb3_bin varchar(64) |
| 842 |
3.0000 information_schema ROUTINES PARAMETER_STYLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 843 |
3.0000 information_schema ROUTINES IS_DETERMINISTIC varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 844 |
3.0000 information_schema ROUTINES SQL_DATA_ACCESS enum 17 51 utf8mb3 utf8mb3_bin enum('CONTAINS SQL','NO SQL','READS SQL DATA','MODIFIES SQL DATA') |
| 845 |
NULL information_schema ROUTINES SQL_PATH binary 0 0 NULL NULL binary(0) |
| 846 |
3.0000 information_schema ROUTINES SECURITY_TYPE enum 7 21 utf8mb3 utf8mb3_bin enum('DEFAULT','INVOKER','DEFINER') |
| 847 |
NULL information_schema ROUTINES CREATED timestamp NULL NULL NULL NULL timestamp |
| 848 |
NULL information_schema ROUTINES LAST_ALTERED timestamp NULL NULL NULL NULL timestamp |
| 849 |
3.0000 information_schema ROUTINES SQL_MODE set 520 1560 utf8mb3 utf8mb3_bin set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12','NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL') |
| 850 |
1.0000 information_schema ROUTINES ROUTINE_COMMENT text 65535 65535 utf8mb3 utf8mb3_bin text |
| 851 |
3.0000 information_schema ROUTINES DEFINER varchar 288 864 utf8mb3 utf8mb3_bin varchar(288) |
| 852 |
3.0000 information_schema ROUTINES CHARACTER_SET_CLIENT varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 853 |
3.0000 information_schema ROUTINES COLLATION_CONNECTION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 854 |
3.0000 information_schema ROUTINES DATABASE_COLLATION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 855 |
3.0000 information_schema SCHEMATA CATALOG_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 856 |
3.0000 information_schema SCHEMATA SCHEMA_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 857 |
3.0000 information_schema SCHEMATA DEFAULT_CHARACTER_SET_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 858 |
3.0000 information_schema SCHEMATA DEFAULT_COLLATION_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 859 |
NULL information_schema SCHEMATA SQL_PATH binary 0 0 NULL NULL binary(0) |
| 860 |
3.0000 information_schema SCHEMATA DEFAULT_ENCRYPTION enum 3 9 utf8mb3 utf8mb3_bin enum('NO','YES') |
| 861 |
3.0000 information_schema SCHEMATA_EXTENSIONS CATALOG_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 862 |
3.0000 information_schema SCHEMATA_EXTENSIONS SCHEMA_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 863 |
3.0000 information_schema SCHEMATA_EXTENSIONS OPTIONS varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 864 |
3.0103 information_schema SCHEMA_PRIVILEGES GRANTEE varchar 97 292 utf8mb3 utf8mb3_general_ci varchar(292) |
| 865 |
3.0118 information_schema SCHEMA_PRIVILEGES TABLE_CATALOG varchar 170 512 utf8mb3 utf8mb3_general_ci varchar(512) |
| 866 |
3.0476 information_schema SCHEMA_PRIVILEGES TABLE_SCHEMA varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 867 |
3.0476 information_schema SCHEMA_PRIVILEGES PRIVILEGE_TYPE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 868 |
3.0000 information_schema SCHEMA_PRIVILEGES IS_GRANTABLE varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(3) |
| 869 |
3.0000 information_schema STATISTICS TABLE_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 870 |
3.0000 information_schema STATISTICS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 871 |
3.0000 information_schema STATISTICS TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 872 |
NULL information_schema STATISTICS NON_UNIQUE int NULL NULL NULL NULL int |
| 873 |
3.0000 information_schema STATISTICS INDEX_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 874 |
3.0000 information_schema STATISTICS INDEX_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 875 |
NULL information_schema STATISTICS SEQ_IN_INDEX int NULL NULL NULL NULL int unsigned |
| 876 |
3.0000 information_schema STATISTICS COLUMN_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 877 |
3.0000 information_schema STATISTICS COLLATION varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(1) |
| 878 |
NULL information_schema STATISTICS CARDINALITY bigint NULL NULL NULL NULL bigint |
| 879 |
NULL information_schema STATISTICS SUB_PART bigint NULL NULL NULL NULL bigint |
| 880 |
NULL information_schema STATISTICS PACKED binary 0 0 NULL NULL binary(0) |
| 881 |
3.0000 information_schema STATISTICS NULLABLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 882 |
3.0000 information_schema STATISTICS INDEX_TYPE varchar 11 33 utf8mb3 utf8mb3_bin varchar(11) |
| 883 |
3.0000 information_schema STATISTICS COMMENT varchar 8 24 utf8mb3 utf8mb3_general_ci varchar(8) |
| 884 |
3.0000 information_schema STATISTICS INDEX_COMMENT varchar 2048 6144 utf8mb3 utf8mb3_bin varchar(2048) |
| 885 |
3.0000 information_schema STATISTICS IS_VISIBLE varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 886 |
1.0000 information_schema STATISTICS EXPRESSION longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext |
| 887 |
3.0000 information_schema ST_GEOMETRY_COLUMNS TABLE_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 888 |
3.0000 information_schema ST_GEOMETRY_COLUMNS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 889 |
3.0000 information_schema ST_GEOMETRY_COLUMNS TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 890 |
3.0000 information_schema ST_GEOMETRY_COLUMNS COLUMN_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 891 |
3.0000 information_schema ST_GEOMETRY_COLUMNS SRS_NAME varchar 80 240 utf8mb3 utf8mb3_general_ci varchar(80) |
| 892 |
NULL information_schema ST_GEOMETRY_COLUMNS SRS_ID int NULL NULL NULL NULL int unsigned |
| 893 |
1.0000 information_schema ST_GEOMETRY_COLUMNS GEOMETRY_TYPE_NAME longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext |
| 894 |
3.0000 information_schema ST_SPATIAL_REFERENCE_SYSTEMS SRS_NAME varchar 80 240 utf8mb3 utf8mb3_general_ci varchar(80) |
| 895 |
NULL information_schema ST_SPATIAL_REFERENCE_SYSTEMS SRS_ID int NULL NULL NULL NULL int unsigned |
| 896 |
3.0000 information_schema ST_SPATIAL_REFERENCE_SYSTEMS ORGANIZATION varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 897 |
NULL information_schema ST_SPATIAL_REFERENCE_SYSTEMS ORGANIZATION_COORDSYS_ID int NULL NULL NULL NULL int unsigned |
| 898 |
3.0000 information_schema ST_SPATIAL_REFERENCE_SYSTEMS DEFINITION varchar 4096 12288 utf8mb3 utf8mb3_bin varchar(4096) |
| 899 |
3.0000 information_schema ST_SPATIAL_REFERENCE_SYSTEMS DESCRIPTION varchar 2048 6144 utf8mb3 utf8mb3_bin varchar(2048) |
| 900 |
4.0000 information_schema ST_UNITS_OF_MEASURE UNIT_NAME varchar 255 1020 utf8mb4 utf8mb4_0900_ai_ci varchar(255) |
| 901 |
4.0000 information_schema ST_UNITS_OF_MEASURE UNIT_TYPE varchar 7 28 utf8mb4 utf8mb4_0900_ai_ci varchar(7) |
| 902 |
NULL information_schema ST_UNITS_OF_MEASURE CONVERSION_FACTOR double NULL NULL NULL NULL double |
| 903 |
4.0000 information_schema ST_UNITS_OF_MEASURE DESCRIPTION varchar 255 1020 utf8mb4 utf8mb4_0900_ai_ci varchar(255) |
| 904 |
3.0000 information_schema TABLES TABLE_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 905 |
3.0000 information_schema TABLES TABLE_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 906 |
3.0000 information_schema TABLES TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 907 |
3.0000 information_schema TABLES TABLE_TYPE enum 11 33 utf8mb3 utf8mb3_bin enum('BASE TABLE','VIEW','SYSTEM VIEW') |
| 908 |
3.0000 information_schema TABLES ENGINE varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 909 |
NULL information_schema TABLES VERSION int NULL NULL NULL NULL int |
| 910 |
3.0000 information_schema TABLES ROW_FORMAT enum 10 30 utf8mb3 utf8mb3_bin enum('Fixed','Dynamic','Compressed','Redundant','Compact','Paged') |
| 911 |
NULL information_schema TABLES TABLE_ROWS bigint NULL NULL NULL NULL bigint unsigned |
| 912 |
NULL information_schema TABLES AVG_ROW_LENGTH bigint NULL NULL NULL NULL bigint unsigned |
| 913 |
NULL information_schema TABLES DATA_LENGTH bigint NULL NULL NULL NULL bigint unsigned |
| 914 |
NULL information_schema TABLES MAX_DATA_LENGTH bigint NULL NULL NULL NULL bigint unsigned |
| 915 |
NULL information_schema TABLES INDEX_LENGTH bigint NULL NULL NULL NULL bigint unsigned |
| 916 |
NULL information_schema TABLES DATA_FREE bigint NULL NULL NULL NULL bigint unsigned |
| 917 |
NULL information_schema TABLES AUTO_INCREMENT bigint NULL NULL NULL NULL bigint unsigned |
| 918 |
NULL information_schema TABLES CREATE_TIME timestamp NULL NULL NULL NULL timestamp |
| 919 |
NULL information_schema TABLES UPDATE_TIME datetime NULL NULL NULL NULL datetime |
| 920 |
NULL information_schema TABLES CHECK_TIME datetime NULL NULL NULL NULL datetime |
| 921 |
3.0000 information_schema TABLES TABLE_COLLATION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 922 |
NULL information_schema TABLES CHECKSUM bigint NULL NULL NULL NULL bigint |
| 923 |
3.0000 information_schema TABLES CREATE_OPTIONS varchar 256 768 utf8mb3 utf8mb3_general_ci varchar(256) |
| 924 |
1.0000 information_schema TABLES TABLE_COMMENT text 65535 65535 utf8mb3 utf8mb3_general_ci text |
| 925 |
3.0476 information_schema TABLESPACES TABLESPACE_NAME varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 926 |
3.0476 information_schema TABLESPACES ENGINE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 927 |
3.0476 information_schema TABLESPACES TABLESPACE_TYPE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 928 |
3.0476 information_schema TABLESPACES LOGFILE_GROUP_NAME varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 929 |
NULL information_schema TABLESPACES EXTENT_SIZE bigint NULL NULL NULL NULL bigint unsigned |
| 930 |
NULL information_schema TABLESPACES AUTOEXTEND_SIZE bigint NULL NULL NULL NULL bigint unsigned |
| 931 |
NULL information_schema TABLESPACES MAXIMUM_SIZE bigint NULL NULL NULL NULL bigint unsigned |
| 932 |
NULL information_schema TABLESPACES NODEGROUP_ID bigint NULL NULL NULL NULL bigint unsigned |
| 933 |
3.0029 information_schema TABLESPACES TABLESPACE_COMMENT varchar 682 2048 utf8mb3 utf8mb3_general_ci varchar(2048) |
| 934 |
3.0000 information_schema TABLESPACES_EXTENSIONS TABLESPACE_NAME varchar 268 804 utf8mb3 utf8mb3_bin varchar(268) |
| 935 |
NULL information_schema TABLESPACES_EXTENSIONS ENGINE_ATTRIBUTE json NULL NULL NULL NULL json |
| 936 |
3.0000 information_schema TABLES_EXTENSIONS TABLE_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 937 |
3.0000 information_schema TABLES_EXTENSIONS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 938 |
3.0000 information_schema TABLES_EXTENSIONS TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 939 |
NULL information_schema TABLES_EXTENSIONS ENGINE_ATTRIBUTE json NULL NULL NULL NULL json |
| 940 |
NULL information_schema TABLES_EXTENSIONS SECONDARY_ENGINE_ATTRIBUTE json NULL NULL NULL NULL json |
| 941 |
3.0000 information_schema TABLE_CONSTRAINTS CONSTRAINT_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 942 |
3.0000 information_schema TABLE_CONSTRAINTS CONSTRAINT_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 943 |
3.0000 information_schema TABLE_CONSTRAINTS CONSTRAINT_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 944 |
3.0000 information_schema TABLE_CONSTRAINTS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 945 |
3.0000 information_schema TABLE_CONSTRAINTS TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 946 |
3.0000 information_schema TABLE_CONSTRAINTS CONSTRAINT_TYPE varchar 11 33 utf8mb3 utf8mb3_bin varchar(11) |
| 947 |
3.0000 information_schema TABLE_CONSTRAINTS ENFORCED varchar 3 9 utf8mb3 utf8mb3_bin varchar(3) |
| 948 |
3.0000 information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 949 |
3.0000 information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 950 |
3.0000 information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 951 |
3.0000 information_schema TABLE_CONSTRAINTS_EXTENSIONS TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 952 |
NULL information_schema TABLE_CONSTRAINTS_EXTENSIONS ENGINE_ATTRIBUTE json NULL NULL NULL NULL json |
| 953 |
NULL information_schema TABLE_CONSTRAINTS_EXTENSIONS SECONDARY_ENGINE_ATTRIBUTE json NULL NULL NULL NULL json |
| 954 |
3.0103 information_schema TABLE_PRIVILEGES GRANTEE varchar 97 292 utf8mb3 utf8mb3_general_ci varchar(292) |
| 955 |
3.0118 information_schema TABLE_PRIVILEGES TABLE_CATALOG varchar 170 512 utf8mb3 utf8mb3_general_ci varchar(512) |
| 956 |
3.0476 information_schema TABLE_PRIVILEGES TABLE_SCHEMA varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 957 |
3.0476 information_schema TABLE_PRIVILEGES TABLE_NAME varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 958 |
3.0476 information_schema TABLE_PRIVILEGES PRIVILEGE_TYPE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 959 |
3.0000 information_schema TABLE_PRIVILEGES IS_GRANTABLE varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(3) |
| 960 |
3.0000 information_schema TRIGGERS TRIGGER_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 961 |
3.0000 information_schema TRIGGERS TRIGGER_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 962 |
3.0000 information_schema TRIGGERS TRIGGER_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 963 |
3.0000 information_schema TRIGGERS EVENT_MANIPULATION enum 6 18 utf8mb3 utf8mb3_bin enum('INSERT','UPDATE','DELETE') |
| 964 |
3.0000 information_schema TRIGGERS EVENT_OBJECT_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 965 |
3.0000 information_schema TRIGGERS EVENT_OBJECT_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 966 |
3.0000 information_schema TRIGGERS EVENT_OBJECT_TABLE varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 967 |
NULL information_schema TRIGGERS ACTION_ORDER int NULL NULL NULL NULL int unsigned |
| 968 |
NULL information_schema TRIGGERS ACTION_CONDITION binary 0 0 NULL NULL binary(0) |
| 969 |
1.0000 information_schema TRIGGERS ACTION_STATEMENT longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext |
| 970 |
3.0000 information_schema TRIGGERS ACTION_ORIENTATION varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 971 |
3.0000 information_schema TRIGGERS ACTION_TIMING enum 6 18 utf8mb3 utf8mb3_bin enum('BEFORE','AFTER') |
| 972 |
NULL information_schema TRIGGERS ACTION_REFERENCE_OLD_TABLE binary 0 0 NULL NULL binary(0) |
| 973 |
NULL information_schema TRIGGERS ACTION_REFERENCE_NEW_TABLE binary 0 0 NULL NULL binary(0) |
| 974 |
3.0000 information_schema TRIGGERS ACTION_REFERENCE_OLD_ROW varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 975 |
3.0000 information_schema TRIGGERS ACTION_REFERENCE_NEW_ROW varchar 3 9 utf8mb3 utf8mb3_general_ci varchar(3) |
| 976 |
NULL information_schema TRIGGERS CREATED timestamp NULL NULL NULL NULL timestamp(2) |
| 977 |
3.0000 information_schema TRIGGERS SQL_MODE set 520 1560 utf8mb3 utf8mb3_bin set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12','NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL') |
| 978 |
3.0000 information_schema TRIGGERS DEFINER varchar 288 864 utf8mb3 utf8mb3_bin varchar(288) |
| 979 |
3.0000 information_schema TRIGGERS CHARACTER_SET_CLIENT varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 980 |
3.0000 information_schema TRIGGERS COLLATION_CONNECTION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 981 |
3.0000 information_schema TRIGGERS DATABASE_COLLATION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 982 |
3.0000 information_schema USER_ATTRIBUTES USER char 32 96 utf8mb3 utf8mb3_bin char(32) |
| 983 |
1.0000 information_schema USER_ATTRIBUTES HOST char 255 255 ascii ascii_general_ci char(255) |
| 984 |
1.0000 information_schema USER_ATTRIBUTES ATTRIBUTE longtext 4294967295 4294967295 utf8mb4 utf8mb4_bin longtext |
| 985 |
3.0103 information_schema USER_PRIVILEGES GRANTEE varchar 97 292 utf8mb3 utf8mb3_general_ci varchar(292) |
| 986 |
3.0118 information_schema USER_PRIVILEGES TABLE_CATALOG varchar 170 512 utf8mb3 utf8mb3_general_ci varchar(512) |
| 987 |
3.0476 information_schema USER_PRIVILEGES PRIVILEGE_TYPE varchar 21 64 utf8mb3 utf8mb3_general_ci varchar(64) |
| 988 |
3.0000 information_schema USER_PRIVILEGES IS_GRANTABLE varchar 1 3 utf8mb3 utf8mb3_general_ci varchar(3) |
| 989 |
3.0000 information_schema VIEWS TABLE_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 990 |
3.0000 information_schema VIEWS TABLE_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 991 |
3.0000 information_schema VIEWS TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 992 |
1.0000 information_schema VIEWS VIEW_DEFINITION longtext 4294967295 4294967295 utf8mb3 utf8mb3_bin longtext |
| 993 |
3.0000 information_schema VIEWS CHECK_OPTION enum 8 24 utf8mb3 utf8mb3_bin enum('NONE','LOCAL','CASCADED') |
| 994 |
3.0000 information_schema VIEWS IS_UPDATABLE enum 3 9 utf8mb3 utf8mb3_bin enum('NO','YES') |
| 995 |
3.0000 information_schema VIEWS DEFINER varchar 288 864 utf8mb3 utf8mb3_bin varchar(288) |
| 996 |
3.0000 information_schema VIEWS SECURITY_TYPE varchar 7 21 utf8mb3 utf8mb3_bin varchar(7) |
| 997 |
3.0000 information_schema VIEWS CHARACTER_SET_CLIENT varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 998 |
3.0000 information_schema VIEWS COLLATION_CONNECTION varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 999 |
3.0000 information_schema VIEW_ROUTINE_USAGE TABLE_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 1000 |
3.0000 information_schema VIEW_ROUTINE_USAGE TABLE_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 1001 |
3.0000 information_schema VIEW_ROUTINE_USAGE TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 1002 |
3.0000 information_schema VIEW_ROUTINE_USAGE SPECIFIC_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 1003 |
3.0000 information_schema VIEW_ROUTINE_USAGE SPECIFIC_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 1004 |
3.0000 information_schema VIEW_ROUTINE_USAGE SPECIFIC_NAME varchar 64 192 utf8mb3 utf8mb3_general_ci varchar(64) |
| 1005 |
3.0000 information_schema VIEW_TABLE_USAGE VIEW_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 1006 |
3.0000 information_schema VIEW_TABLE_USAGE VIEW_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 1007 |
3.0000 information_schema VIEW_TABLE_USAGE VIEW_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 1008 |
3.0000 information_schema VIEW_TABLE_USAGE TABLE_CATALOG varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 1009 |
3.0000 information_schema VIEW_TABLE_USAGE TABLE_SCHEMA varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 1010 |
3.0000 information_schema VIEW_TABLE_USAGE TABLE_NAME varchar 64 192 utf8mb3 utf8_bin varchar(64) |
| 1011 |
SET sql_mode = default; |