github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/database/system_table.result (about) 1 SELECT * FROM `information_schema`.`character_sets` LIMIT 0,1000; 2 character_set_name default_collate_name description maxlen 3 SELECT * FROM `information_schema`.`columns` where TABLE_NAME = 'mo_tables' order by ORDINAL_POSITION LIMIT 2; 4 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 5 def mo_catalog mo_tables rel_id 1 null NO BIGINT UNSIGNED 90 90 0 0 0 utf8 utf8_bin BIGINT UNSIGNED(0) PRI select,insert,update,references 0 6 def mo_catalog mo_tables relname 2 null NO VARCHAR 94 94 0 0 0 utf8 utf8_bin VARCHAR(5000) select,insert,update,references 0 7 SELECT * FROM `information_schema`.`key_column_usage` LIMIT 0,1000; 8 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 9 SELECT * FROM `information_schema`.`PROCESSLIST` LIMIT 0,1000; 10 id user host db command time state info 11 SELECT * FROM `information_schema`.`profiling` LIMIT 0,1000; 12 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 13 SELECT * FROM `information_schema`.`schemata` where schema_name = 'information_schema'; 14 catalog_name schema_name default_character_set_name default_collation_name sql_path default_encryption 15 def information_schema utf8mb4 utf8mb4_0900_ai_ci NO 16 SELECT * FROM `information_schema`.`triggers` LIMIT 0,1000; 17 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 18 SELECT * FROM `information_schema`.`user_privileges` LIMIT 0,1000; 19 grantee table_catalog privilege_type is_grantable 20 SELECT * FROM `mysql`.`columns_priv` LIMIT 0,1000; 21 host db user table_name column_name timestamp column_priv 22 SELECT * FROM `mysql`.`db` LIMIT 0,1000; 23 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 24 SELECT * FROM `mysql`.`procs_priv` LIMIT 0,1000; 25 host db user routine_name routine_type grantor proc_priv timestamp 26 SELECT * FROM `mysql`.`tables_priv` LIMIT 0,1000; 27 host db user table_name grantor timestamp table_priv column_priv 28 SELECT * FROM `mysql`.`user` LIMIT 0,1000; 29 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 30 use mysql; 31 show tables; 32 tables_in_mysql 33 user 34 db 35 procs_priv 36 columns_priv 37 tables_priv 38 show columns from `user`; 39 Field Type Null Key Default Extra Comment 40 host CHAR(255) NO PRI '' 41 user CHAR(32) NO PRI '' 42 select_priv VARCHAR(10) NO 'N' 43 insert_priv VARCHAR(10) NO 'N' 44 update_priv VARCHAR(10) NO 'N' 45 delete_priv VARCHAR(10) NO 'N' 46 create_priv VARCHAR(10) NO 'N' 47 drop_priv VARCHAR(10) NO 'N' 48 reload_priv VARCHAR(10) NO 'N' 49 shutdown_priv VARCHAR(10) NO 'N' 50 process_priv VARCHAR(10) NO 'N' 51 file_priv VARCHAR(10) NO 'N' 52 grant_priv VARCHAR(10) NO 'N' 53 references_priv VARCHAR(10) NO 'N' 54 index_priv VARCHAR(10) NO 'N' 55 alter_priv VARCHAR(10) NO 'N' 56 show_db_priv VARCHAR(10) NO 'N' 57 super_priv VARCHAR(10) NO 'N' 58 create_tmp_table_priv VARCHAR(10) NO 'N' 59 lock_tables_priv VARCHAR(10) NO 'N' 60 execute_priv VARCHAR(10) NO 'N' 61 repl_slave_priv VARCHAR(10) NO 'N' 62 repl_client_priv VARCHAR(10) NO 'N' 63 create_view_priv VARCHAR(10) NO 'N' 64 show_view_priv VARCHAR(10) NO 'N' 65 create_routine_priv VARCHAR(10) NO 'N' 66 alter_routine_priv VARCHAR(10) NO 'N' 67 create_user_priv VARCHAR(10) NO 'N' 68 event_priv VARCHAR(10) NO 'N' 69 trigger_priv VARCHAR(10) NO 'N' 70 create_tablespace_priv VARCHAR(10) NO 'N' 71 ssl_type VARCHAR(10) NO '' 72 ssl_cipher BLOB NO NULL 73 x509_issuer BLOB NO NULL 74 x509_subject BLOB NO NULL 75 max_questions INT UNSIGNED NO '0' 76 max_updates INT UNSIGNED NO '0' 77 max_connections INT UNSIGNED NO '0' 78 max_user_connections INT UNSIGNED NO '0' 79 plugin CHAR(64) NO 'caching_sha2_password' 80 authentication_string TEXT YES NULL 81 password_expired VARCHAR(10) NO 'N' 82 password_last_changed TIMESTAMP YES null 83 password_lifetime SMALLINT UNSIGNED YES null 84 account_locked VARCHAR(10) NO 'N' 85 create_role_priv VARCHAR(10) NO 'N' 86 drop_role_priv VARCHAR(10) NO 'N' 87 password_reuse_history SMALLINT UNSIGNED YES null 88 password_reuse_time SMALLINT UNSIGNED YES null 89 password_require_current VARCHAR(10) YES null 90 user_attributes JSON YES null 91 show columns from `db`; 92 Field Type Null Key Default Extra Comment 93 host CHAR(255) NO PRI '' 94 db CHAR(64) NO PRI '' 95 user CHAR(32) NO PRI '' 96 select_priv VARCHAR(10) NO 'N' 97 insert_priv VARCHAR(10) NO 'N' 98 update_priv VARCHAR(10) NO 'N' 99 delete_priv VARCHAR(10) NO 'N' 100 create_priv VARCHAR(10) NO 'N' 101 drop_priv VARCHAR(10) NO 'N' 102 grant_priv VARCHAR(10) NO 'N' 103 references_priv VARCHAR(10) NO 'N' 104 index_priv VARCHAR(10) NO 'N' 105 alter_priv VARCHAR(10) NO 'N' 106 create_tmp_table_priv VARCHAR(10) NO 'N' 107 lock_tables_priv VARCHAR(10) NO 'N' 108 create_view_priv VARCHAR(10) NO 'N' 109 show_view_priv VARCHAR(10) NO 'N' 110 create_routine_priv VARCHAR(10) NO 'N' 111 alter_routine_priv VARCHAR(10) NO 'N' 112 execute_priv VARCHAR(10) NO 'N' 113 event_priv VARCHAR(10) NO 'N' 114 trigger_priv VARCHAR(10) NO 'N' 115 show columns from `procs_priv`; 116 Field Type Null Key Default Extra Comment 117 host CHAR(255) NO PRI '' 118 db CHAR(64) NO PRI '' 119 user CHAR(32) NO PRI '' 120 routine_name CHAR(64) NO PRI '' 121 routine_type VARCHAR(10) NO PRI NULL 122 grantor VARCHAR(288) NO '' 123 proc_priv VARCHAR(10) NO '' 124 timestamp TIMESTAMP NO CURRENT_TIMESTAMP 125 show columns from `columns_priv`; 126 Field Type Null Key Default Extra Comment 127 host CHAR(255) NO PRI '' 128 db CHAR(64) NO PRI '' 129 user CHAR(32) NO PRI '' 130 table_name CHAR(64) NO PRI '' 131 column_name CHAR(64) NO PRI '' 132 timestamp TIMESTAMP NO CURRENT_TIMESTAMP 133 column_priv VARCHAR(10) NO '' 134 show columns from `tables_priv`; 135 Field Type Null Key Default Extra Comment 136 host CHAR(255) NO PRI '' 137 db CHAR(64) NO PRI '' 138 user CHAR(32) NO PRI '' 139 table_name CHAR(64) NO PRI '' 140 grantor VARCHAR(288) NO '' 141 timestamp TIMESTAMP NO CURRENT_TIMESTAMP 142 table_priv VARCHAR(10) NO '' 143 column_priv VARCHAR(10) NO '' 144 use information_schema; 145 show tables; 146 tables_in_information_schema 147 key_column_usage 148 columns 149 profiling 150 PROCESSLIST 151 user_privileges 152 schemata 153 character_sets 154 triggers 155 tables 156 engines 157 routines 158 parameters 159 keywords 160 show columns from `KEY_COLUMN_USAGE`; 161 no such table information_schema.KEY_COLUMN_USAGE 162 show columns from `COLUMNS`; 163 no such table information_schema.COLUMNS 164 show columns from `PROFILING`; 165 no such table information_schema.PROFILING 166 show columns from `PROCESSLIST`; 167 Field Type Null Key Default Extra Comment 168 id BIGINT UNSIGNED NO '0' 169 user VARCHAR(32) NO '' 170 host VARCHAR(261) NO '' 171 db VARCHAR(64) YES null 172 command VARCHAR(16) NO '' 173 time INT NO '0' 174 state VARCHAR(64) YES null 175 info TEXT YES NULL 176 show columns from `USER_PRIVILEGES`; 177 no such table information_schema.USER_PRIVILEGES 178 show columns from `SCHEMATA`; 179 no such table information_schema.SCHEMATA 180 show columns from `CHARACTER_SETS`; 181 no such table information_schema.CHARACTER_SETS 182 show columns from `TRIGGERS`; 183 no such table information_schema.TRIGGERS 184 show columns from `TABLES`; 185 no such table information_schema.TABLES