Debian Codegraph @

mysql-test/suite/funcs_1/r/is_tables_mysql_embedded.result

raw
1 DROP DATABASE IF EXISTS test1;
2 CREATE DATABASE test1;
3 SELECT *,
4 LEFT( table_comment,
5 IF(INSTR(table_comment,'InnoDB free') = 0,
6 LENGTH(table_comment),
7 INSTR(table_comment,'InnoDB free') - 1))
8 AS "user_comment",
9 '-----------------------------------------------------' AS "Separator"
10 FROM information_schema.tables
11 WHERE table_schema = 'mysql'
12 ORDER BY table_schema,table_name;
13 TABLE_CATALOG def
14 TABLE_SCHEMA mysql
15 TABLE_NAME columns_priv
16 TABLE_TYPE BASE TABLE
17 ENGINE MYISAM_OR_MARIA
18 VERSION 10
19 ROW_FORMAT DYNAMIC_OR_PAGE
20 TABLE_ROWS #TBLR#
21 AVG_ROW_LENGTH #ARL#
22 DATA_LENGTH #DL#
23 MAX_DATA_LENGTH #MDL#
24 INDEX_LENGTH #IL#
25 DATA_FREE #DF#
26 AUTO_INCREMENT NULL
27 CREATE_TIME #CRT#
28 UPDATE_TIME #UT#
29 CHECK_TIME #CT#
30 TABLE_COLLATION utf8mb3_bin
31 CHECKSUM NULL
32 CREATE_OPTIONS #CO#
33 TABLE_COMMENT #TC#
34 MAX_INDEX_LENGTH #MIL#
35 TEMPORARY N
36 user_comment Column privileges
37 Separator -----------------------------------------------------
38 TABLE_CATALOG def
39 TABLE_SCHEMA mysql
40 TABLE_NAME column_stats
41 TABLE_TYPE BASE TABLE
42 ENGINE MYISAM_OR_MARIA
43 VERSION 10
44 ROW_FORMAT DYNAMIC_OR_PAGE
45 TABLE_ROWS #TBLR#
46 AVG_ROW_LENGTH #ARL#
47 DATA_LENGTH #DL#
48 MAX_DATA_LENGTH #MDL#
49 INDEX_LENGTH #IL#
50 DATA_FREE #DF#
51 AUTO_INCREMENT NULL
52 CREATE_TIME #CRT#
53 UPDATE_TIME #UT#
54 CHECK_TIME #CT#
55 TABLE_COLLATION utf8mb3_bin
56 CHECKSUM NULL
57 CREATE_OPTIONS #CO#
58 TABLE_COMMENT #TC#
59 MAX_INDEX_LENGTH #MIL#
60 TEMPORARY N
61 user_comment Statistics on Columns
62 Separator -----------------------------------------------------
63 TABLE_CATALOG def
64 TABLE_SCHEMA mysql
65 TABLE_NAME db
66 TABLE_TYPE BASE TABLE
67 ENGINE MYISAM_OR_MARIA
68 VERSION 10
69 ROW_FORMAT DYNAMIC_OR_PAGE
70 TABLE_ROWS #TBLR#
71 AVG_ROW_LENGTH #ARL#
72 DATA_LENGTH #DL#
73 MAX_DATA_LENGTH #MDL#
74 INDEX_LENGTH #IL#
75 DATA_FREE #DF#
76 AUTO_INCREMENT NULL
77 CREATE_TIME #CRT#
78 UPDATE_TIME #UT#
79 CHECK_TIME #CT#
80 TABLE_COLLATION utf8mb3_bin
81 CHECKSUM NULL
82 CREATE_OPTIONS #CO#
83 TABLE_COMMENT #TC#
84 MAX_INDEX_LENGTH #MIL#
85 TEMPORARY N
86 user_comment Database privileges
87 Separator -----------------------------------------------------
88 TABLE_CATALOG def
89 TABLE_SCHEMA mysql
90 TABLE_NAME event
91 TABLE_TYPE BASE TABLE
92 ENGINE MYISAM_OR_MARIA
93 VERSION 10
94 ROW_FORMAT DYNAMIC_OR_PAGE
95 TABLE_ROWS #TBLR#
96 AVG_ROW_LENGTH #ARL#
97 DATA_LENGTH #DL#
98 MAX_DATA_LENGTH #MDL#
99 INDEX_LENGTH #IL#
100 DATA_FREE #DF#
101 AUTO_INCREMENT NULL
102 CREATE_TIME #CRT#
103 UPDATE_TIME #UT#
104 CHECK_TIME #CT#
105 TABLE_COLLATION utf8mb3_general_ci
106 CHECKSUM NULL
107 CREATE_OPTIONS #CO#
108 TABLE_COMMENT #TC#
109 MAX_INDEX_LENGTH #MIL#
110 TEMPORARY N
111 user_comment Events
112 Separator -----------------------------------------------------
113 TABLE_CATALOG def
114 TABLE_SCHEMA mysql
115 TABLE_NAME func
116 TABLE_TYPE BASE TABLE
117 ENGINE MYISAM_OR_MARIA
118 VERSION 10
119 ROW_FORMAT DYNAMIC_OR_PAGE
120 TABLE_ROWS #TBLR#
121 AVG_ROW_LENGTH #ARL#
122 DATA_LENGTH #DL#
123 MAX_DATA_LENGTH #MDL#
124 INDEX_LENGTH #IL#
125 DATA_FREE #DF#
126 AUTO_INCREMENT NULL
127 CREATE_TIME #CRT#
128 UPDATE_TIME #UT#
129 CHECK_TIME #CT#
130 TABLE_COLLATION utf8mb3_bin
131 CHECKSUM NULL
132 CREATE_OPTIONS #CO#
133 TABLE_COMMENT #TC#
134 MAX_INDEX_LENGTH #MIL#
135 TEMPORARY N
136 user_comment User defined functions
137 Separator -----------------------------------------------------
138 TABLE_CATALOG def
139 TABLE_SCHEMA mysql
140 TABLE_NAME general_log
141 TABLE_TYPE BASE TABLE
142 ENGINE CSV
143 VERSION 10
144 ROW_FORMAT DYNAMIC_OR_PAGE
145 TABLE_ROWS #TBLR#
146 AVG_ROW_LENGTH #ARL#
147 DATA_LENGTH #DL#
148 MAX_DATA_LENGTH #MDL#
149 INDEX_LENGTH #IL#
150 DATA_FREE #DF#
151 AUTO_INCREMENT NULL
152 CREATE_TIME #CRT#
153 UPDATE_TIME #UT#
154 CHECK_TIME #CT#
155 TABLE_COLLATION utf8mb3_general_ci
156 CHECKSUM NULL
157 CREATE_OPTIONS #CO#
158 TABLE_COMMENT #TC#
159 MAX_INDEX_LENGTH #MIL#
160 TEMPORARY N
161 user_comment General log
162 Separator -----------------------------------------------------
163 TABLE_CATALOG def
164 TABLE_SCHEMA mysql
165 TABLE_NAME global_priv
166 TABLE_TYPE BASE TABLE
167 ENGINE MYISAM_OR_MARIA
168 VERSION 11
169 ROW_FORMAT DYNAMIC_OR_PAGE
170 TABLE_ROWS #TBLR#
171 AVG_ROW_LENGTH #ARL#
172 DATA_LENGTH #DL#
173 MAX_DATA_LENGTH #MDL#
174 INDEX_LENGTH #IL#
175 DATA_FREE #DF#
176 AUTO_INCREMENT NULL
177 CREATE_TIME #CRT#
178 UPDATE_TIME #UT#
179 CHECK_TIME #CT#
180 TABLE_COLLATION utf8mb3_bin
181 CHECKSUM NULL
182 CREATE_OPTIONS #CO#
183 TABLE_COMMENT #TC#
184 MAX_INDEX_LENGTH #MIL#
185 TEMPORARY N
186 user_comment Users and global privileges
187 Separator -----------------------------------------------------
188 TABLE_CATALOG def
189 TABLE_SCHEMA mysql
190 TABLE_NAME gtid_slave_pos
191 TABLE_TYPE BASE TABLE
192 ENGINE MYISAM_OR_MARIA
193 VERSION 10
194 ROW_FORMAT DYNAMIC_OR_PAGE
195 TABLE_ROWS #TBLR#
196 AVG_ROW_LENGTH #ARL#
197 DATA_LENGTH #DL#
198 MAX_DATA_LENGTH #MDL#
199 INDEX_LENGTH #IL#
200 DATA_FREE #DF#
201 AUTO_INCREMENT NULL
202 CREATE_TIME #CRT#
203 UPDATE_TIME #UT#
204 CHECK_TIME #CT#
205 TABLE_COLLATION latin1_swedish_ci
206 CHECKSUM NULL
207 CREATE_OPTIONS #CO#
208 TABLE_COMMENT #TC#
209 MAX_INDEX_LENGTH #MIL#
210 TEMPORARY N
211 user_comment Replication slave GTID position
212 Separator -----------------------------------------------------
213 TABLE_CATALOG def
214 TABLE_SCHEMA mysql
215 TABLE_NAME help_category
216 TABLE_TYPE BASE TABLE
217 ENGINE MYISAM_OR_MARIA
218 VERSION 10
219 ROW_FORMAT DYNAMIC_OR_PAGE
220 TABLE_ROWS #TBLR#
221 AVG_ROW_LENGTH #ARL#
222 DATA_LENGTH #DL#
223 MAX_DATA_LENGTH #MDL#
224 INDEX_LENGTH #IL#
225 DATA_FREE #DF#
226 AUTO_INCREMENT NULL
227 CREATE_TIME #CRT#
228 UPDATE_TIME #UT#
229 CHECK_TIME #CT#
230 TABLE_COLLATION utf8mb3_general_ci
231 CHECKSUM NULL
232 CREATE_OPTIONS #CO#
233 TABLE_COMMENT #TC#
234 MAX_INDEX_LENGTH #MIL#
235 TEMPORARY N
236 user_comment help categories
237 Separator -----------------------------------------------------
238 TABLE_CATALOG def
239 TABLE_SCHEMA mysql
240 TABLE_NAME help_keyword
241 TABLE_TYPE BASE TABLE
242 ENGINE MYISAM_OR_MARIA
243 VERSION 10
244 ROW_FORMAT DYNAMIC_OR_PAGE
245 TABLE_ROWS #TBLR#
246 AVG_ROW_LENGTH #ARL#
247 DATA_LENGTH #DL#
248 MAX_DATA_LENGTH #MDL#
249 INDEX_LENGTH #IL#
250 DATA_FREE #DF#
251 AUTO_INCREMENT NULL
252 CREATE_TIME #CRT#
253 UPDATE_TIME #UT#
254 CHECK_TIME #CT#
255 TABLE_COLLATION utf8mb3_general_ci
256 CHECKSUM NULL
257 CREATE_OPTIONS #CO#
258 TABLE_COMMENT #TC#
259 MAX_INDEX_LENGTH #MIL#
260 TEMPORARY N
261 user_comment help keywords
262 Separator -----------------------------------------------------
263 TABLE_CATALOG def
264 TABLE_SCHEMA mysql
265 TABLE_NAME help_relation
266 TABLE_TYPE BASE TABLE
267 ENGINE MYISAM_OR_MARIA
268 VERSION 10
269 ROW_FORMAT DYNAMIC_OR_PAGE
270 TABLE_ROWS #TBLR#
271 AVG_ROW_LENGTH #ARL#
272 DATA_LENGTH #DL#
273 MAX_DATA_LENGTH #MDL#
274 INDEX_LENGTH #IL#
275 DATA_FREE #DF#
276 AUTO_INCREMENT NULL
277 CREATE_TIME #CRT#
278 UPDATE_TIME #UT#
279 CHECK_TIME #CT#
280 TABLE_COLLATION utf8mb3_general_ci
281 CHECKSUM NULL
282 CREATE_OPTIONS #CO#
283 TABLE_COMMENT #TC#
284 MAX_INDEX_LENGTH #MIL#
285 TEMPORARY N
286 user_comment keyword-topic relation
287 Separator -----------------------------------------------------
288 TABLE_CATALOG def
289 TABLE_SCHEMA mysql
290 TABLE_NAME help_topic
291 TABLE_TYPE BASE TABLE
292 ENGINE MYISAM_OR_MARIA
293 VERSION 10
294 ROW_FORMAT DYNAMIC_OR_PAGE
295 TABLE_ROWS #TBLR#
296 AVG_ROW_LENGTH #ARL#
297 DATA_LENGTH #DL#
298 MAX_DATA_LENGTH #MDL#
299 INDEX_LENGTH #IL#
300 DATA_FREE #DF#
301 AUTO_INCREMENT NULL
302 CREATE_TIME #CRT#
303 UPDATE_TIME #UT#
304 CHECK_TIME #CT#
305 TABLE_COLLATION utf8mb3_general_ci
306 CHECKSUM NULL
307 CREATE_OPTIONS #CO#
308 TABLE_COMMENT #TC#
309 MAX_INDEX_LENGTH #MIL#
310 TEMPORARY N
311 user_comment help topics
312 Separator -----------------------------------------------------
313 TABLE_CATALOG def
314 TABLE_SCHEMA mysql
315 TABLE_NAME index_stats
316 TABLE_TYPE BASE TABLE
317 ENGINE MYISAM_OR_MARIA
318 VERSION 10
319 ROW_FORMAT DYNAMIC_OR_PAGE
320 TABLE_ROWS #TBLR#
321 AVG_ROW_LENGTH #ARL#
322 DATA_LENGTH #DL#
323 MAX_DATA_LENGTH #MDL#
324 INDEX_LENGTH #IL#
325 DATA_FREE #DF#
326 AUTO_INCREMENT NULL
327 CREATE_TIME #CRT#
328 UPDATE_TIME #UT#
329 CHECK_TIME #CT#
330 TABLE_COLLATION utf8mb3_bin
331 CHECKSUM NULL
332 CREATE_OPTIONS #CO#
333 TABLE_COMMENT #TC#
334 MAX_INDEX_LENGTH #MIL#
335 TEMPORARY N
336 user_comment Statistics on Indexes
337 Separator -----------------------------------------------------
338 TABLE_CATALOG def
339 TABLE_SCHEMA mysql
340 TABLE_NAME innodb_index_stats
341 TABLE_TYPE BASE TABLE
342 ENGINE InnoDB
343 VERSION 10
344 ROW_FORMAT DYNAMIC_OR_PAGE
345 TABLE_ROWS #TBLR#
346 AVG_ROW_LENGTH #ARL#
347 DATA_LENGTH #DL#
348 MAX_DATA_LENGTH #MDL#
349 INDEX_LENGTH #IL#
350 DATA_FREE #DF#
351 AUTO_INCREMENT NULL
352 CREATE_TIME #CRT#
353 UPDATE_TIME #UT#
354 CHECK_TIME #CT#
355 TABLE_COLLATION utf8mb3_bin
356 CHECKSUM NULL
357 CREATE_OPTIONS #CO#
358 TABLE_COMMENT #TC#
359 MAX_INDEX_LENGTH #MIL#
360 TEMPORARY N
361 user_comment
362 Separator -----------------------------------------------------
363 TABLE_CATALOG def
364 TABLE_SCHEMA mysql
365 TABLE_NAME innodb_table_stats
366 TABLE_TYPE BASE TABLE
367 ENGINE InnoDB
368 VERSION 10
369 ROW_FORMAT DYNAMIC_OR_PAGE
370 TABLE_ROWS #TBLR#
371 AVG_ROW_LENGTH #ARL#
372 DATA_LENGTH #DL#
373 MAX_DATA_LENGTH #MDL#
374 INDEX_LENGTH #IL#
375 DATA_FREE #DF#
376 AUTO_INCREMENT NULL
377 CREATE_TIME #CRT#
378 UPDATE_TIME #UT#
379 CHECK_TIME #CT#
380 TABLE_COLLATION utf8mb3_bin
381 CHECKSUM NULL
382 CREATE_OPTIONS #CO#
383 TABLE_COMMENT #TC#
384 MAX_INDEX_LENGTH #MIL#
385 TEMPORARY N
386 user_comment
387 Separator -----------------------------------------------------
388 TABLE_CATALOG def
389 TABLE_SCHEMA mysql
390 TABLE_NAME plugin
391 TABLE_TYPE BASE TABLE
392 ENGINE MYISAM_OR_MARIA
393 VERSION 10
394 ROW_FORMAT DYNAMIC_OR_PAGE
395 TABLE_ROWS #TBLR#
396 AVG_ROW_LENGTH #ARL#
397 DATA_LENGTH #DL#
398 MAX_DATA_LENGTH #MDL#
399 INDEX_LENGTH #IL#
400 DATA_FREE #DF#
401 AUTO_INCREMENT NULL
402 CREATE_TIME #CRT#
403 UPDATE_TIME #UT#
404 CHECK_TIME #CT#
405 TABLE_COLLATION utf8mb3_general_ci
406 CHECKSUM NULL
407 CREATE_OPTIONS #CO#
408 TABLE_COMMENT #TC#
409 MAX_INDEX_LENGTH #MIL#
410 TEMPORARY N
411 user_comment MySQL plugins
412 Separator -----------------------------------------------------
413 TABLE_CATALOG def
414 TABLE_SCHEMA mysql
415 TABLE_NAME proc
416 TABLE_TYPE BASE TABLE
417 ENGINE MYISAM_OR_MARIA
418 VERSION 10
419 ROW_FORMAT DYNAMIC_OR_PAGE
420 TABLE_ROWS #TBLR#
421 AVG_ROW_LENGTH #ARL#
422 DATA_LENGTH #DL#
423 MAX_DATA_LENGTH #MDL#
424 INDEX_LENGTH #IL#
425 DATA_FREE #DF#
426 AUTO_INCREMENT NULL
427 CREATE_TIME #CRT#
428 UPDATE_TIME #UT#
429 CHECK_TIME #CT#
430 TABLE_COLLATION utf8mb3_general_ci
431 CHECKSUM NULL
432 CREATE_OPTIONS #CO#
433 TABLE_COMMENT #TC#
434 MAX_INDEX_LENGTH #MIL#
435 TEMPORARY N
436 user_comment Stored Procedures
437 Separator -----------------------------------------------------
438 TABLE_CATALOG def
439 TABLE_SCHEMA mysql
440 TABLE_NAME procs_priv
441 TABLE_TYPE BASE TABLE
442 ENGINE MYISAM_OR_MARIA
443 VERSION 10
444 ROW_FORMAT DYNAMIC_OR_PAGE
445 TABLE_ROWS #TBLR#
446 AVG_ROW_LENGTH #ARL#
447 DATA_LENGTH #DL#
448 MAX_DATA_LENGTH #MDL#
449 INDEX_LENGTH #IL#
450 DATA_FREE #DF#
451 AUTO_INCREMENT NULL
452 CREATE_TIME #CRT#
453 UPDATE_TIME #UT#
454 CHECK_TIME #CT#
455 TABLE_COLLATION utf8mb3_bin
456 CHECKSUM NULL
457 CREATE_OPTIONS #CO#
458 TABLE_COMMENT #TC#
459 MAX_INDEX_LENGTH #MIL#
460 TEMPORARY N
461 user_comment Procedure privileges
462 Separator -----------------------------------------------------
463 TABLE_CATALOG def
464 TABLE_SCHEMA mysql
465 TABLE_NAME proxies_priv
466 TABLE_TYPE BASE TABLE
467 ENGINE MYISAM_OR_MARIA
468 VERSION 10
469 ROW_FORMAT DYNAMIC_OR_PAGE
470 TABLE_ROWS #TBLR#
471 AVG_ROW_LENGTH #ARL#
472 DATA_LENGTH #DL#
473 MAX_DATA_LENGTH #MDL#
474 INDEX_LENGTH #IL#
475 DATA_FREE #DF#
476 AUTO_INCREMENT NULL
477 CREATE_TIME #CRT#
478 UPDATE_TIME #UT#
479 CHECK_TIME #CT#
480 TABLE_COLLATION utf8mb3_bin
481 CHECKSUM NULL
482 CREATE_OPTIONS #CO#
483 TABLE_COMMENT #TC#
484 MAX_INDEX_LENGTH #MIL#
485 TEMPORARY N
486 user_comment User proxy privileges
487 Separator -----------------------------------------------------
488 TABLE_CATALOG def
489 TABLE_SCHEMA mysql
490 TABLE_NAME roles_mapping
491 TABLE_TYPE BASE TABLE
492 ENGINE MYISAM_OR_MARIA
493 VERSION 10
494 ROW_FORMAT DYNAMIC_OR_PAGE
495 TABLE_ROWS #TBLR#
496 AVG_ROW_LENGTH #ARL#
497 DATA_LENGTH #DL#
498 MAX_DATA_LENGTH #MDL#
499 INDEX_LENGTH #IL#
500 DATA_FREE #DF#
501 AUTO_INCREMENT NULL
502 CREATE_TIME #CRT#
503 UPDATE_TIME #UT#
504 CHECK_TIME #CT#
505 TABLE_COLLATION utf8mb3_bin
506 CHECKSUM NULL
507 CREATE_OPTIONS #CO#
508 TABLE_COMMENT #TC#
509 MAX_INDEX_LENGTH #MIL#
510 TEMPORARY N
511 user_comment Granted roles
512 Separator -----------------------------------------------------
513 TABLE_CATALOG def
514 TABLE_SCHEMA mysql
515 TABLE_NAME servers
516 TABLE_TYPE BASE TABLE
517 ENGINE MYISAM_OR_MARIA
518 VERSION 11
519 ROW_FORMAT DYNAMIC_OR_PAGE
520 TABLE_ROWS #TBLR#
521 AVG_ROW_LENGTH #ARL#
522 DATA_LENGTH #DL#
523 MAX_DATA_LENGTH #MDL#
524 INDEX_LENGTH #IL#
525 DATA_FREE #DF#
526 AUTO_INCREMENT NULL
527 CREATE_TIME #CRT#
528 UPDATE_TIME #UT#
529 CHECK_TIME #CT#
530 TABLE_COLLATION utf8mb3_general_ci
531 CHECKSUM NULL
532 CREATE_OPTIONS #CO#
533 TABLE_COMMENT #TC#
534 MAX_INDEX_LENGTH #MIL#
535 TEMPORARY N
536 user_comment MySQL Foreign Servers table
537 Separator -----------------------------------------------------
538 TABLE_CATALOG def
539 TABLE_SCHEMA mysql
540 TABLE_NAME slow_log
541 TABLE_TYPE BASE TABLE
542 ENGINE CSV
543 VERSION 10
544 ROW_FORMAT DYNAMIC_OR_PAGE
545 TABLE_ROWS #TBLR#
546 AVG_ROW_LENGTH #ARL#
547 DATA_LENGTH #DL#
548 MAX_DATA_LENGTH #MDL#
549 INDEX_LENGTH #IL#
550 DATA_FREE #DF#
551 AUTO_INCREMENT NULL
552 CREATE_TIME #CRT#
553 UPDATE_TIME #UT#
554 CHECK_TIME #CT#
555 TABLE_COLLATION utf8mb3_general_ci
556 CHECKSUM NULL
557 CREATE_OPTIONS #CO#
558 TABLE_COMMENT #TC#
559 MAX_INDEX_LENGTH #MIL#
560 TEMPORARY N
561 user_comment Slow log
562 Separator -----------------------------------------------------
563 TABLE_CATALOG def
564 TABLE_SCHEMA mysql
565 TABLE_NAME tables_priv
566 TABLE_TYPE BASE TABLE
567 ENGINE MYISAM_OR_MARIA
568 VERSION 10
569 ROW_FORMAT DYNAMIC_OR_PAGE
570 TABLE_ROWS #TBLR#
571 AVG_ROW_LENGTH #ARL#
572 DATA_LENGTH #DL#
573 MAX_DATA_LENGTH #MDL#
574 INDEX_LENGTH #IL#
575 DATA_FREE #DF#
576 AUTO_INCREMENT NULL
577 CREATE_TIME #CRT#
578 UPDATE_TIME #UT#
579 CHECK_TIME #CT#
580 TABLE_COLLATION utf8mb3_bin
581 CHECKSUM NULL
582 CREATE_OPTIONS #CO#
583 TABLE_COMMENT #TC#
584 MAX_INDEX_LENGTH #MIL#
585 TEMPORARY N
586 user_comment Table privileges
587 Separator -----------------------------------------------------
588 TABLE_CATALOG def
589 TABLE_SCHEMA mysql
590 TABLE_NAME table_stats
591 TABLE_TYPE BASE TABLE
592 ENGINE MYISAM_OR_MARIA
593 VERSION 10
594 ROW_FORMAT DYNAMIC_OR_PAGE
595 TABLE_ROWS #TBLR#
596 AVG_ROW_LENGTH #ARL#
597 DATA_LENGTH #DL#
598 MAX_DATA_LENGTH #MDL#
599 INDEX_LENGTH #IL#
600 DATA_FREE #DF#
601 AUTO_INCREMENT NULL
602 CREATE_TIME #CRT#
603 UPDATE_TIME #UT#
604 CHECK_TIME #CT#
605 TABLE_COLLATION utf8mb3_bin
606 CHECKSUM NULL
607 CREATE_OPTIONS #CO#
608 TABLE_COMMENT #TC#
609 MAX_INDEX_LENGTH #MIL#
610 TEMPORARY N
611 user_comment Statistics on Tables
612 Separator -----------------------------------------------------
613 TABLE_CATALOG def
614 TABLE_SCHEMA mysql
615 TABLE_NAME time_zone
616 TABLE_TYPE BASE TABLE
617 ENGINE MYISAM_OR_MARIA
618 VERSION 10
619 ROW_FORMAT DYNAMIC_OR_PAGE
620 TABLE_ROWS #TBLR#
621 AVG_ROW_LENGTH #ARL#
622 DATA_LENGTH #DL#
623 MAX_DATA_LENGTH #MDL#
624 INDEX_LENGTH #IL#
625 DATA_FREE #DF#
626 AUTO_INCREMENT 7
627 CREATE_TIME #CRT#
628 UPDATE_TIME #UT#
629 CHECK_TIME #CT#
630 TABLE_COLLATION utf8mb3_general_ci
631 CHECKSUM NULL
632 CREATE_OPTIONS #CO#
633 TABLE_COMMENT #TC#
634 MAX_INDEX_LENGTH #MIL#
635 TEMPORARY N
636 user_comment Time zones
637 Separator -----------------------------------------------------
638 TABLE_CATALOG def
639 TABLE_SCHEMA mysql
640 TABLE_NAME time_zone_leap_second
641 TABLE_TYPE BASE TABLE
642 ENGINE MYISAM_OR_MARIA
643 VERSION 10
644 ROW_FORMAT DYNAMIC_OR_PAGE
645 TABLE_ROWS #TBLR#
646 AVG_ROW_LENGTH #ARL#
647 DATA_LENGTH #DL#
648 MAX_DATA_LENGTH #MDL#
649 INDEX_LENGTH #IL#
650 DATA_FREE #DF#
651 AUTO_INCREMENT NULL
652 CREATE_TIME #CRT#
653 UPDATE_TIME #UT#
654 CHECK_TIME #CT#
655 TABLE_COLLATION utf8mb3_general_ci
656 CHECKSUM NULL
657 CREATE_OPTIONS #CO#
658 TABLE_COMMENT #TC#
659 MAX_INDEX_LENGTH #MIL#
660 TEMPORARY N
661 user_comment Leap seconds information for time zones
662 Separator -----------------------------------------------------
663 TABLE_CATALOG def
664 TABLE_SCHEMA mysql
665 TABLE_NAME time_zone_name
666 TABLE_TYPE BASE TABLE
667 ENGINE MYISAM_OR_MARIA
668 VERSION 10
669 ROW_FORMAT DYNAMIC_OR_PAGE
670 TABLE_ROWS #TBLR#
671 AVG_ROW_LENGTH #ARL#
672 DATA_LENGTH #DL#
673 MAX_DATA_LENGTH #MDL#
674 INDEX_LENGTH #IL#
675 DATA_FREE #DF#
676 AUTO_INCREMENT NULL
677 CREATE_TIME #CRT#
678 UPDATE_TIME #UT#
679 CHECK_TIME #CT#
680 TABLE_COLLATION utf8mb3_general_ci
681 CHECKSUM NULL
682 CREATE_OPTIONS #CO#
683 TABLE_COMMENT #TC#
684 MAX_INDEX_LENGTH #MIL#
685 TEMPORARY N
686 user_comment Time zone names
687 Separator -----------------------------------------------------
688 TABLE_CATALOG def
689 TABLE_SCHEMA mysql
690 TABLE_NAME time_zone_transition
691 TABLE_TYPE BASE TABLE
692 ENGINE MYISAM_OR_MARIA
693 VERSION 10
694 ROW_FORMAT DYNAMIC_OR_PAGE
695 TABLE_ROWS #TBLR#
696 AVG_ROW_LENGTH #ARL#
697 DATA_LENGTH #DL#
698 MAX_DATA_LENGTH #MDL#
699 INDEX_LENGTH #IL#
700 DATA_FREE #DF#
701 AUTO_INCREMENT NULL
702 CREATE_TIME #CRT#
703 UPDATE_TIME #UT#
704 CHECK_TIME #CT#
705 TABLE_COLLATION utf8mb3_general_ci
706 CHECKSUM NULL
707 CREATE_OPTIONS #CO#
708 TABLE_COMMENT #TC#
709 MAX_INDEX_LENGTH #MIL#
710 TEMPORARY N
711 user_comment Time zone transitions
712 Separator -----------------------------------------------------
713 TABLE_CATALOG def
714 TABLE_SCHEMA mysql
715 TABLE_NAME time_zone_transition_type
716 TABLE_TYPE BASE TABLE
717 ENGINE MYISAM_OR_MARIA
718 VERSION 10
719 ROW_FORMAT DYNAMIC_OR_PAGE
720 TABLE_ROWS #TBLR#
721 AVG_ROW_LENGTH #ARL#
722 DATA_LENGTH #DL#
723 MAX_DATA_LENGTH #MDL#
724 INDEX_LENGTH #IL#
725 DATA_FREE #DF#
726 AUTO_INCREMENT NULL
727 CREATE_TIME #CRT#
728 UPDATE_TIME #UT#
729 CHECK_TIME #CT#
730 TABLE_COLLATION utf8mb3_general_ci
731 CHECKSUM NULL
732 CREATE_OPTIONS #CO#
733 TABLE_COMMENT #TC#
734 MAX_INDEX_LENGTH #MIL#
735 TEMPORARY N
736 user_comment Time zone transition types
737 Separator -----------------------------------------------------
738 TABLE_CATALOG def
739 TABLE_SCHEMA mysql
740 TABLE_NAME transaction_registry
741 TABLE_TYPE BASE TABLE
742 ENGINE InnoDB
743 VERSION 10
744 ROW_FORMAT DYNAMIC_OR_PAGE
745 TABLE_ROWS #TBLR#
746 AVG_ROW_LENGTH #ARL#
747 DATA_LENGTH #DL#
748 MAX_DATA_LENGTH #MDL#
749 INDEX_LENGTH #IL#
750 DATA_FREE #DF#
751 AUTO_INCREMENT NULL
752 CREATE_TIME #CRT#
753 UPDATE_TIME #UT#
754 CHECK_TIME #CT#
755 TABLE_COLLATION utf8mb3_bin
756 CHECKSUM NULL
757 CREATE_OPTIONS #CO#
758 TABLE_COMMENT #TC#
759 MAX_INDEX_LENGTH #MIL#
760 TEMPORARY N
761 user_comment
762 Separator -----------------------------------------------------
763 TABLE_CATALOG def
764 TABLE_SCHEMA mysql
765 TABLE_NAME user
766 TABLE_TYPE VIEW
767 ENGINE NULL
768 VERSION NULL
769 ROW_FORMAT NULL
770 TABLE_ROWS #TBLR#
771 AVG_ROW_LENGTH #ARL#
772 DATA_LENGTH #DL#
773 MAX_DATA_LENGTH #MDL#
774 INDEX_LENGTH #IL#
775 DATA_FREE #DF#
776 AUTO_INCREMENT NULL
777 CREATE_TIME #CRT#
778 UPDATE_TIME #UT#
779 CHECK_TIME #CT#
780 TABLE_COLLATION NULL
781 CHECKSUM NULL
782 CREATE_OPTIONS #CO#
783 TABLE_COMMENT #TC#
784 MAX_INDEX_LENGTH #MIL#
785 TEMPORARY NULL
786 user_comment VIEW
787 Separator -----------------------------------------------------
788 DROP USER testuser1@localhost;
789 CREATE USER testuser1@localhost;
790 GRANT SELECT ON test1.* TO testuser1@localhost;
791 connect testuser1,localhost,testuser1,,test1;
792 SELECT *,
793 LEFT( table_comment,
794 IF(INSTR(table_comment,'InnoDB free') = 0,
795 LENGTH(table_comment),
796 INSTR(table_comment,'InnoDB free') - 1))
797 AS "user_comment",
798 '-----------------------------------------------------' AS "Separator"
799 FROM information_schema.tables
800 WHERE table_schema = 'mysql'
801 ORDER BY table_schema,table_name;
802 TABLE_CATALOG def
803 TABLE_SCHEMA mysql
804 TABLE_NAME columns_priv
805 TABLE_TYPE BASE TABLE
806 ENGINE MYISAM_OR_MARIA
807 VERSION 10
808 ROW_FORMAT DYNAMIC_OR_PAGE
809 TABLE_ROWS #TBLR#
810 AVG_ROW_LENGTH #ARL#
811 DATA_LENGTH #DL#
812 MAX_DATA_LENGTH #MDL#
813 INDEX_LENGTH #IL#
814 DATA_FREE #DF#
815 AUTO_INCREMENT NULL
816 CREATE_TIME #CRT#
817 UPDATE_TIME #UT#
818 CHECK_TIME #CT#
819 TABLE_COLLATION utf8mb3_bin
820 CHECKSUM NULL
821 CREATE_OPTIONS #CO#
822 TABLE_COMMENT #TC#
823 MAX_INDEX_LENGTH #MIL#
824 TEMPORARY N
825 user_comment Column privileges
826 Separator -----------------------------------------------------
827 TABLE_CATALOG def
828 TABLE_SCHEMA mysql
829 TABLE_NAME column_stats
830 TABLE_TYPE BASE TABLE
831 ENGINE MYISAM_OR_MARIA
832 VERSION 10
833 ROW_FORMAT DYNAMIC_OR_PAGE
834 TABLE_ROWS #TBLR#
835 AVG_ROW_LENGTH #ARL#
836 DATA_LENGTH #DL#
837 MAX_DATA_LENGTH #MDL#
838 INDEX_LENGTH #IL#
839 DATA_FREE #DF#
840 AUTO_INCREMENT NULL
841 CREATE_TIME #CRT#
842 UPDATE_TIME #UT#
843 CHECK_TIME #CT#
844 TABLE_COLLATION utf8mb3_bin
845 CHECKSUM NULL
846 CREATE_OPTIONS #CO#
847 TABLE_COMMENT #TC#
848 MAX_INDEX_LENGTH #MIL#
849 TEMPORARY N
850 user_comment Statistics on Columns
851 Separator -----------------------------------------------------
852 TABLE_CATALOG def
853 TABLE_SCHEMA mysql
854 TABLE_NAME db
855 TABLE_TYPE BASE TABLE
856 ENGINE MYISAM_OR_MARIA
857 VERSION 10
858 ROW_FORMAT DYNAMIC_OR_PAGE
859 TABLE_ROWS #TBLR#
860 AVG_ROW_LENGTH #ARL#
861 DATA_LENGTH #DL#
862 MAX_DATA_LENGTH #MDL#
863 INDEX_LENGTH #IL#
864 DATA_FREE #DF#
865 AUTO_INCREMENT NULL
866 CREATE_TIME #CRT#
867 UPDATE_TIME #UT#
868 CHECK_TIME #CT#
869 TABLE_COLLATION utf8mb3_bin
870 CHECKSUM NULL
871 CREATE_OPTIONS #CO#
872 TABLE_COMMENT #TC#
873 MAX_INDEX_LENGTH #MIL#
874 TEMPORARY N
875 user_comment Database privileges
876 Separator -----------------------------------------------------
877 TABLE_CATALOG def
878 TABLE_SCHEMA mysql
879 TABLE_NAME event
880 TABLE_TYPE BASE TABLE
881 ENGINE MYISAM_OR_MARIA
882 VERSION 10
883 ROW_FORMAT DYNAMIC_OR_PAGE
884 TABLE_ROWS #TBLR#
885 AVG_ROW_LENGTH #ARL#
886 DATA_LENGTH #DL#
887 MAX_DATA_LENGTH #MDL#
888 INDEX_LENGTH #IL#
889 DATA_FREE #DF#
890 AUTO_INCREMENT NULL
891 CREATE_TIME #CRT#
892 UPDATE_TIME #UT#
893 CHECK_TIME #CT#
894 TABLE_COLLATION utf8mb3_general_ci
895 CHECKSUM NULL
896 CREATE_OPTIONS #CO#
897 TABLE_COMMENT #TC#
898 MAX_INDEX_LENGTH #MIL#
899 TEMPORARY N
900 user_comment Events
901 Separator -----------------------------------------------------
902 TABLE_CATALOG def
903 TABLE_SCHEMA mysql
904 TABLE_NAME func
905 TABLE_TYPE BASE TABLE
906 ENGINE MYISAM_OR_MARIA
907 VERSION 10
908 ROW_FORMAT DYNAMIC_OR_PAGE
909 TABLE_ROWS #TBLR#
910 AVG_ROW_LENGTH #ARL#
911 DATA_LENGTH #DL#
912 MAX_DATA_LENGTH #MDL#
913 INDEX_LENGTH #IL#
914 DATA_FREE #DF#
915 AUTO_INCREMENT NULL
916 CREATE_TIME #CRT#
917 UPDATE_TIME #UT#
918 CHECK_TIME #CT#
919 TABLE_COLLATION utf8mb3_bin
920 CHECKSUM NULL
921 CREATE_OPTIONS #CO#
922 TABLE_COMMENT #TC#
923 MAX_INDEX_LENGTH #MIL#
924 TEMPORARY N
925 user_comment User defined functions
926 Separator -----------------------------------------------------
927 TABLE_CATALOG def
928 TABLE_SCHEMA mysql
929 TABLE_NAME general_log
930 TABLE_TYPE BASE TABLE
931 ENGINE CSV
932 VERSION 10
933 ROW_FORMAT DYNAMIC_OR_PAGE
934 TABLE_ROWS #TBLR#
935 AVG_ROW_LENGTH #ARL#
936 DATA_LENGTH #DL#
937 MAX_DATA_LENGTH #MDL#
938 INDEX_LENGTH #IL#
939 DATA_FREE #DF#
940 AUTO_INCREMENT NULL
941 CREATE_TIME #CRT#
942 UPDATE_TIME #UT#
943 CHECK_TIME #CT#
944 TABLE_COLLATION utf8mb3_general_ci
945 CHECKSUM NULL
946 CREATE_OPTIONS #CO#
947 TABLE_COMMENT #TC#
948 MAX_INDEX_LENGTH #MIL#
949 TEMPORARY N
950 user_comment General log
951 Separator -----------------------------------------------------
952 TABLE_CATALOG def
953 TABLE_SCHEMA mysql
954 TABLE_NAME global_priv
955 TABLE_TYPE BASE TABLE
956 ENGINE MYISAM_OR_MARIA
957 VERSION 11
958 ROW_FORMAT DYNAMIC_OR_PAGE
959 TABLE_ROWS #TBLR#
960 AVG_ROW_LENGTH #ARL#
961 DATA_LENGTH #DL#
962 MAX_DATA_LENGTH #MDL#
963 INDEX_LENGTH #IL#
964 DATA_FREE #DF#
965 AUTO_INCREMENT NULL
966 CREATE_TIME #CRT#
967 UPDATE_TIME #UT#
968 CHECK_TIME #CT#
969 TABLE_COLLATION utf8mb3_bin
970 CHECKSUM NULL
971 CREATE_OPTIONS #CO#
972 TABLE_COMMENT #TC#
973 MAX_INDEX_LENGTH #MIL#
974 TEMPORARY N
975 user_comment Users and global privileges
976 Separator -----------------------------------------------------
977 TABLE_CATALOG def
978 TABLE_SCHEMA mysql
979 TABLE_NAME gtid_slave_pos
980 TABLE_TYPE BASE TABLE
981 ENGINE MYISAM_OR_MARIA
982 VERSION 10
983 ROW_FORMAT DYNAMIC_OR_PAGE
984 TABLE_ROWS #TBLR#
985 AVG_ROW_LENGTH #ARL#
986 DATA_LENGTH #DL#
987 MAX_DATA_LENGTH #MDL#
988 INDEX_LENGTH #IL#
989 DATA_FREE #DF#
990 AUTO_INCREMENT NULL
991 CREATE_TIME #CRT#
992 UPDATE_TIME #UT#
993 CHECK_TIME #CT#
994 TABLE_COLLATION latin1_swedish_ci
995 CHECKSUM NULL
996 CREATE_OPTIONS #CO#
997 TABLE_COMMENT #TC#
998 MAX_INDEX_LENGTH #MIL#
999 TEMPORARY N
1000 user_comment Replication slave GTID position
1001 Separator -----------------------------------------------------
1002 TABLE_CATALOG def
1003 TABLE_SCHEMA mysql
1004 TABLE_NAME help_category
1005 TABLE_TYPE BASE TABLE
1006 ENGINE MYISAM_OR_MARIA
1007 VERSION 10
1008 ROW_FORMAT DYNAMIC_OR_PAGE
1009 TABLE_ROWS #TBLR#
1010 AVG_ROW_LENGTH #ARL#
1011 DATA_LENGTH #DL#
1012 MAX_DATA_LENGTH #MDL#
1013 INDEX_LENGTH #IL#
1014 DATA_FREE #DF#
1015 AUTO_INCREMENT NULL
1016 CREATE_TIME #CRT#
1017 UPDATE_TIME #UT#
1018 CHECK_TIME #CT#
1019 TABLE_COLLATION utf8mb3_general_ci
1020 CHECKSUM NULL
1021 CREATE_OPTIONS #CO#
1022 TABLE_COMMENT #TC#
1023 MAX_INDEX_LENGTH #MIL#
1024 TEMPORARY N
1025 user_comment help categories
1026 Separator -----------------------------------------------------
1027 TABLE_CATALOG def
1028 TABLE_SCHEMA mysql
1029 TABLE_NAME help_keyword
1030 TABLE_TYPE BASE TABLE
1031 ENGINE MYISAM_OR_MARIA
1032 VERSION 10
1033 ROW_FORMAT DYNAMIC_OR_PAGE
1034 TABLE_ROWS #TBLR#
1035 AVG_ROW_LENGTH #ARL#
1036 DATA_LENGTH #DL#
1037 MAX_DATA_LENGTH #MDL#
1038 INDEX_LENGTH #IL#
1039 DATA_FREE #DF#
1040 AUTO_INCREMENT NULL
1041 CREATE_TIME #CRT#
1042 UPDATE_TIME #UT#
1043 CHECK_TIME #CT#
1044 TABLE_COLLATION utf8mb3_general_ci
1045 CHECKSUM NULL
1046 CREATE_OPTIONS #CO#
1047 TABLE_COMMENT #TC#
1048 MAX_INDEX_LENGTH #MIL#
1049 TEMPORARY N
1050 user_comment help keywords
1051 Separator -----------------------------------------------------
1052 TABLE_CATALOG def
1053 TABLE_SCHEMA mysql
1054 TABLE_NAME help_relation
1055 TABLE_TYPE BASE TABLE
1056 ENGINE MYISAM_OR_MARIA
1057 VERSION 10
1058 ROW_FORMAT DYNAMIC_OR_PAGE
1059 TABLE_ROWS #TBLR#
1060 AVG_ROW_LENGTH #ARL#
1061 DATA_LENGTH #DL#
1062 MAX_DATA_LENGTH #MDL#
1063 INDEX_LENGTH #IL#
1064 DATA_FREE #DF#
1065 AUTO_INCREMENT NULL
1066 CREATE_TIME #CRT#
1067 UPDATE_TIME #UT#
1068 CHECK_TIME #CT#
1069 TABLE_COLLATION utf8mb3_general_ci
1070 CHECKSUM NULL
1071 CREATE_OPTIONS #CO#
1072 TABLE_COMMENT #TC#
1073 MAX_INDEX_LENGTH #MIL#
1074 TEMPORARY N
1075 user_comment keyword-topic relation
1076 Separator -----------------------------------------------------
1077 TABLE_CATALOG def
1078 TABLE_SCHEMA mysql
1079 TABLE_NAME help_topic
1080 TABLE_TYPE BASE TABLE
1081 ENGINE MYISAM_OR_MARIA
1082 VERSION 10
1083 ROW_FORMAT DYNAMIC_OR_PAGE
1084 TABLE_ROWS #TBLR#
1085 AVG_ROW_LENGTH #ARL#
1086 DATA_LENGTH #DL#
1087 MAX_DATA_LENGTH #MDL#
1088 INDEX_LENGTH #IL#
1089 DATA_FREE #DF#
1090 AUTO_INCREMENT NULL
1091 CREATE_TIME #CRT#
1092 UPDATE_TIME #UT#
1093 CHECK_TIME #CT#
1094 TABLE_COLLATION utf8mb3_general_ci
1095 CHECKSUM NULL
1096 CREATE_OPTIONS #CO#
1097 TABLE_COMMENT #TC#
1098 MAX_INDEX_LENGTH #MIL#
1099 TEMPORARY N
1100 user_comment help topics
1101 Separator -----------------------------------------------------
1102 TABLE_CATALOG def
1103 TABLE_SCHEMA mysql
1104 TABLE_NAME index_stats
1105 TABLE_TYPE BASE TABLE
1106 ENGINE MYISAM_OR_MARIA
1107 VERSION 10
1108 ROW_FORMAT DYNAMIC_OR_PAGE
1109 TABLE_ROWS #TBLR#
1110 AVG_ROW_LENGTH #ARL#
1111 DATA_LENGTH #DL#
1112 MAX_DATA_LENGTH #MDL#
1113 INDEX_LENGTH #IL#
1114 DATA_FREE #DF#
1115 AUTO_INCREMENT NULL
1116 CREATE_TIME #CRT#
1117 UPDATE_TIME #UT#
1118 CHECK_TIME #CT#
1119 TABLE_COLLATION utf8mb3_bin
1120 CHECKSUM NULL
1121 CREATE_OPTIONS #CO#
1122 TABLE_COMMENT #TC#
1123 MAX_INDEX_LENGTH #MIL#
1124 TEMPORARY N
1125 user_comment Statistics on Indexes
1126 Separator -----------------------------------------------------
1127 TABLE_CATALOG def
1128 TABLE_SCHEMA mysql
1129 TABLE_NAME innodb_index_stats
1130 TABLE_TYPE BASE TABLE
1131 ENGINE InnoDB
1132 VERSION 10
1133 ROW_FORMAT DYNAMIC_OR_PAGE
1134 TABLE_ROWS #TBLR#
1135 AVG_ROW_LENGTH #ARL#
1136 DATA_LENGTH #DL#
1137 MAX_DATA_LENGTH #MDL#
1138 INDEX_LENGTH #IL#
1139 DATA_FREE #DF#
1140 AUTO_INCREMENT NULL
1141 CREATE_TIME #CRT#
1142 UPDATE_TIME #UT#
1143 CHECK_TIME #CT#
1144 TABLE_COLLATION utf8mb3_bin
1145 CHECKSUM NULL
1146 CREATE_OPTIONS #CO#
1147 TABLE_COMMENT #TC#
1148 MAX_INDEX_LENGTH #MIL#
1149 TEMPORARY N
1150 user_comment
1151 Separator -----------------------------------------------------
1152 TABLE_CATALOG def
1153 TABLE_SCHEMA mysql
1154 TABLE_NAME innodb_table_stats
1155 TABLE_TYPE BASE TABLE
1156 ENGINE InnoDB
1157 VERSION 10
1158 ROW_FORMAT DYNAMIC_OR_PAGE
1159 TABLE_ROWS #TBLR#
1160 AVG_ROW_LENGTH #ARL#
1161 DATA_LENGTH #DL#
1162 MAX_DATA_LENGTH #MDL#
1163 INDEX_LENGTH #IL#
1164 DATA_FREE #DF#
1165 AUTO_INCREMENT NULL
1166 CREATE_TIME #CRT#
1167 UPDATE_TIME #UT#
1168 CHECK_TIME #CT#
1169 TABLE_COLLATION utf8mb3_bin
1170 CHECKSUM NULL
1171 CREATE_OPTIONS #CO#
1172 TABLE_COMMENT #TC#
1173 MAX_INDEX_LENGTH #MIL#
1174 TEMPORARY N
1175 user_comment
1176 Separator -----------------------------------------------------
1177 TABLE_CATALOG def
1178 TABLE_SCHEMA mysql
1179 TABLE_NAME plugin
1180 TABLE_TYPE BASE TABLE
1181 ENGINE MYISAM_OR_MARIA
1182 VERSION 10
1183 ROW_FORMAT DYNAMIC_OR_PAGE
1184 TABLE_ROWS #TBLR#
1185 AVG_ROW_LENGTH #ARL#
1186 DATA_LENGTH #DL#
1187 MAX_DATA_LENGTH #MDL#
1188 INDEX_LENGTH #IL#
1189 DATA_FREE #DF#
1190 AUTO_INCREMENT NULL
1191 CREATE_TIME #CRT#
1192 UPDATE_TIME #UT#
1193 CHECK_TIME #CT#
1194 TABLE_COLLATION utf8mb3_general_ci
1195 CHECKSUM NULL
1196 CREATE_OPTIONS #CO#
1197 TABLE_COMMENT #TC#
1198 MAX_INDEX_LENGTH #MIL#
1199 TEMPORARY N
1200 user_comment MySQL plugins
1201 Separator -----------------------------------------------------
1202 TABLE_CATALOG def
1203 TABLE_SCHEMA mysql
1204 TABLE_NAME proc
1205 TABLE_TYPE BASE TABLE
1206 ENGINE MYISAM_OR_MARIA
1207 VERSION 10
1208 ROW_FORMAT DYNAMIC_OR_PAGE
1209 TABLE_ROWS #TBLR#
1210 AVG_ROW_LENGTH #ARL#
1211 DATA_LENGTH #DL#
1212 MAX_DATA_LENGTH #MDL#
1213 INDEX_LENGTH #IL#
1214 DATA_FREE #DF#
1215 AUTO_INCREMENT NULL
1216 CREATE_TIME #CRT#
1217 UPDATE_TIME #UT#
1218 CHECK_TIME #CT#
1219 TABLE_COLLATION utf8mb3_general_ci
1220 CHECKSUM NULL
1221 CREATE_OPTIONS #CO#
1222 TABLE_COMMENT #TC#
1223 MAX_INDEX_LENGTH #MIL#
1224 TEMPORARY N
1225 user_comment Stored Procedures
1226 Separator -----------------------------------------------------
1227 TABLE_CATALOG def
1228 TABLE_SCHEMA mysql
1229 TABLE_NAME procs_priv
1230 TABLE_TYPE BASE TABLE
1231 ENGINE MYISAM_OR_MARIA
1232 VERSION 10
1233 ROW_FORMAT DYNAMIC_OR_PAGE
1234 TABLE_ROWS #TBLR#
1235 AVG_ROW_LENGTH #ARL#
1236 DATA_LENGTH #DL#
1237 MAX_DATA_LENGTH #MDL#
1238 INDEX_LENGTH #IL#
1239 DATA_FREE #DF#
1240 AUTO_INCREMENT NULL
1241 CREATE_TIME #CRT#
1242 UPDATE_TIME #UT#
1243 CHECK_TIME #CT#
1244 TABLE_COLLATION utf8mb3_bin
1245 CHECKSUM NULL
1246 CREATE_OPTIONS #CO#
1247 TABLE_COMMENT #TC#
1248 MAX_INDEX_LENGTH #MIL#
1249 TEMPORARY N
1250 user_comment Procedure privileges
1251 Separator -----------------------------------------------------
1252 TABLE_CATALOG def
1253 TABLE_SCHEMA mysql
1254 TABLE_NAME proxies_priv
1255 TABLE_TYPE BASE TABLE
1256 ENGINE MYISAM_OR_MARIA
1257 VERSION 10
1258 ROW_FORMAT DYNAMIC_OR_PAGE
1259 TABLE_ROWS #TBLR#
1260 AVG_ROW_LENGTH #ARL#
1261 DATA_LENGTH #DL#
1262 MAX_DATA_LENGTH #MDL#
1263 INDEX_LENGTH #IL#
1264 DATA_FREE #DF#
1265 AUTO_INCREMENT NULL
1266 CREATE_TIME #CRT#
1267 UPDATE_TIME #UT#
1268 CHECK_TIME #CT#
1269 TABLE_COLLATION utf8mb3_bin
1270 CHECKSUM NULL
1271 CREATE_OPTIONS #CO#
1272 TABLE_COMMENT #TC#
1273 MAX_INDEX_LENGTH #MIL#
1274 TEMPORARY N
1275 user_comment User proxy privileges
1276 Separator -----------------------------------------------------
1277 TABLE_CATALOG def
1278 TABLE_SCHEMA mysql
1279 TABLE_NAME roles_mapping
1280 TABLE_TYPE BASE TABLE
1281 ENGINE MYISAM_OR_MARIA
1282 VERSION 10
1283 ROW_FORMAT DYNAMIC_OR_PAGE
1284 TABLE_ROWS #TBLR#
1285 AVG_ROW_LENGTH #ARL#
1286 DATA_LENGTH #DL#
1287 MAX_DATA_LENGTH #MDL#
1288 INDEX_LENGTH #IL#
1289 DATA_FREE #DF#
1290 AUTO_INCREMENT NULL
1291 CREATE_TIME #CRT#
1292 UPDATE_TIME #UT#
1293 CHECK_TIME #CT#
1294 TABLE_COLLATION utf8mb3_bin
1295 CHECKSUM NULL
1296 CREATE_OPTIONS #CO#
1297 TABLE_COMMENT #TC#
1298 MAX_INDEX_LENGTH #MIL#
1299 TEMPORARY N
1300 user_comment Granted roles
1301 Separator -----------------------------------------------------
1302 TABLE_CATALOG def
1303 TABLE_SCHEMA mysql
1304 TABLE_NAME servers
1305 TABLE_TYPE BASE TABLE
1306 ENGINE MYISAM_OR_MARIA
1307 VERSION 11
1308 ROW_FORMAT DYNAMIC_OR_PAGE
1309 TABLE_ROWS #TBLR#
1310 AVG_ROW_LENGTH #ARL#
1311 DATA_LENGTH #DL#
1312 MAX_DATA_LENGTH #MDL#
1313 INDEX_LENGTH #IL#
1314 DATA_FREE #DF#
1315 AUTO_INCREMENT NULL
1316 CREATE_TIME #CRT#
1317 UPDATE_TIME #UT#
1318 CHECK_TIME #CT#
1319 TABLE_COLLATION utf8mb3_general_ci
1320 CHECKSUM NULL
1321 CREATE_OPTIONS #CO#
1322 TABLE_COMMENT #TC#
1323 MAX_INDEX_LENGTH #MIL#
1324 TEMPORARY N
1325 user_comment MySQL Foreign Servers table
1326 Separator -----------------------------------------------------
1327 TABLE_CATALOG def
1328 TABLE_SCHEMA mysql
1329 TABLE_NAME slow_log
1330 TABLE_TYPE BASE TABLE
1331 ENGINE CSV
1332 VERSION 10
1333 ROW_FORMAT DYNAMIC_OR_PAGE
1334 TABLE_ROWS #TBLR#
1335 AVG_ROW_LENGTH #ARL#
1336 DATA_LENGTH #DL#
1337 MAX_DATA_LENGTH #MDL#
1338 INDEX_LENGTH #IL#
1339 DATA_FREE #DF#
1340 AUTO_INCREMENT NULL
1341 CREATE_TIME #CRT#
1342 UPDATE_TIME #UT#
1343 CHECK_TIME #CT#
1344 TABLE_COLLATION utf8mb3_general_ci
1345 CHECKSUM NULL
1346 CREATE_OPTIONS #CO#
1347 TABLE_COMMENT #TC#
1348 MAX_INDEX_LENGTH #MIL#
1349 TEMPORARY N
1350 user_comment Slow log
1351 Separator -----------------------------------------------------
1352 TABLE_CATALOG def
1353 TABLE_SCHEMA mysql
1354 TABLE_NAME tables_priv
1355 TABLE_TYPE BASE TABLE
1356 ENGINE MYISAM_OR_MARIA
1357 VERSION 10
1358 ROW_FORMAT DYNAMIC_OR_PAGE
1359 TABLE_ROWS #TBLR#
1360 AVG_ROW_LENGTH #ARL#
1361 DATA_LENGTH #DL#
1362 MAX_DATA_LENGTH #MDL#
1363 INDEX_LENGTH #IL#
1364 DATA_FREE #DF#
1365 AUTO_INCREMENT NULL
1366 CREATE_TIME #CRT#
1367 UPDATE_TIME #UT#
1368 CHECK_TIME #CT#
1369 TABLE_COLLATION utf8mb3_bin
1370 CHECKSUM NULL
1371 CREATE_OPTIONS #CO#
1372 TABLE_COMMENT #TC#
1373 MAX_INDEX_LENGTH #MIL#
1374 TEMPORARY N
1375 user_comment Table privileges
1376 Separator -----------------------------------------------------
1377 TABLE_CATALOG def
1378 TABLE_SCHEMA mysql
1379 TABLE_NAME table_stats
1380 TABLE_TYPE BASE TABLE
1381 ENGINE MYISAM_OR_MARIA
1382 VERSION 10
1383 ROW_FORMAT DYNAMIC_OR_PAGE
1384 TABLE_ROWS #TBLR#
1385 AVG_ROW_LENGTH #ARL#
1386 DATA_LENGTH #DL#
1387 MAX_DATA_LENGTH #MDL#
1388 INDEX_LENGTH #IL#
1389 DATA_FREE #DF#
1390 AUTO_INCREMENT NULL
1391 CREATE_TIME #CRT#
1392 UPDATE_TIME #UT#
1393 CHECK_TIME #CT#
1394 TABLE_COLLATION utf8mb3_bin
1395 CHECKSUM NULL
1396 CREATE_OPTIONS #CO#
1397 TABLE_COMMENT #TC#
1398 MAX_INDEX_LENGTH #MIL#
1399 TEMPORARY N
1400 user_comment Statistics on Tables
1401 Separator -----------------------------------------------------
1402 TABLE_CATALOG def
1403 TABLE_SCHEMA mysql
1404 TABLE_NAME time_zone
1405 TABLE_TYPE BASE TABLE
1406 ENGINE MYISAM_OR_MARIA
1407 VERSION 10
1408 ROW_FORMAT DYNAMIC_OR_PAGE
1409 TABLE_ROWS #TBLR#
1410 AVG_ROW_LENGTH #ARL#
1411 DATA_LENGTH #DL#
1412 MAX_DATA_LENGTH #MDL#
1413 INDEX_LENGTH #IL#
1414 DATA_FREE #DF#
1415 AUTO_INCREMENT 7
1416 CREATE_TIME #CRT#
1417 UPDATE_TIME #UT#
1418 CHECK_TIME #CT#
1419 TABLE_COLLATION utf8mb3_general_ci
1420 CHECKSUM NULL
1421 CREATE_OPTIONS #CO#
1422 TABLE_COMMENT #TC#
1423 MAX_INDEX_LENGTH #MIL#
1424 TEMPORARY N
1425 user_comment Time zones
1426 Separator -----------------------------------------------------
1427 TABLE_CATALOG def
1428 TABLE_SCHEMA mysql
1429 TABLE_NAME time_zone_leap_second
1430 TABLE_TYPE BASE TABLE
1431 ENGINE MYISAM_OR_MARIA
1432 VERSION 10
1433 ROW_FORMAT DYNAMIC_OR_PAGE
1434 TABLE_ROWS #TBLR#
1435 AVG_ROW_LENGTH #ARL#
1436 DATA_LENGTH #DL#
1437 MAX_DATA_LENGTH #MDL#
1438 INDEX_LENGTH #IL#
1439 DATA_FREE #DF#
1440 AUTO_INCREMENT NULL
1441 CREATE_TIME #CRT#
1442 UPDATE_TIME #UT#
1443 CHECK_TIME #CT#
1444 TABLE_COLLATION utf8mb3_general_ci
1445 CHECKSUM NULL
1446 CREATE_OPTIONS #CO#
1447 TABLE_COMMENT #TC#
1448 MAX_INDEX_LENGTH #MIL#
1449 TEMPORARY N
1450 user_comment Leap seconds information for time zones
1451 Separator -----------------------------------------------------
1452 TABLE_CATALOG def
1453 TABLE_SCHEMA mysql
1454 TABLE_NAME time_zone_name
1455 TABLE_TYPE BASE TABLE
1456 ENGINE MYISAM_OR_MARIA
1457 VERSION 10
1458 ROW_FORMAT DYNAMIC_OR_PAGE
1459 TABLE_ROWS #TBLR#
1460 AVG_ROW_LENGTH #ARL#
1461 DATA_LENGTH #DL#
1462 MAX_DATA_LENGTH #MDL#
1463 INDEX_LENGTH #IL#
1464 DATA_FREE #DF#
1465 AUTO_INCREMENT NULL
1466 CREATE_TIME #CRT#
1467 UPDATE_TIME #UT#
1468 CHECK_TIME #CT#
1469 TABLE_COLLATION utf8mb3_general_ci
1470 CHECKSUM NULL
1471 CREATE_OPTIONS #CO#
1472 TABLE_COMMENT #TC#
1473 MAX_INDEX_LENGTH #MIL#
1474 TEMPORARY N
1475 user_comment Time zone names
1476 Separator -----------------------------------------------------
1477 TABLE_CATALOG def
1478 TABLE_SCHEMA mysql
1479 TABLE_NAME time_zone_transition
1480 TABLE_TYPE BASE TABLE
1481 ENGINE MYISAM_OR_MARIA
1482 VERSION 10
1483 ROW_FORMAT DYNAMIC_OR_PAGE
1484 TABLE_ROWS #TBLR#
1485 AVG_ROW_LENGTH #ARL#
1486 DATA_LENGTH #DL#
1487 MAX_DATA_LENGTH #MDL#
1488 INDEX_LENGTH #IL#
1489 DATA_FREE #DF#
1490 AUTO_INCREMENT NULL
1491 CREATE_TIME #CRT#
1492 UPDATE_TIME #UT#
1493 CHECK_TIME #CT#
1494 TABLE_COLLATION utf8mb3_general_ci
1495 CHECKSUM NULL
1496 CREATE_OPTIONS #CO#
1497 TABLE_COMMENT #TC#
1498 MAX_INDEX_LENGTH #MIL#
1499 TEMPORARY N
1500 user_comment Time zone transitions
1501 Separator -----------------------------------------------------
1502 TABLE_CATALOG def
1503 TABLE_SCHEMA mysql
1504 TABLE_NAME time_zone_transition_type
1505 TABLE_TYPE BASE TABLE
1506 ENGINE MYISAM_OR_MARIA
1507 VERSION 10
1508 ROW_FORMAT DYNAMIC_OR_PAGE
1509 TABLE_ROWS #TBLR#
1510 AVG_ROW_LENGTH #ARL#
1511 DATA_LENGTH #DL#
1512 MAX_DATA_LENGTH #MDL#
1513 INDEX_LENGTH #IL#
1514 DATA_FREE #DF#
1515 AUTO_INCREMENT NULL
1516 CREATE_TIME #CRT#
1517 UPDATE_TIME #UT#
1518 CHECK_TIME #CT#
1519 TABLE_COLLATION utf8mb3_general_ci
1520 CHECKSUM NULL
1521 CREATE_OPTIONS #CO#
1522 TABLE_COMMENT #TC#
1523 MAX_INDEX_LENGTH #MIL#
1524 TEMPORARY N
1525 user_comment Time zone transition types
1526 Separator -----------------------------------------------------
1527 TABLE_CATALOG def
1528 TABLE_SCHEMA mysql
1529 TABLE_NAME transaction_registry
1530 TABLE_TYPE BASE TABLE
1531 ENGINE InnoDB
1532 VERSION 10
1533 ROW_FORMAT DYNAMIC_OR_PAGE
1534 TABLE_ROWS #TBLR#
1535 AVG_ROW_LENGTH #ARL#
1536 DATA_LENGTH #DL#
1537 MAX_DATA_LENGTH #MDL#
1538 INDEX_LENGTH #IL#
1539 DATA_FREE #DF#
1540 AUTO_INCREMENT NULL
1541 CREATE_TIME #CRT#
1542 UPDATE_TIME #UT#
1543 CHECK_TIME #CT#
1544 TABLE_COLLATION utf8mb3_bin
1545 CHECKSUM NULL
1546 CREATE_OPTIONS #CO#
1547 TABLE_COMMENT #TC#
1548 MAX_INDEX_LENGTH #MIL#
1549 TEMPORARY N
1550 user_comment
1551 Separator -----------------------------------------------------
1552 TABLE_CATALOG def
1553 TABLE_SCHEMA mysql
1554 TABLE_NAME user
1555 TABLE_TYPE VIEW
1556 ENGINE NULL
1557 VERSION NULL
1558 ROW_FORMAT NULL
1559 TABLE_ROWS #TBLR#
1560 AVG_ROW_LENGTH #ARL#
1561 DATA_LENGTH #DL#
1562 MAX_DATA_LENGTH #MDL#
1563 INDEX_LENGTH #IL#
1564 DATA_FREE #DF#
1565 AUTO_INCREMENT NULL
1566 CREATE_TIME #CRT#
1567 UPDATE_TIME #UT#
1568 CHECK_TIME #CT#
1569 TABLE_COLLATION NULL
1570 CHECKSUM NULL
1571 CREATE_OPTIONS #CO#
1572 TABLE_COMMENT #TC#
1573 MAX_INDEX_LENGTH #MIL#
1574 TEMPORARY NULL
1575 user_comment VIEW
1576 Separator -----------------------------------------------------
1577 connection default;
1578 disconnect testuser1;
1579 DROP USER testuser1@localhost;
1580 DROP DATABASE test1;