Debian Codegraph @

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

raw
1 DROP DATABASE IF EXISTS test1;
2 CREATE DATABASE test1;
3 SELECT *,
4 LEFT( table_comment,
5 IF(INSTR(table_comment,'TMP_TABLE_ENGINE free') = 0
6 AND INSTR(table_comment,'number_of_replicas') = 0,
7 LENGTH(table_comment),
8 INSTR(table_comment,'TMP_TABLE_ENGINE free')
9 + INSTR(table_comment,'number_of_replicas') - 1))
10 AS "user_comment",
11 '-----------------------------------------------------' AS "Separator"
12 FROM information_schema.tables
13 WHERE table_schema = 'mysql' AND table_name != 'ndb_binlog_index'
14 ORDER BY table_schema,table_name COLLATE utf8_general_ci;
15 TABLE_CATALOG def
16 TABLE_SCHEMA mysql
17 TABLE_NAME columns_priv
18 TABLE_TYPE BASE TABLE
19 ENGINE TMP_TABLE_ENGINE
20 VERSION 10
21 ROW_FORMAT Dynamic
22 TABLE_ROWS #TBLR#
23 AVG_ROW_LENGTH #ARL#
24 DATA_LENGTH #DL#
25 MAX_DATA_LENGTH #MDL#
26 INDEX_LENGTH #IL#
27 DATA_FREE #DF#
28 AUTO_INCREMENT #AI#
29 CREATE_TIME #CRT#
30 UPDATE_TIME #UT#
31 CHECK_TIME #CT#
32 TABLE_COLLATION utf8mb3_bin
33 CHECKSUM NULL
34 CREATE_OPTIONS #CO#
35 TABLE_COMMENT #TC#
36 user_comment Column privileges
37 Separator -----------------------------------------------------
38 TABLE_CATALOG def
39 TABLE_SCHEMA mysql
40 TABLE_NAME component
41 TABLE_TYPE BASE TABLE
42 ENGINE TMP_TABLE_ENGINE
43 VERSION 10
44 ROW_FORMAT Dynamic
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 #AI#
52 CREATE_TIME #CRT#
53 UPDATE_TIME #UT#
54 CHECK_TIME #CT#
55 TABLE_COLLATION utf8mb3_general_ci
56 CHECKSUM NULL
57 CREATE_OPTIONS #CO#
58 TABLE_COMMENT #TC#
59 user_comment Components
60 Separator -----------------------------------------------------
61 TABLE_CATALOG def
62 TABLE_SCHEMA mysql
63 TABLE_NAME db
64 TABLE_TYPE BASE TABLE
65 ENGINE TMP_TABLE_ENGINE
66 VERSION 10
67 ROW_FORMAT Dynamic
68 TABLE_ROWS #TBLR#
69 AVG_ROW_LENGTH #ARL#
70 DATA_LENGTH #DL#
71 MAX_DATA_LENGTH #MDL#
72 INDEX_LENGTH #IL#
73 DATA_FREE #DF#
74 AUTO_INCREMENT #AI#
75 CREATE_TIME #CRT#
76 UPDATE_TIME #UT#
77 CHECK_TIME #CT#
78 TABLE_COLLATION utf8mb3_bin
79 CHECKSUM NULL
80 CREATE_OPTIONS #CO#
81 TABLE_COMMENT #TC#
82 user_comment Database privileges
83 Separator -----------------------------------------------------
84 TABLE_CATALOG def
85 TABLE_SCHEMA mysql
86 TABLE_NAME default_roles
87 TABLE_TYPE BASE TABLE
88 ENGINE TMP_TABLE_ENGINE
89 VERSION 10
90 ROW_FORMAT Dynamic
91 TABLE_ROWS #TBLR#
92 AVG_ROW_LENGTH #ARL#
93 DATA_LENGTH #DL#
94 MAX_DATA_LENGTH #MDL#
95 INDEX_LENGTH #IL#
96 DATA_FREE #DF#
97 AUTO_INCREMENT #AI#
98 CREATE_TIME #CRT#
99 UPDATE_TIME #UT#
100 CHECK_TIME #CT#
101 TABLE_COLLATION utf8mb3_bin
102 CHECKSUM NULL
103 CREATE_OPTIONS #CO#
104 TABLE_COMMENT #TC#
105 user_comment Default roles
106 Separator -----------------------------------------------------
107 TABLE_CATALOG def
108 TABLE_SCHEMA mysql
109 TABLE_NAME engine_cost
110 TABLE_TYPE BASE TABLE
111 ENGINE TMP_TABLE_ENGINE
112 VERSION 10
113 ROW_FORMAT Dynamic
114 TABLE_ROWS #TBLR#
115 AVG_ROW_LENGTH #ARL#
116 DATA_LENGTH #DL#
117 MAX_DATA_LENGTH #MDL#
118 INDEX_LENGTH #IL#
119 DATA_FREE #DF#
120 AUTO_INCREMENT #AI#
121 CREATE_TIME #CRT#
122 UPDATE_TIME #UT#
123 CHECK_TIME #CT#
124 TABLE_COLLATION utf8mb3_general_ci
125 CHECKSUM NULL
126 CREATE_OPTIONS #CO#
127 TABLE_COMMENT #TC#
128 user_comment
129 Separator -----------------------------------------------------
130 TABLE_CATALOG def
131 TABLE_SCHEMA mysql
132 TABLE_NAME func
133 TABLE_TYPE BASE TABLE
134 ENGINE TMP_TABLE_ENGINE
135 VERSION 10
136 ROW_FORMAT Dynamic
137 TABLE_ROWS #TBLR#
138 AVG_ROW_LENGTH #ARL#
139 DATA_LENGTH #DL#
140 MAX_DATA_LENGTH #MDL#
141 INDEX_LENGTH #IL#
142 DATA_FREE #DF#
143 AUTO_INCREMENT #AI#
144 CREATE_TIME #CRT#
145 UPDATE_TIME #UT#
146 CHECK_TIME #CT#
147 TABLE_COLLATION utf8mb3_bin
148 CHECKSUM NULL
149 CREATE_OPTIONS #CO#
150 TABLE_COMMENT #TC#
151 user_comment User defined functions
152 Separator -----------------------------------------------------
153 TABLE_CATALOG def
154 TABLE_SCHEMA mysql
155 TABLE_NAME general_log
156 TABLE_TYPE BASE TABLE
157 ENGINE CSV
158 VERSION 10
159 ROW_FORMAT Dynamic
160 TABLE_ROWS #TBLR#
161 AVG_ROW_LENGTH #ARL#
162 DATA_LENGTH #DL#
163 MAX_DATA_LENGTH #MDL#
164 INDEX_LENGTH #IL#
165 DATA_FREE #DF#
166 AUTO_INCREMENT #AI#
167 CREATE_TIME #CRT#
168 UPDATE_TIME #UT#
169 CHECK_TIME #CT#
170 TABLE_COLLATION utf8mb3_general_ci
171 CHECKSUM NULL
172 CREATE_OPTIONS #CO#
173 TABLE_COMMENT #TC#
174 user_comment General log
175 Separator -----------------------------------------------------
176 TABLE_CATALOG def
177 TABLE_SCHEMA mysql
178 TABLE_NAME global_grants
179 TABLE_TYPE BASE TABLE
180 ENGINE TMP_TABLE_ENGINE
181 VERSION 10
182 ROW_FORMAT Dynamic
183 TABLE_ROWS #TBLR#
184 AVG_ROW_LENGTH #ARL#
185 DATA_LENGTH #DL#
186 MAX_DATA_LENGTH #MDL#
187 INDEX_LENGTH #IL#
188 DATA_FREE #DF#
189 AUTO_INCREMENT #AI#
190 CREATE_TIME #CRT#
191 UPDATE_TIME #UT#
192 CHECK_TIME #CT#
193 TABLE_COLLATION utf8mb3_bin
194 CHECKSUM NULL
195 CREATE_OPTIONS #CO#
196 TABLE_COMMENT #TC#
197 user_comment Extended global grants
198 Separator -----------------------------------------------------
199 TABLE_CATALOG def
200 TABLE_SCHEMA mysql
201 TABLE_NAME gtid_executed
202 TABLE_TYPE BASE TABLE
203 ENGINE TMP_TABLE_ENGINE
204 VERSION 10
205 ROW_FORMAT Dynamic
206 TABLE_ROWS #TBLR#
207 AVG_ROW_LENGTH #ARL#
208 DATA_LENGTH #DL#
209 MAX_DATA_LENGTH #MDL#
210 INDEX_LENGTH #IL#
211 DATA_FREE #DF#
212 AUTO_INCREMENT #AI#
213 CREATE_TIME #CRT#
214 UPDATE_TIME #UT#
215 CHECK_TIME #CT#
216 TABLE_COLLATION utf8mb4_0900_ai_ci
217 CHECKSUM NULL
218 CREATE_OPTIONS #CO#
219 TABLE_COMMENT #TC#
220 user_comment
221 Separator -----------------------------------------------------
222 TABLE_CATALOG def
223 TABLE_SCHEMA mysql
224 TABLE_NAME help_category
225 TABLE_TYPE BASE TABLE
226 ENGINE TMP_TABLE_ENGINE
227 VERSION 10
228 ROW_FORMAT Dynamic
229 TABLE_ROWS #TBLR#
230 AVG_ROW_LENGTH #ARL#
231 DATA_LENGTH #DL#
232 MAX_DATA_LENGTH #MDL#
233 INDEX_LENGTH #IL#
234 DATA_FREE #DF#
235 AUTO_INCREMENT #AI#
236 CREATE_TIME #CRT#
237 UPDATE_TIME #UT#
238 CHECK_TIME #CT#
239 TABLE_COLLATION utf8mb3_general_ci
240 CHECKSUM NULL
241 CREATE_OPTIONS #CO#
242 TABLE_COMMENT #TC#
243 user_comment help categories
244 Separator -----------------------------------------------------
245 TABLE_CATALOG def
246 TABLE_SCHEMA mysql
247 TABLE_NAME help_keyword
248 TABLE_TYPE BASE TABLE
249 ENGINE TMP_TABLE_ENGINE
250 VERSION 10
251 ROW_FORMAT Dynamic
252 TABLE_ROWS #TBLR#
253 AVG_ROW_LENGTH #ARL#
254 DATA_LENGTH #DL#
255 MAX_DATA_LENGTH #MDL#
256 INDEX_LENGTH #IL#
257 DATA_FREE #DF#
258 AUTO_INCREMENT #AI#
259 CREATE_TIME #CRT#
260 UPDATE_TIME #UT#
261 CHECK_TIME #CT#
262 TABLE_COLLATION utf8mb3_general_ci
263 CHECKSUM NULL
264 CREATE_OPTIONS #CO#
265 TABLE_COMMENT #TC#
266 user_comment help keywords
267 Separator -----------------------------------------------------
268 TABLE_CATALOG def
269 TABLE_SCHEMA mysql
270 TABLE_NAME help_relation
271 TABLE_TYPE BASE TABLE
272 ENGINE TMP_TABLE_ENGINE
273 VERSION 10
274 ROW_FORMAT Dynamic
275 TABLE_ROWS #TBLR#
276 AVG_ROW_LENGTH #ARL#
277 DATA_LENGTH #DL#
278 MAX_DATA_LENGTH #MDL#
279 INDEX_LENGTH #IL#
280 DATA_FREE #DF#
281 AUTO_INCREMENT #AI#
282 CREATE_TIME #CRT#
283 UPDATE_TIME #UT#
284 CHECK_TIME #CT#
285 TABLE_COLLATION utf8mb3_general_ci
286 CHECKSUM NULL
287 CREATE_OPTIONS #CO#
288 TABLE_COMMENT #TC#
289 user_comment keyword-topic relation
290 Separator -----------------------------------------------------
291 TABLE_CATALOG def
292 TABLE_SCHEMA mysql
293 TABLE_NAME help_topic
294 TABLE_TYPE BASE TABLE
295 ENGINE TMP_TABLE_ENGINE
296 VERSION 10
297 ROW_FORMAT Dynamic
298 TABLE_ROWS #TBLR#
299 AVG_ROW_LENGTH #ARL#
300 DATA_LENGTH #DL#
301 MAX_DATA_LENGTH #MDL#
302 INDEX_LENGTH #IL#
303 DATA_FREE #DF#
304 AUTO_INCREMENT #AI#
305 CREATE_TIME #CRT#
306 UPDATE_TIME #UT#
307 CHECK_TIME #CT#
308 TABLE_COLLATION utf8mb3_general_ci
309 CHECKSUM NULL
310 CREATE_OPTIONS #CO#
311 TABLE_COMMENT #TC#
312 user_comment help topics
313 Separator -----------------------------------------------------
314 TABLE_CATALOG def
315 TABLE_SCHEMA mysql
316 TABLE_NAME innodb_index_stats
317 TABLE_TYPE BASE TABLE
318 ENGINE TMP_TABLE_ENGINE
319 VERSION 10
320 ROW_FORMAT Dynamic
321 TABLE_ROWS #TBLR#
322 AVG_ROW_LENGTH #ARL#
323 DATA_LENGTH #DL#
324 MAX_DATA_LENGTH #MDL#
325 INDEX_LENGTH #IL#
326 DATA_FREE #DF#
327 AUTO_INCREMENT #AI#
328 CREATE_TIME #CRT#
329 UPDATE_TIME #UT#
330 CHECK_TIME #CT#
331 TABLE_COLLATION utf8mb3_bin
332 CHECKSUM NULL
333 CREATE_OPTIONS #CO#
334 TABLE_COMMENT #TC#
335 user_comment
336 Separator -----------------------------------------------------
337 TABLE_CATALOG def
338 TABLE_SCHEMA mysql
339 TABLE_NAME innodb_table_stats
340 TABLE_TYPE BASE TABLE
341 ENGINE TMP_TABLE_ENGINE
342 VERSION 10
343 ROW_FORMAT Dynamic
344 TABLE_ROWS #TBLR#
345 AVG_ROW_LENGTH #ARL#
346 DATA_LENGTH #DL#
347 MAX_DATA_LENGTH #MDL#
348 INDEX_LENGTH #IL#
349 DATA_FREE #DF#
350 AUTO_INCREMENT #AI#
351 CREATE_TIME #CRT#
352 UPDATE_TIME #UT#
353 CHECK_TIME #CT#
354 TABLE_COLLATION utf8mb3_bin
355 CHECKSUM NULL
356 CREATE_OPTIONS #CO#
357 TABLE_COMMENT #TC#
358 user_comment
359 Separator -----------------------------------------------------
360 TABLE_CATALOG def
361 TABLE_SCHEMA mysql
362 TABLE_NAME password_history
363 TABLE_TYPE BASE TABLE
364 ENGINE TMP_TABLE_ENGINE
365 VERSION 10
366 ROW_FORMAT Dynamic
367 TABLE_ROWS #TBLR#
368 AVG_ROW_LENGTH #ARL#
369 DATA_LENGTH #DL#
370 MAX_DATA_LENGTH #MDL#
371 INDEX_LENGTH #IL#
372 DATA_FREE #DF#
373 AUTO_INCREMENT #AI#
374 CREATE_TIME #CRT#
375 UPDATE_TIME #UT#
376 CHECK_TIME #CT#
377 TABLE_COLLATION utf8mb3_bin
378 CHECKSUM NULL
379 CREATE_OPTIONS #CO#
380 TABLE_COMMENT #TC#
381 user_comment Password history for user accounts
382 Separator -----------------------------------------------------
383 TABLE_CATALOG def
384 TABLE_SCHEMA mysql
385 TABLE_NAME plugin
386 TABLE_TYPE BASE TABLE
387 ENGINE TMP_TABLE_ENGINE
388 VERSION 10
389 ROW_FORMAT Dynamic
390 TABLE_ROWS #TBLR#
391 AVG_ROW_LENGTH #ARL#
392 DATA_LENGTH #DL#
393 MAX_DATA_LENGTH #MDL#
394 INDEX_LENGTH #IL#
395 DATA_FREE #DF#
396 AUTO_INCREMENT #AI#
397 CREATE_TIME #CRT#
398 UPDATE_TIME #UT#
399 CHECK_TIME #CT#
400 TABLE_COLLATION utf8mb3_general_ci
401 CHECKSUM NULL
402 CREATE_OPTIONS #CO#
403 TABLE_COMMENT #TC#
404 user_comment MySQL plugins
405 Separator -----------------------------------------------------
406 TABLE_CATALOG def
407 TABLE_SCHEMA mysql
408 TABLE_NAME procs_priv
409 TABLE_TYPE BASE TABLE
410 ENGINE TMP_TABLE_ENGINE
411 VERSION 10
412 ROW_FORMAT Dynamic
413 TABLE_ROWS #TBLR#
414 AVG_ROW_LENGTH #ARL#
415 DATA_LENGTH #DL#
416 MAX_DATA_LENGTH #MDL#
417 INDEX_LENGTH #IL#
418 DATA_FREE #DF#
419 AUTO_INCREMENT #AI#
420 CREATE_TIME #CRT#
421 UPDATE_TIME #UT#
422 CHECK_TIME #CT#
423 TABLE_COLLATION utf8mb3_bin
424 CHECKSUM NULL
425 CREATE_OPTIONS #CO#
426 TABLE_COMMENT #TC#
427 user_comment Procedure privileges
428 Separator -----------------------------------------------------
429 TABLE_CATALOG def
430 TABLE_SCHEMA mysql
431 TABLE_NAME proxies_priv
432 TABLE_TYPE BASE TABLE
433 ENGINE TMP_TABLE_ENGINE
434 VERSION 10
435 ROW_FORMAT Dynamic
436 TABLE_ROWS #TBLR#
437 AVG_ROW_LENGTH #ARL#
438 DATA_LENGTH #DL#
439 MAX_DATA_LENGTH #MDL#
440 INDEX_LENGTH #IL#
441 DATA_FREE #DF#
442 AUTO_INCREMENT #AI#
443 CREATE_TIME #CRT#
444 UPDATE_TIME #UT#
445 CHECK_TIME #CT#
446 TABLE_COLLATION utf8mb3_bin
447 CHECKSUM NULL
448 CREATE_OPTIONS #CO#
449 TABLE_COMMENT #TC#
450 user_comment User proxy privileges
451 Separator -----------------------------------------------------
452 TABLE_CATALOG def
453 TABLE_SCHEMA mysql
454 TABLE_NAME replication_asynchronous_connection_failover
455 TABLE_TYPE BASE TABLE
456 ENGINE TMP_TABLE_ENGINE
457 VERSION 10
458 ROW_FORMAT Dynamic
459 TABLE_ROWS #TBLR#
460 AVG_ROW_LENGTH #ARL#
461 DATA_LENGTH #DL#
462 MAX_DATA_LENGTH #MDL#
463 INDEX_LENGTH #IL#
464 DATA_FREE #DF#
465 AUTO_INCREMENT #AI#
466 CREATE_TIME #CRT#
467 UPDATE_TIME #UT#
468 CHECK_TIME #CT#
469 TABLE_COLLATION utf8mb3_general_ci
470 CHECKSUM NULL
471 CREATE_OPTIONS #CO#
472 TABLE_COMMENT #TC#
473 user_comment The source configuration details
474 Separator -----------------------------------------------------
475 TABLE_CATALOG def
476 TABLE_SCHEMA mysql
477 TABLE_NAME replication_asynchronous_connection_failover_managed
478 TABLE_TYPE BASE TABLE
479 ENGINE TMP_TABLE_ENGINE
480 VERSION 10
481 ROW_FORMAT Dynamic
482 TABLE_ROWS #TBLR#
483 AVG_ROW_LENGTH #ARL#
484 DATA_LENGTH #DL#
485 MAX_DATA_LENGTH #MDL#
486 INDEX_LENGTH #IL#
487 DATA_FREE #DF#
488 AUTO_INCREMENT #AI#
489 CREATE_TIME #CRT#
490 UPDATE_TIME #UT#
491 CHECK_TIME #CT#
492 TABLE_COLLATION utf8mb3_general_ci
493 CHECKSUM NULL
494 CREATE_OPTIONS #CO#
495 TABLE_COMMENT #TC#
496 user_comment The managed source configuration details
497 Separator -----------------------------------------------------
498 TABLE_CATALOG def
499 TABLE_SCHEMA mysql
500 TABLE_NAME replication_group_configuration_version
501 TABLE_TYPE BASE TABLE
502 ENGINE TMP_TABLE_ENGINE
503 VERSION 10
504 ROW_FORMAT Dynamic
505 TABLE_ROWS #TBLR#
506 AVG_ROW_LENGTH #ARL#
507 DATA_LENGTH #DL#
508 MAX_DATA_LENGTH #MDL#
509 INDEX_LENGTH #IL#
510 DATA_FREE #DF#
511 AUTO_INCREMENT #AI#
512 CREATE_TIME #CRT#
513 UPDATE_TIME #UT#
514 CHECK_TIME #CT#
515 TABLE_COLLATION utf8mb4_0900_ai_ci
516 CHECKSUM NULL
517 CREATE_OPTIONS #CO#
518 TABLE_COMMENT #TC#
519 user_comment The group configuration version.
520 Separator -----------------------------------------------------
521 TABLE_CATALOG def
522 TABLE_SCHEMA mysql
523 TABLE_NAME replication_group_member_actions
524 TABLE_TYPE BASE TABLE
525 ENGINE TMP_TABLE_ENGINE
526 VERSION 10
527 ROW_FORMAT Dynamic
528 TABLE_ROWS #TBLR#
529 AVG_ROW_LENGTH #ARL#
530 DATA_LENGTH #DL#
531 MAX_DATA_LENGTH #MDL#
532 INDEX_LENGTH #IL#
533 DATA_FREE #DF#
534 AUTO_INCREMENT #AI#
535 CREATE_TIME #CRT#
536 UPDATE_TIME #UT#
537 CHECK_TIME #CT#
538 TABLE_COLLATION utf8mb4_0900_ai_ci
539 CHECKSUM NULL
540 CREATE_OPTIONS #CO#
541 TABLE_COMMENT #TC#
542 user_comment The member actions configuration.
543 Separator -----------------------------------------------------
544 TABLE_CATALOG def
545 TABLE_SCHEMA mysql
546 TABLE_NAME role_edges
547 TABLE_TYPE BASE TABLE
548 ENGINE TMP_TABLE_ENGINE
549 VERSION 10
550 ROW_FORMAT Dynamic
551 TABLE_ROWS #TBLR#
552 AVG_ROW_LENGTH #ARL#
553 DATA_LENGTH #DL#
554 MAX_DATA_LENGTH #MDL#
555 INDEX_LENGTH #IL#
556 DATA_FREE #DF#
557 AUTO_INCREMENT #AI#
558 CREATE_TIME #CRT#
559 UPDATE_TIME #UT#
560 CHECK_TIME #CT#
561 TABLE_COLLATION utf8mb3_bin
562 CHECKSUM NULL
563 CREATE_OPTIONS #CO#
564 TABLE_COMMENT #TC#
565 user_comment Role hierarchy and role grants
566 Separator -----------------------------------------------------
567 TABLE_CATALOG def
568 TABLE_SCHEMA mysql
569 TABLE_NAME servers
570 TABLE_TYPE BASE TABLE
571 ENGINE TMP_TABLE_ENGINE
572 VERSION 10
573 ROW_FORMAT Dynamic
574 TABLE_ROWS #TBLR#
575 AVG_ROW_LENGTH #ARL#
576 DATA_LENGTH #DL#
577 MAX_DATA_LENGTH #MDL#
578 INDEX_LENGTH #IL#
579 DATA_FREE #DF#
580 AUTO_INCREMENT #AI#
581 CREATE_TIME #CRT#
582 UPDATE_TIME #UT#
583 CHECK_TIME #CT#
584 TABLE_COLLATION utf8mb3_general_ci
585 CHECKSUM NULL
586 CREATE_OPTIONS #CO#
587 TABLE_COMMENT #TC#
588 user_comment MySQL Foreign Servers table
589 Separator -----------------------------------------------------
590 TABLE_CATALOG def
591 TABLE_SCHEMA mysql
592 TABLE_NAME server_cost
593 TABLE_TYPE BASE TABLE
594 ENGINE TMP_TABLE_ENGINE
595 VERSION 10
596 ROW_FORMAT Dynamic
597 TABLE_ROWS #TBLR#
598 AVG_ROW_LENGTH #ARL#
599 DATA_LENGTH #DL#
600 MAX_DATA_LENGTH #MDL#
601 INDEX_LENGTH #IL#
602 DATA_FREE #DF#
603 AUTO_INCREMENT #AI#
604 CREATE_TIME #CRT#
605 UPDATE_TIME #UT#
606 CHECK_TIME #CT#
607 TABLE_COLLATION utf8mb3_general_ci
608 CHECKSUM NULL
609 CREATE_OPTIONS #CO#
610 TABLE_COMMENT #TC#
611 user_comment
612 Separator -----------------------------------------------------
613 TABLE_CATALOG def
614 TABLE_SCHEMA mysql
615 TABLE_NAME slave_master_info
616 TABLE_TYPE BASE TABLE
617 ENGINE TMP_TABLE_ENGINE
618 VERSION 10
619 ROW_FORMAT Dynamic
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 #AI#
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 user_comment Master Information
635 Separator -----------------------------------------------------
636 TABLE_CATALOG def
637 TABLE_SCHEMA mysql
638 TABLE_NAME slave_relay_log_info
639 TABLE_TYPE BASE TABLE
640 ENGINE TMP_TABLE_ENGINE
641 VERSION 10
642 ROW_FORMAT Dynamic
643 TABLE_ROWS #TBLR#
644 AVG_ROW_LENGTH #ARL#
645 DATA_LENGTH #DL#
646 MAX_DATA_LENGTH #MDL#
647 INDEX_LENGTH #IL#
648 DATA_FREE #DF#
649 AUTO_INCREMENT #AI#
650 CREATE_TIME #CRT#
651 UPDATE_TIME #UT#
652 CHECK_TIME #CT#
653 TABLE_COLLATION utf8mb3_general_ci
654 CHECKSUM NULL
655 CREATE_OPTIONS #CO#
656 TABLE_COMMENT #TC#
657 user_comment Relay Log Information
658 Separator -----------------------------------------------------
659 TABLE_CATALOG def
660 TABLE_SCHEMA mysql
661 TABLE_NAME slave_worker_info
662 TABLE_TYPE BASE TABLE
663 ENGINE TMP_TABLE_ENGINE
664 VERSION 10
665 ROW_FORMAT Dynamic
666 TABLE_ROWS #TBLR#
667 AVG_ROW_LENGTH #ARL#
668 DATA_LENGTH #DL#
669 MAX_DATA_LENGTH #MDL#
670 INDEX_LENGTH #IL#
671 DATA_FREE #DF#
672 AUTO_INCREMENT #AI#
673 CREATE_TIME #CRT#
674 UPDATE_TIME #UT#
675 CHECK_TIME #CT#
676 TABLE_COLLATION utf8mb3_general_ci
677 CHECKSUM NULL
678 CREATE_OPTIONS #CO#
679 TABLE_COMMENT #TC#
680 user_comment Worker Information
681 Separator -----------------------------------------------------
682 TABLE_CATALOG def
683 TABLE_SCHEMA mysql
684 TABLE_NAME slow_log
685 TABLE_TYPE BASE TABLE
686 ENGINE CSV
687 VERSION 10
688 ROW_FORMAT Dynamic
689 TABLE_ROWS #TBLR#
690 AVG_ROW_LENGTH #ARL#
691 DATA_LENGTH #DL#
692 MAX_DATA_LENGTH #MDL#
693 INDEX_LENGTH #IL#
694 DATA_FREE #DF#
695 AUTO_INCREMENT #AI#
696 CREATE_TIME #CRT#
697 UPDATE_TIME #UT#
698 CHECK_TIME #CT#
699 TABLE_COLLATION utf8mb3_general_ci
700 CHECKSUM NULL
701 CREATE_OPTIONS #CO#
702 TABLE_COMMENT #TC#
703 user_comment Slow log
704 Separator -----------------------------------------------------
705 TABLE_CATALOG def
706 TABLE_SCHEMA mysql
707 TABLE_NAME tables_priv
708 TABLE_TYPE BASE TABLE
709 ENGINE TMP_TABLE_ENGINE
710 VERSION 10
711 ROW_FORMAT Dynamic
712 TABLE_ROWS #TBLR#
713 AVG_ROW_LENGTH #ARL#
714 DATA_LENGTH #DL#
715 MAX_DATA_LENGTH #MDL#
716 INDEX_LENGTH #IL#
717 DATA_FREE #DF#
718 AUTO_INCREMENT #AI#
719 CREATE_TIME #CRT#
720 UPDATE_TIME #UT#
721 CHECK_TIME #CT#
722 TABLE_COLLATION utf8mb3_bin
723 CHECKSUM NULL
724 CREATE_OPTIONS #CO#
725 TABLE_COMMENT #TC#
726 user_comment Table privileges
727 Separator -----------------------------------------------------
728 TABLE_CATALOG def
729 TABLE_SCHEMA mysql
730 TABLE_NAME time_zone
731 TABLE_TYPE BASE TABLE
732 ENGINE TMP_TABLE_ENGINE
733 VERSION 10
734 ROW_FORMAT Dynamic
735 TABLE_ROWS #TBLR#
736 AVG_ROW_LENGTH #ARL#
737 DATA_LENGTH #DL#
738 MAX_DATA_LENGTH #MDL#
739 INDEX_LENGTH #IL#
740 DATA_FREE #DF#
741 AUTO_INCREMENT #AI#
742 CREATE_TIME #CRT#
743 UPDATE_TIME #UT#
744 CHECK_TIME #CT#
745 TABLE_COLLATION utf8mb3_general_ci
746 CHECKSUM NULL
747 CREATE_OPTIONS #CO#
748 TABLE_COMMENT #TC#
749 user_comment Time zones
750 Separator -----------------------------------------------------
751 TABLE_CATALOG def
752 TABLE_SCHEMA mysql
753 TABLE_NAME time_zone_leap_second
754 TABLE_TYPE BASE TABLE
755 ENGINE TMP_TABLE_ENGINE
756 VERSION 10
757 ROW_FORMAT Dynamic
758 TABLE_ROWS #TBLR#
759 AVG_ROW_LENGTH #ARL#
760 DATA_LENGTH #DL#
761 MAX_DATA_LENGTH #MDL#
762 INDEX_LENGTH #IL#
763 DATA_FREE #DF#
764 AUTO_INCREMENT #AI#
765 CREATE_TIME #CRT#
766 UPDATE_TIME #UT#
767 CHECK_TIME #CT#
768 TABLE_COLLATION utf8mb3_general_ci
769 CHECKSUM NULL
770 CREATE_OPTIONS #CO#
771 TABLE_COMMENT #TC#
772 user_comment Leap seconds information for time zones
773 Separator -----------------------------------------------------
774 TABLE_CATALOG def
775 TABLE_SCHEMA mysql
776 TABLE_NAME time_zone_name
777 TABLE_TYPE BASE TABLE
778 ENGINE TMP_TABLE_ENGINE
779 VERSION 10
780 ROW_FORMAT Dynamic
781 TABLE_ROWS #TBLR#
782 AVG_ROW_LENGTH #ARL#
783 DATA_LENGTH #DL#
784 MAX_DATA_LENGTH #MDL#
785 INDEX_LENGTH #IL#
786 DATA_FREE #DF#
787 AUTO_INCREMENT #AI#
788 CREATE_TIME #CRT#
789 UPDATE_TIME #UT#
790 CHECK_TIME #CT#
791 TABLE_COLLATION utf8mb3_general_ci
792 CHECKSUM NULL
793 CREATE_OPTIONS #CO#
794 TABLE_COMMENT #TC#
795 user_comment Time zone names
796 Separator -----------------------------------------------------
797 TABLE_CATALOG def
798 TABLE_SCHEMA mysql
799 TABLE_NAME time_zone_transition
800 TABLE_TYPE BASE TABLE
801 ENGINE TMP_TABLE_ENGINE
802 VERSION 10
803 ROW_FORMAT Dynamic
804 TABLE_ROWS #TBLR#
805 AVG_ROW_LENGTH #ARL#
806 DATA_LENGTH #DL#
807 MAX_DATA_LENGTH #MDL#
808 INDEX_LENGTH #IL#
809 DATA_FREE #DF#
810 AUTO_INCREMENT #AI#
811 CREATE_TIME #CRT#
812 UPDATE_TIME #UT#
813 CHECK_TIME #CT#
814 TABLE_COLLATION utf8mb3_general_ci
815 CHECKSUM NULL
816 CREATE_OPTIONS #CO#
817 TABLE_COMMENT #TC#
818 user_comment Time zone transitions
819 Separator -----------------------------------------------------
820 TABLE_CATALOG def
821 TABLE_SCHEMA mysql
822 TABLE_NAME time_zone_transition_type
823 TABLE_TYPE BASE TABLE
824 ENGINE TMP_TABLE_ENGINE
825 VERSION 10
826 ROW_FORMAT Dynamic
827 TABLE_ROWS #TBLR#
828 AVG_ROW_LENGTH #ARL#
829 DATA_LENGTH #DL#
830 MAX_DATA_LENGTH #MDL#
831 INDEX_LENGTH #IL#
832 DATA_FREE #DF#
833 AUTO_INCREMENT #AI#
834 CREATE_TIME #CRT#
835 UPDATE_TIME #UT#
836 CHECK_TIME #CT#
837 TABLE_COLLATION utf8mb3_general_ci
838 CHECKSUM NULL
839 CREATE_OPTIONS #CO#
840 TABLE_COMMENT #TC#
841 user_comment Time zone transition types
842 Separator -----------------------------------------------------
843 TABLE_CATALOG def
844 TABLE_SCHEMA mysql
845 TABLE_NAME user
846 TABLE_TYPE BASE TABLE
847 ENGINE TMP_TABLE_ENGINE
848 VERSION 10
849 ROW_FORMAT Dynamic
850 TABLE_ROWS #TBLR#
851 AVG_ROW_LENGTH #ARL#
852 DATA_LENGTH #DL#
853 MAX_DATA_LENGTH #MDL#
854 INDEX_LENGTH #IL#
855 DATA_FREE #DF#
856 AUTO_INCREMENT #AI#
857 CREATE_TIME #CRT#
858 UPDATE_TIME #UT#
859 CHECK_TIME #CT#
860 TABLE_COLLATION utf8mb3_bin
861 CHECKSUM NULL
862 CREATE_OPTIONS #CO#
863 TABLE_COMMENT #TC#
864 user_comment Users and global privileges
865 Separator -----------------------------------------------------
866 DROP USER testuser1@localhost;
867 CREATE USER testuser1@localhost;
868 GRANT SELECT ON test1.* TO testuser1@localhost;
869 # Establish connection testuser1 (user=testuser1)
870 SELECT *,
871 LEFT( table_comment,
872 IF(INSTR(table_comment,'TMP_TABLE_ENGINE free') = 0
873 AND INSTR(table_comment,'number_of_replicas') = 0,
874 LENGTH(table_comment),
875 INSTR(table_comment,'TMP_TABLE_ENGINE free')
876 + INSTR(table_comment,'number_of_replicas') - 1))
877 AS "user_comment",
878 '-----------------------------------------------------' AS "Separator"
879 FROM information_schema.tables
880 WHERE table_schema = 'mysql' AND table_name != 'ndb_binlog_index'
881 ORDER BY table_schema,table_name COLLATE utf8_general_ci;
882 # Switch to connection default and close connection testuser1
883 DROP USER testuser1@localhost;
884 DROP DATABASE test1;