github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/database/system_table.result (about) 1 SELECT table_catalog,table_schema,table_name,table_type from `information_schema`.`tables` where table_name = 'mo_tables'; 2 table_catalog table_schema table_name table_type 3 def mo_catalog mo_tables BASE TABLE 4 SELECT * FROM `information_schema`.`character_sets` LIMIT 0,1000; 5 character_set_name default_collate_name description maxlen 6 SELECT * FROM `information_schema`.`columns` where TABLE_NAME = 'mo_tables' order by ORDINAL_POSITION LIMIT 2; 7 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 8 def mo_catalog mo_tables rel_id 1 null YES BIGINT UNSIGNED null null null null null null null BIGINT UNSIGNED(0) PRI select,insert,update,references null 9 def mo_catalog mo_tables relname 2 null YES VARCHAR 5000 120000 null null null utf8 utf8_bin VARCHAR(5000) select,insert,update,references null 10 SELECT * FROM `information_schema`.`key_column_usage` LIMIT 0,1000; 11 constraint_catalog constraint_schema constraint_name table_catalog table_schema table_name column_name ordinal_position position_in_unique_constraint referenced_table_schema referenced_table_name referenced_column_name 12 SELECT * FROM `information_schema`.`profiling` LIMIT 0,1000; 13 query_id seq state duration cpu_user cpu_system context_voluntary context_involuntary block_ops_in block_ops_out messages_sent messages_received page_faults_major page_faults_minor swaps source_function source_file source_line 14 SELECT * FROM `information_schema`.`schemata` where schema_name = 'information_schema'; 15 catalog_name schema_name default_character_set_name default_collation_name sql_path default_encryption 16 def information_schema utf8mb4 utf8mb4_0900_ai_ci null NO 17 SELECT * FROM `information_schema`.`triggers` LIMIT 0,1000; 18 trigger_catalog trigger_schema trigger_name event_manipulation event_object_catalog event_object_schema event_object_table action_order action_condition action_statement action_orientation action_timing action_reference_old_table action_reference_new_table action_reference_old_row action_reference_new_row created sql_mode definer character_set_client collation_connection database_collation 19 SELECT * FROM `information_schema`.`user_privileges` LIMIT 0,1000; 20 grantee table_catalog privilege_type is_grantable 21 SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, NON_UNIQUE, NULL AS INDEX_QUALIFIER, INDEX_NAME,3 AS TYPE, SEQ_IN_INDEX AS ORDINAL_POSITION, COLUMN_NAME,COLLATION AS ASC_OR_DESC, CARDINALITY, 0 AS PAGES, NULL AS FILTER_CONDITION FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'procs_priv' ORDER BY NON_UNIQUE, INDEX_NAME, SEQ_IN_INDEX limit 1; 22 TABLE_CAT TABLE_SCHEM table_name non_unique INDEX_QUALIFIER index_name TYPE ORDINAL_POSITION column_name ASC_OR_DESC cardinality PAGES FILTER_CONDITION 23 mysql null procs_priv 0 null PRIMARY 3 1 host A 0 0 null 24 SELECT * FROM `mysql`.`columns_priv` LIMIT 0,1000; 25 host db user table_name column_name timestamp column_priv 26 SELECT * FROM `mysql`.`db` LIMIT 0,1000; 27 host db user select_priv insert_priv update_priv delete_priv create_priv drop_priv grant_priv references_priv index_priv alter_priv create_tmp_table_priv lock_tables_priv create_view_priv show_view_priv create_routine_priv alter_routine_priv execute_priv event_priv trigger_priv 28 SELECT * FROM `mysql`.`procs_priv` LIMIT 0,1000; 29 host db user routine_name routine_type grantor proc_priv timestamp 30 SELECT * FROM `mysql`.`tables_priv` LIMIT 0,1000; 31 host db user table_name grantor timestamp table_priv column_priv 32 SELECT * FROM `mysql`.`user` LIMIT 0,1000; 33 host user select_priv insert_priv update_priv delete_priv create_priv drop_priv reload_priv shutdown_priv process_priv file_priv grant_priv references_priv index_priv alter_priv show_db_priv super_priv create_tmp_table_priv lock_tables_priv execute_priv repl_slave_priv repl_client_priv create_view_priv show_view_priv create_routine_priv alter_routine_priv create_user_priv event_priv trigger_priv create_tablespace_priv ssl_type ssl_cipher x509_issuer x509_subject max_questions max_updates max_connections max_user_connections plugin authentication_string password_expired password_last_changed password_lifetime account_locked create_role_priv drop_role_priv password_reuse_history password_reuse_time password_require_current user_attributes 34 use mysql; 35 show tables; 36 Tables_in_mysql 37 columns_priv 38 db 39 procs_priv 40 role_edges 41 tables_priv 42 user 43 show columns from `user`; 44 Field Type Null Key Default Extra Comment 45 host CHAR(255) NO PRI '' 46 user CHAR(32) NO PRI '' 47 select_priv VARCHAR(10) NO 'N' 48 insert_priv VARCHAR(10) NO 'N' 49 update_priv VARCHAR(10) NO 'N' 50 delete_priv VARCHAR(10) NO 'N' 51 create_priv VARCHAR(10) NO 'N' 52 drop_priv VARCHAR(10) NO 'N' 53 reload_priv VARCHAR(10) NO 'N' 54 shutdown_priv VARCHAR(10) NO 'N' 55 process_priv VARCHAR(10) NO 'N' 56 file_priv VARCHAR(10) NO 'N' 57 grant_priv VARCHAR(10) NO 'N' 58 references_priv VARCHAR(10) NO 'N' 59 index_priv VARCHAR(10) NO 'N' 60 alter_priv VARCHAR(10) NO 'N' 61 show_db_priv VARCHAR(10) NO 'N' 62 super_priv VARCHAR(10) NO 'N' 63 create_tmp_table_priv VARCHAR(10) NO 'N' 64 lock_tables_priv VARCHAR(10) NO 'N' 65 execute_priv VARCHAR(10) NO 'N' 66 repl_slave_priv VARCHAR(10) NO 'N' 67 repl_client_priv VARCHAR(10) NO 'N' 68 create_view_priv VARCHAR(10) NO 'N' 69 show_view_priv VARCHAR(10) NO 'N' 70 create_routine_priv VARCHAR(10) NO 'N' 71 alter_routine_priv VARCHAR(10) NO 'N' 72 create_user_priv VARCHAR(10) NO 'N' 73 event_priv VARCHAR(10) NO 'N' 74 trigger_priv VARCHAR(10) NO 'N' 75 create_tablespace_priv VARCHAR(10) NO 'N' 76 ssl_type VARCHAR(10) NO '' 77 ssl_cipher BLOB(0) NO null 78 x509_issuer BLOB(0) NO null 79 x509_subject BLOB(0) NO null 80 max_questions INT UNSIGNED(32) NO '0' 81 max_updates INT UNSIGNED(32) NO '0' 82 max_connections INT UNSIGNED(32) NO '0' 83 max_user_connections INT UNSIGNED(32) NO '0' 84 plugin CHAR(64) NO 'caching_sha2_password' 85 authentication_string TEXT(0) YES null 86 password_expired VARCHAR(10) NO 'N' 87 password_last_changed TIMESTAMP(0) YES null 88 password_lifetime SMALLINT UNSIGNED(16) YES null 89 account_locked VARCHAR(10) NO 'N' 90 create_role_priv VARCHAR(10) NO 'N' 91 drop_role_priv VARCHAR(10) NO 'N' 92 password_reuse_history SMALLINT UNSIGNED(16) YES null 93 password_reuse_time SMALLINT UNSIGNED(16) YES null 94 password_require_current VARCHAR(10) YES null 95 user_attributes JSON(0) YES null 96 show columns from `db`; 97 Field Type Null Key Default Extra Comment 98 host CHAR(255) NO PRI '' 99 db CHAR(64) NO PRI '' 100 user CHAR(32) NO PRI '' 101 select_priv VARCHAR(10) NO 'N' 102 insert_priv VARCHAR(10) NO 'N' 103 update_priv VARCHAR(10) NO 'N' 104 delete_priv VARCHAR(10) NO 'N' 105 create_priv VARCHAR(10) NO 'N' 106 drop_priv VARCHAR(10) NO 'N' 107 grant_priv VARCHAR(10) NO 'N' 108 references_priv VARCHAR(10) NO 'N' 109 index_priv VARCHAR(10) NO 'N' 110 alter_priv VARCHAR(10) NO 'N' 111 create_tmp_table_priv VARCHAR(10) NO 'N' 112 lock_tables_priv VARCHAR(10) NO 'N' 113 create_view_priv VARCHAR(10) NO 'N' 114 show_view_priv VARCHAR(10) NO 'N' 115 create_routine_priv VARCHAR(10) NO 'N' 116 alter_routine_priv VARCHAR(10) NO 'N' 117 execute_priv VARCHAR(10) NO 'N' 118 event_priv VARCHAR(10) NO 'N' 119 trigger_priv VARCHAR(10) NO 'N' 120 show columns from `procs_priv`; 121 Field Type Null Key Default Extra Comment 122 host CHAR(255) NO PRI '' 123 db CHAR(64) NO PRI '' 124 user CHAR(32) NO PRI '' 125 routine_name CHAR(64) NO PRI '' 126 routine_type VARCHAR(10) NO PRI null 127 grantor VARCHAR(288) NO MUL '' 128 proc_priv VARCHAR(10) NO '' 129 timestamp TIMESTAMP(0) NO current_timestamp() 130 show columns from `columns_priv`; 131 Field Type Null Key Default Extra Comment 132 host CHAR(255) NO PRI '' 133 db CHAR(64) NO PRI '' 134 user CHAR(32) NO PRI '' 135 table_name CHAR(64) NO PRI '' 136 column_name CHAR(64) NO PRI '' 137 timestamp TIMESTAMP(0) NO current_timestamp() 138 column_priv VARCHAR(10) NO '' 139 show columns from `tables_priv`; 140 Field Type Null Key Default Extra Comment 141 host CHAR(255) NO PRI '' 142 db CHAR(64) NO PRI '' 143 user CHAR(32) NO PRI '' 144 table_name CHAR(64) NO PRI '' 145 grantor VARCHAR(288) NO MUL '' 146 timestamp TIMESTAMP(0) NO current_timestamp() 147 table_priv VARCHAR(10) NO '' 148 column_priv VARCHAR(10) NO '' 149 use information_schema; 150 show tables; 151 Tables_in_information_schema 152 character_sets 153 collations 154 column_privileges 155 columns 156 engines 157 events 158 key_column_usage 159 keywords 160 parameters 161 partitions 162 processlist 163 profiling 164 referential_constraints 165 routines 166 schema_privileges 167 schemata 168 statistics 169 table_constraints 170 table_privileges 171 tables 172 triggers 173 user_privileges 174 views 175 show columns from `KEY_COLUMN_USAGE`; 176 Field Type Null Key Default Extra Comment 177 constraint_catalog VARCHAR(64) YES null 178 constraint_schema VARCHAR(64) YES null 179 constraint_name VARCHAR(64) YES null 180 table_catalog VARCHAR(64) YES null 181 table_schema VARCHAR(64) YES null 182 table_name VARCHAR(64) YES null 183 column_name VARCHAR(64) YES null 184 ordinal_position INT UNSIGNED(32) YES null 185 position_in_unique_constraint INT UNSIGNED(32) YES null 186 referenced_table_schema VARCHAR(64) YES null 187 referenced_table_name VARCHAR(64) YES null 188 referenced_column_name VARCHAR(64) YES null 189 show columns from `COLUMNS`; 190 Field Type Null Key Default Extra Comment 191 table_catalog VARCHAR(3) NO null 192 table_schema VARCHAR(256) YES null 193 table_name VARCHAR(256) YES null 194 column_name VARCHAR(256) YES null 195 ordinal_position INT(0) YES null 196 column_default VARCHAR(65535) YES null 197 is_nullable VARCHAR(3) YES null 198 data_type VARCHAR(65535) YES null 199 character_maximum_length BIGINT(0) YES null 200 character_octet_length BIGINT(0) YES null 201 numeric_precision BIGINT(0) YES null 202 numeric_scale BIGINT(0) YES null 203 datetime_precision BIGINT(0) YES null 204 character_set_name VARCHAR(4) YES null 205 collation_name VARCHAR(8) YES null 206 column_type VARCHAR(65535) YES null 207 column_key VARCHAR(3) YES null 208 extra VARCHAR(14) YES null 209 privileges VARCHAR(31) NO null 210 column_comment VARCHAR(2048) YES null 211 generation_expression VARCHAR(500) NO null 212 srs_id BIGINT(0) YES null 213 show columns from `PROFILING`; 214 Field Type Null Key Default Extra Comment 215 query_id INT(32) NO '0' 216 seq INT(32) NO '0' 217 state VARCHAR(30) NO '' 218 duration DECIMAL64(9) NO '0.000000' 219 cpu_user DECIMAL64(9) YES null 220 cpu_system DECIMAL64(9) YES null 221 context_voluntary INT(32) YES null 222 context_involuntary INT(32) YES null 223 block_ops_in INT(32) YES null 224 block_ops_out INT(32) YES null 225 messages_sent INT(32) YES null 226 messages_received INT(32) YES null 227 page_faults_major INT(32) YES null 228 page_faults_minor INT(32) YES null 229 swaps INT(32) YES null 230 source_function VARCHAR(30) YES null 231 source_file VARCHAR(20) YES null 232 source_line INT(32) YES null 233 show columns from `USER_PRIVILEGES`; 234 Field Type Null Key Default Extra Comment 235 grantee VARCHAR(292) NO '' 236 table_catalog VARCHAR(512) NO '' 237 privilege_type VARCHAR(64) NO '' 238 is_grantable VARCHAR(3) NO '' 239 show columns from `SCHEMATA`; 240 Field Type Null Key Default Extra Comment 241 catalog_name VARCHAR(5000) YES null 242 schema_name VARCHAR(5000) YES null 243 default_character_set_name VARCHAR(7) NO null 244 default_collation_name VARCHAR(18) NO null 245 sql_path CHAR(0) YES null 246 default_encryption VARCHAR(3) NO null 247 show columns from `CHARACTER_SETS`; 248 Field Type Null Key Default Extra Comment 249 character_set_name VARCHAR(64) YES null 250 default_collate_name VARCHAR(64) YES null 251 description VARCHAR(2048) YES null 252 maxlen INT UNSIGNED(32) YES null 253 show columns from `TRIGGERS`; 254 Field Type Null Key Default Extra Comment 255 trigger_catalog VARCHAR(64) YES null 256 trigger_schema VARCHAR(64) YES null 257 trigger_name VARCHAR(64) YES null 258 event_manipulation VARCHAR(10) YES null 259 event_object_catalog VARCHAR(64) YES null 260 event_object_schema VARCHAR(64) YES null 261 event_object_table VARCHAR(64) YES null 262 action_order INT UNSIGNED(32) YES null 263 action_condition BINARY(0) YES null 264 action_statement TEXT(0) YES null 265 action_orientation VARCHAR(3) YES null 266 action_timing VARCHAR(10) YES null 267 action_reference_old_table BINARY(0) YES null 268 action_reference_new_table BINARY(0) YES null 269 action_reference_old_row VARCHAR(3) YES null 270 action_reference_new_row VARCHAR(3) YES null 271 created TIMESTAMP(2) YES null 272 sql_mode VARCHAR(10) YES null 273 definer VARCHAR(288) YES null 274 character_set_client VARCHAR(64) YES null 275 collation_connection VARCHAR(64) YES null 276 database_collation VARCHAR(64) YES null 277 show columns from `TABLES`; 278 Field Type Null Key Default Extra Comment 279 table_catalog VARCHAR(3) NO null 280 table_schema VARCHAR(5000) YES null 281 table_name VARCHAR(5000) YES null 282 table_type VARCHAR(14) YES null 283 engine VARCHAR(3) YES null 284 version BIGINT(0) YES null 285 row_format VARCHAR(10) NO null 286 table_rows BIGINT(0) YES null 287 avg_row_length BIGINT(0) YES null 288 data_length BIGINT(0) YES null 289 max_data_length BIGINT(0) YES null 290 index_length BIGINT(0) YES null 291 data_free BIGINT(0) YES null 292 auto_increment BIGINT UNSIGNED(0) YES null 293 create_time TIMESTAMP(0) YES null 294 update_time TIMESTAMP(0) YES null 295 check_time TIMESTAMP(0) YES null 296 table_collation VARCHAR(18) NO null 297 checksum BIGINT(0) YES null 298 create_options VARCHAR(256) YES null 299 table_comment TEXT(0) YES null 300 show columns from `PARTITIONS`; 301 Field Type Null Key Default Extra Comment 302 table_catalog VARCHAR(3) NO null 303 table_schema VARCHAR(5000) YES null 304 table_name VARCHAR(5000) YES null 305 partition_name VARCHAR(64) YES null 306 subpartition_name TEXT(4) YES null 307 partition_ordinal_position SMALLINT UNSIGNED(16) YES null 308 subpartition_ordinal_position TEXT(4) YES null 309 partition_method VARCHAR(13) YES null 310 subpartition_method TEXT(4) YES null 311 partition_expression VARCHAR(2048) YES null 312 subpartition_expression TEXT(4) YES null 313 partition_description TEXT(0) YES null 314 table_rows BIGINT(0) YES null 315 avg_row_length BIGINT(0) NO null 316 data_length BIGINT(0) YES null 317 max_data_length BIGINT(0) NO null 318 index_length BIGINT(0) NO null 319 data_free BIGINT(0) NO null 320 create_time TIMESTAMP(0) YES null 321 update_time TEXT(4) YES null 322 check_time TEXT(4) YES null 323 checksum TEXT(4) YES null 324 partition_comment VARCHAR(2048) NO null 325 nodegroup VARCHAR(7) NO null 326 tablespace_name TEXT(4) YES null 327 drop database if exists test; 328 create database test; 329 use test; 330 drop table if exists t2; 331 create table t2(b int, a int); 332 desc t2; 333 Field Type Null Key Default Extra Comment 334 b INT(32) YES null 335 a INT(32) YES null 336 drop table t2; 337 drop database test;