1show tables;
2Tables_in_db
3columns_priv
4db
5engine_cost
6event
7func
8general_log
9gtid_executed
10help_category
11help_keyword
12help_relation
13help_topic
14innodb_index_stats
15innodb_table_stats
16ndb_binlog_index
17plugin
18proc
19procs_priv
20proxies_priv
21server_cost
22servers
23slave_master_info
24slave_relay_log_info
25slave_worker_info
26slow_log
27tables_priv
28time_zone
29time_zone_leap_second
30time_zone_name
31time_zone_transition
32time_zone_transition_type
33user
34show create table db;
35Table	Create Table
36db	CREATE TABLE `db` (
37  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
38  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
39  `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
40  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
41  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
42  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
43  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
44  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
45  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
46  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
47  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
48  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
49  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
50  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
51  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
52  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
53  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
54  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
55  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
56  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
57  `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
58  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
59  PRIMARY KEY (`Host`,`Db`,`User`),
60  KEY `User` (`User`)
61) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges'
62show create table user;
63Table	Create Table
64user	CREATE TABLE `user` (
65  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
66  `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
67  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
68  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
69  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
70  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
71  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
72  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
73  `Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
74  `Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
75  `Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
76  `File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
77  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
78  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
79  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
80  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
81  `Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
82  `Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
83  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
84  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
85  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
86  `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
87  `Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
88  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
89  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
90  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
91  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
92  `Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
93  `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
94  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
95  `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
96  `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',
97  `ssl_cipher` blob NOT NULL,
98  `x509_issuer` blob NOT NULL,
99  `x509_subject` blob NOT NULL,
100  `max_questions` int(11) unsigned NOT NULL DEFAULT '0',
101  `max_updates` int(11) unsigned NOT NULL DEFAULT '0',
102  `max_connections` int(11) unsigned NOT NULL DEFAULT '0',
103  `max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',
104  `plugin` char(64) COLLATE utf8_bin NOT NULL DEFAULT 'mysql_native_password',
105  `authentication_string` text COLLATE utf8_bin,
106  `password_expired` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
107  `password_last_changed` timestamp NULL DEFAULT NULL,
108  `password_lifetime` smallint(5) unsigned DEFAULT NULL,
109  `account_locked` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
110  PRIMARY KEY (`Host`,`User`)
111) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges'
112show create table func;
113Table	Create Table
114func	CREATE TABLE `func` (
115  `name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
116  `ret` tinyint(1) NOT NULL DEFAULT '0',
117  `dl` char(128) COLLATE utf8_bin NOT NULL DEFAULT '',
118  `type` enum('function','aggregate') CHARACTER SET utf8 NOT NULL,
119  PRIMARY KEY (`name`)
120) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User defined functions'
121show create table tables_priv;
122Table	Create Table
123tables_priv	CREATE TABLE `tables_priv` (
124  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
125  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
126  `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
127  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
128  `Grantor` char(93) COLLATE utf8_bin NOT NULL DEFAULT '',
129  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
130  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 NOT NULL DEFAULT '',
131  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
132  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
133  KEY `Grantor` (`Grantor`)
134) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges'
135show create table columns_priv;
136Table	Create Table
137columns_priv	CREATE TABLE `columns_priv` (
138  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
139  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
140  `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
141  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
142  `Column_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
143  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
144  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
145  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
146) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges'
147show create table procs_priv;
148Table	Create Table
149procs_priv	CREATE TABLE `procs_priv` (
150  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
151  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
152  `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
153  `Routine_name` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
154  `Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,
155  `Grantor` char(93) COLLATE utf8_bin NOT NULL DEFAULT '',
156  `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',
157  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
158  PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
159  KEY `Grantor` (`Grantor`)
160) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges'
161show create table servers;
162Table	Create Table
163servers	CREATE TABLE `servers` (
164  `Server_name` char(64) NOT NULL DEFAULT '',
165  `Host` char(64) NOT NULL DEFAULT '',
166  `Db` char(64) NOT NULL DEFAULT '',
167  `Username` char(64) NOT NULL DEFAULT '',
168  `Password` char(64) NOT NULL DEFAULT '',
169  `Port` int(4) NOT NULL DEFAULT '0',
170  `Socket` char(64) NOT NULL DEFAULT '',
171  `Wrapper` char(64) NOT NULL DEFAULT '',
172  `Owner` char(64) NOT NULL DEFAULT '',
173  PRIMARY KEY (`Server_name`)
174) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='MySQL Foreign Servers table'
175show create table proc;
176Table	Create Table
177proc	CREATE TABLE `proc` (
178  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
179  `name` char(64) NOT NULL DEFAULT '',
180  `type` enum('FUNCTION','PROCEDURE') NOT NULL,
181  `specific_name` char(64) NOT NULL DEFAULT '',
182  `language` enum('SQL') NOT NULL DEFAULT 'SQL',
183  `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
184  `is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',
185  `security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
186  `param_list` blob NOT NULL,
187  `returns` longblob NOT NULL,
188  `body` longblob NOT NULL,
189  `definer` char(93) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
190  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
191  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
192  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
193  `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
194  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
195  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
196  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
197  `body_utf8` longblob,
198  PRIMARY KEY (`db`,`name`,`type`)
199) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures'
200show create table event;
201Table	Create Table
202event	CREATE TABLE `event` (
203  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
204  `name` char(64) NOT NULL DEFAULT '',
205  `body` longblob NOT NULL,
206  `definer` char(93) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
207  `execute_at` datetime DEFAULT NULL,
208  `interval_value` int(11) DEFAULT NULL,
209  `interval_field` 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') DEFAULT NULL,
210  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
211  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
212  `last_executed` datetime DEFAULT NULL,
213  `starts` datetime DEFAULT NULL,
214  `ends` datetime DEFAULT NULL,
215  `status` enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') NOT NULL DEFAULT 'ENABLED',
216  `on_completion` enum('DROP','PRESERVE') NOT NULL DEFAULT 'DROP',
217  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
218  `comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
219  `originator` int(10) unsigned NOT NULL,
220  `time_zone` char(64) CHARACTER SET latin1 NOT NULL DEFAULT 'SYSTEM',
221  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
222  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
223  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
224  `body_utf8` longblob,
225  PRIMARY KEY (`db`,`name`)
226) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Events'
227show create table general_log;
228Table	Create Table
229general_log	CREATE TABLE `general_log` (
230  `event_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
231  `user_host` mediumtext NOT NULL,
232  `thread_id` bigint(21) unsigned NOT NULL,
233  `server_id` int(10) unsigned NOT NULL,
234  `command_type` varchar(64) NOT NULL,
235  `argument` mediumblob NOT NULL
236) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='General log'
237show create table slow_log;
238Table	Create Table
239slow_log	CREATE TABLE `slow_log` (
240  `start_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
241  `user_host` mediumtext NOT NULL,
242  `query_time` time(6) NOT NULL,
243  `lock_time` time(6) NOT NULL,
244  `rows_sent` int(11) NOT NULL,
245  `rows_examined` int(11) NOT NULL,
246  `db` varchar(512) NOT NULL,
247  `last_insert_id` int(11) NOT NULL,
248  `insert_id` int(11) NOT NULL,
249  `server_id` int(10) unsigned NOT NULL,
250  `sql_text` mediumblob NOT NULL,
251  `thread_id` bigint(21) unsigned NOT NULL
252) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log'
253show tables;
254Tables_in_test
255SET sql_mode = default;
256