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