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,'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 connection default;
803 disconnect testuser1;
804 DROP USER testuser1@localhost;
805 DROP DATABASE test1;