Debian Codegraph @

mysql-test/suite/funcs_1/r/is_tables_is.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 = 'information_schema'
14 AND table_name COLLATE utf8_general_ci <> 'profiling'
15 AND table_name COLLATE utf8_general_ci not like 'innodb_%'
16 AND table_name not like 'ndb%'
17 ORDER BY table_schema,table_name COLLATE utf8_general_ci;
18 TABLE_CATALOG def
19 TABLE_SCHEMA information_schema
20 TABLE_NAME ADMINISTRABLE_ROLE_AUTHORIZATIONS
21 TABLE_TYPE SYSTEM VIEW
22 ENGINE NULL
23 VERSION 10
24 ROW_FORMAT NULL
25 TABLE_ROWS #TBLR#
26 AVG_ROW_LENGTH #ARL#
27 DATA_LENGTH #DL#
28 MAX_DATA_LENGTH #MDL#
29 INDEX_LENGTH #IL#
30 DATA_FREE #DF#
31 AUTO_INCREMENT #AI#
32 CREATE_TIME #CRT#
33 UPDATE_TIME #UT#
34 CHECK_TIME #CT#
35 TABLE_COLLATION NULL
36 CHECKSUM NULL
37 CREATE_OPTIONS #CO#
38 TABLE_COMMENT #TC#
39 user_comment
40 Separator -----------------------------------------------------
41 TABLE_CATALOG def
42 TABLE_SCHEMA information_schema
43 TABLE_NAME APPLICABLE_ROLES
44 TABLE_TYPE SYSTEM VIEW
45 ENGINE NULL
46 VERSION 10
47 ROW_FORMAT NULL
48 TABLE_ROWS #TBLR#
49 AVG_ROW_LENGTH #ARL#
50 DATA_LENGTH #DL#
51 MAX_DATA_LENGTH #MDL#
52 INDEX_LENGTH #IL#
53 DATA_FREE #DF#
54 AUTO_INCREMENT #AI#
55 CREATE_TIME #CRT#
56 UPDATE_TIME #UT#
57 CHECK_TIME #CT#
58 TABLE_COLLATION NULL
59 CHECKSUM NULL
60 CREATE_OPTIONS #CO#
61 TABLE_COMMENT #TC#
62 user_comment
63 Separator -----------------------------------------------------
64 TABLE_CATALOG def
65 TABLE_SCHEMA information_schema
66 TABLE_NAME CHARACTER_SETS
67 TABLE_TYPE SYSTEM VIEW
68 ENGINE NULL
69 VERSION 10
70 ROW_FORMAT NULL
71 TABLE_ROWS #TBLR#
72 AVG_ROW_LENGTH #ARL#
73 DATA_LENGTH #DL#
74 MAX_DATA_LENGTH #MDL#
75 INDEX_LENGTH #IL#
76 DATA_FREE #DF#
77 AUTO_INCREMENT #AI#
78 CREATE_TIME #CRT#
79 UPDATE_TIME #UT#
80 CHECK_TIME #CT#
81 TABLE_COLLATION NULL
82 CHECKSUM NULL
83 CREATE_OPTIONS #CO#
84 TABLE_COMMENT #TC#
85 user_comment
86 Separator -----------------------------------------------------
87 TABLE_CATALOG def
88 TABLE_SCHEMA information_schema
89 TABLE_NAME CHECK_CONSTRAINTS
90 TABLE_TYPE SYSTEM VIEW
91 ENGINE NULL
92 VERSION 10
93 ROW_FORMAT NULL
94 TABLE_ROWS #TBLR#
95 AVG_ROW_LENGTH #ARL#
96 DATA_LENGTH #DL#
97 MAX_DATA_LENGTH #MDL#
98 INDEX_LENGTH #IL#
99 DATA_FREE #DF#
100 AUTO_INCREMENT #AI#
101 CREATE_TIME #CRT#
102 UPDATE_TIME #UT#
103 CHECK_TIME #CT#
104 TABLE_COLLATION NULL
105 CHECKSUM NULL
106 CREATE_OPTIONS #CO#
107 TABLE_COMMENT #TC#
108 user_comment
109 Separator -----------------------------------------------------
110 TABLE_CATALOG def
111 TABLE_SCHEMA information_schema
112 TABLE_NAME COLLATIONS
113 TABLE_TYPE SYSTEM VIEW
114 ENGINE NULL
115 VERSION 10
116 ROW_FORMAT NULL
117 TABLE_ROWS #TBLR#
118 AVG_ROW_LENGTH #ARL#
119 DATA_LENGTH #DL#
120 MAX_DATA_LENGTH #MDL#
121 INDEX_LENGTH #IL#
122 DATA_FREE #DF#
123 AUTO_INCREMENT #AI#
124 CREATE_TIME #CRT#
125 UPDATE_TIME #UT#
126 CHECK_TIME #CT#
127 TABLE_COLLATION NULL
128 CHECKSUM NULL
129 CREATE_OPTIONS #CO#
130 TABLE_COMMENT #TC#
131 user_comment
132 Separator -----------------------------------------------------
133 TABLE_CATALOG def
134 TABLE_SCHEMA information_schema
135 TABLE_NAME COLLATION_CHARACTER_SET_APPLICABILITY
136 TABLE_TYPE SYSTEM VIEW
137 ENGINE NULL
138 VERSION 10
139 ROW_FORMAT NULL
140 TABLE_ROWS #TBLR#
141 AVG_ROW_LENGTH #ARL#
142 DATA_LENGTH #DL#
143 MAX_DATA_LENGTH #MDL#
144 INDEX_LENGTH #IL#
145 DATA_FREE #DF#
146 AUTO_INCREMENT #AI#
147 CREATE_TIME #CRT#
148 UPDATE_TIME #UT#
149 CHECK_TIME #CT#
150 TABLE_COLLATION NULL
151 CHECKSUM NULL
152 CREATE_OPTIONS #CO#
153 TABLE_COMMENT #TC#
154 user_comment
155 Separator -----------------------------------------------------
156 TABLE_CATALOG def
157 TABLE_SCHEMA information_schema
158 TABLE_NAME COLUMNS
159 TABLE_TYPE SYSTEM VIEW
160 ENGINE NULL
161 VERSION 10
162 ROW_FORMAT NULL
163 TABLE_ROWS #TBLR#
164 AVG_ROW_LENGTH #ARL#
165 DATA_LENGTH #DL#
166 MAX_DATA_LENGTH #MDL#
167 INDEX_LENGTH #IL#
168 DATA_FREE #DF#
169 AUTO_INCREMENT #AI#
170 CREATE_TIME #CRT#
171 UPDATE_TIME #UT#
172 CHECK_TIME #CT#
173 TABLE_COLLATION NULL
174 CHECKSUM NULL
175 CREATE_OPTIONS #CO#
176 TABLE_COMMENT #TC#
177 user_comment
178 Separator -----------------------------------------------------
179 TABLE_CATALOG def
180 TABLE_SCHEMA information_schema
181 TABLE_NAME COLUMNS_EXTENSIONS
182 TABLE_TYPE SYSTEM VIEW
183 ENGINE NULL
184 VERSION 10
185 ROW_FORMAT NULL
186 TABLE_ROWS #TBLR#
187 AVG_ROW_LENGTH #ARL#
188 DATA_LENGTH #DL#
189 MAX_DATA_LENGTH #MDL#
190 INDEX_LENGTH #IL#
191 DATA_FREE #DF#
192 AUTO_INCREMENT #AI#
193 CREATE_TIME #CRT#
194 UPDATE_TIME #UT#
195 CHECK_TIME #CT#
196 TABLE_COLLATION NULL
197 CHECKSUM NULL
198 CREATE_OPTIONS #CO#
199 TABLE_COMMENT #TC#
200 user_comment
201 Separator -----------------------------------------------------
202 TABLE_CATALOG def
203 TABLE_SCHEMA information_schema
204 TABLE_NAME COLUMN_PRIVILEGES
205 TABLE_TYPE SYSTEM VIEW
206 ENGINE NULL
207 VERSION 10
208 ROW_FORMAT NULL
209 TABLE_ROWS #TBLR#
210 AVG_ROW_LENGTH #ARL#
211 DATA_LENGTH #DL#
212 MAX_DATA_LENGTH #MDL#
213 INDEX_LENGTH #IL#
214 DATA_FREE #DF#
215 AUTO_INCREMENT #AI#
216 CREATE_TIME #CRT#
217 UPDATE_TIME #UT#
218 CHECK_TIME #CT#
219 TABLE_COLLATION NULL
220 CHECKSUM NULL
221 CREATE_OPTIONS #CO#
222 TABLE_COMMENT #TC#
223 user_comment
224 Separator -----------------------------------------------------
225 TABLE_CATALOG def
226 TABLE_SCHEMA information_schema
227 TABLE_NAME COLUMN_STATISTICS
228 TABLE_TYPE SYSTEM VIEW
229 ENGINE NULL
230 VERSION 10
231 ROW_FORMAT NULL
232 TABLE_ROWS #TBLR#
233 AVG_ROW_LENGTH #ARL#
234 DATA_LENGTH #DL#
235 MAX_DATA_LENGTH #MDL#
236 INDEX_LENGTH #IL#
237 DATA_FREE #DF#
238 AUTO_INCREMENT #AI#
239 CREATE_TIME #CRT#
240 UPDATE_TIME #UT#
241 CHECK_TIME #CT#
242 TABLE_COLLATION NULL
243 CHECKSUM NULL
244 CREATE_OPTIONS #CO#
245 TABLE_COMMENT #TC#
246 user_comment
247 Separator -----------------------------------------------------
248 TABLE_CATALOG def
249 TABLE_SCHEMA information_schema
250 TABLE_NAME ENABLED_ROLES
251 TABLE_TYPE SYSTEM VIEW
252 ENGINE NULL
253 VERSION 10
254 ROW_FORMAT NULL
255 TABLE_ROWS #TBLR#
256 AVG_ROW_LENGTH #ARL#
257 DATA_LENGTH #DL#
258 MAX_DATA_LENGTH #MDL#
259 INDEX_LENGTH #IL#
260 DATA_FREE #DF#
261 AUTO_INCREMENT #AI#
262 CREATE_TIME #CRT#
263 UPDATE_TIME #UT#
264 CHECK_TIME #CT#
265 TABLE_COLLATION NULL
266 CHECKSUM NULL
267 CREATE_OPTIONS #CO#
268 TABLE_COMMENT #TC#
269 user_comment
270 Separator -----------------------------------------------------
271 TABLE_CATALOG def
272 TABLE_SCHEMA information_schema
273 TABLE_NAME ENGINES
274 TABLE_TYPE SYSTEM VIEW
275 ENGINE NULL
276 VERSION 10
277 ROW_FORMAT NULL
278 TABLE_ROWS #TBLR#
279 AVG_ROW_LENGTH #ARL#
280 DATA_LENGTH #DL#
281 MAX_DATA_LENGTH #MDL#
282 INDEX_LENGTH #IL#
283 DATA_FREE #DF#
284 AUTO_INCREMENT #AI#
285 CREATE_TIME #CRT#
286 UPDATE_TIME #UT#
287 CHECK_TIME #CT#
288 TABLE_COLLATION NULL
289 CHECKSUM NULL
290 CREATE_OPTIONS #CO#
291 TABLE_COMMENT #TC#
292 user_comment
293 Separator -----------------------------------------------------
294 TABLE_CATALOG def
295 TABLE_SCHEMA information_schema
296 TABLE_NAME EVENTS
297 TABLE_TYPE SYSTEM VIEW
298 ENGINE NULL
299 VERSION 10
300 ROW_FORMAT NULL
301 TABLE_ROWS #TBLR#
302 AVG_ROW_LENGTH #ARL#
303 DATA_LENGTH #DL#
304 MAX_DATA_LENGTH #MDL#
305 INDEX_LENGTH #IL#
306 DATA_FREE #DF#
307 AUTO_INCREMENT #AI#
308 CREATE_TIME #CRT#
309 UPDATE_TIME #UT#
310 CHECK_TIME #CT#
311 TABLE_COLLATION NULL
312 CHECKSUM NULL
313 CREATE_OPTIONS #CO#
314 TABLE_COMMENT #TC#
315 user_comment
316 Separator -----------------------------------------------------
317 TABLE_CATALOG def
318 TABLE_SCHEMA information_schema
319 TABLE_NAME FILES
320 TABLE_TYPE SYSTEM VIEW
321 ENGINE NULL
322 VERSION 10
323 ROW_FORMAT NULL
324 TABLE_ROWS #TBLR#
325 AVG_ROW_LENGTH #ARL#
326 DATA_LENGTH #DL#
327 MAX_DATA_LENGTH #MDL#
328 INDEX_LENGTH #IL#
329 DATA_FREE #DF#
330 AUTO_INCREMENT #AI#
331 CREATE_TIME #CRT#
332 UPDATE_TIME #UT#
333 CHECK_TIME #CT#
334 TABLE_COLLATION NULL
335 CHECKSUM NULL
336 CREATE_OPTIONS #CO#
337 TABLE_COMMENT #TC#
338 user_comment
339 Separator -----------------------------------------------------
340 TABLE_CATALOG def
341 TABLE_SCHEMA information_schema
342 TABLE_NAME KEYWORDS
343 TABLE_TYPE SYSTEM VIEW
344 ENGINE NULL
345 VERSION 10
346 ROW_FORMAT NULL
347 TABLE_ROWS #TBLR#
348 AVG_ROW_LENGTH #ARL#
349 DATA_LENGTH #DL#
350 MAX_DATA_LENGTH #MDL#
351 INDEX_LENGTH #IL#
352 DATA_FREE #DF#
353 AUTO_INCREMENT #AI#
354 CREATE_TIME #CRT#
355 UPDATE_TIME #UT#
356 CHECK_TIME #CT#
357 TABLE_COLLATION NULL
358 CHECKSUM NULL
359 CREATE_OPTIONS #CO#
360 TABLE_COMMENT #TC#
361 user_comment
362 Separator -----------------------------------------------------
363 TABLE_CATALOG def
364 TABLE_SCHEMA information_schema
365 TABLE_NAME KEY_COLUMN_USAGE
366 TABLE_TYPE SYSTEM VIEW
367 ENGINE NULL
368 VERSION 10
369 ROW_FORMAT NULL
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 #AI#
377 CREATE_TIME #CRT#
378 UPDATE_TIME #UT#
379 CHECK_TIME #CT#
380 TABLE_COLLATION NULL
381 CHECKSUM NULL
382 CREATE_OPTIONS #CO#
383 TABLE_COMMENT #TC#
384 user_comment
385 Separator -----------------------------------------------------
386 TABLE_CATALOG def
387 TABLE_SCHEMA information_schema
388 TABLE_NAME OPTIMIZER_TRACE
389 TABLE_TYPE SYSTEM VIEW
390 ENGINE NULL
391 VERSION 10
392 ROW_FORMAT NULL
393 TABLE_ROWS #TBLR#
394 AVG_ROW_LENGTH #ARL#
395 DATA_LENGTH #DL#
396 MAX_DATA_LENGTH #MDL#
397 INDEX_LENGTH #IL#
398 DATA_FREE #DF#
399 AUTO_INCREMENT #AI#
400 CREATE_TIME #CRT#
401 UPDATE_TIME #UT#
402 CHECK_TIME #CT#
403 TABLE_COLLATION NULL
404 CHECKSUM NULL
405 CREATE_OPTIONS #CO#
406 TABLE_COMMENT #TC#
407 user_comment
408 Separator -----------------------------------------------------
409 TABLE_CATALOG def
410 TABLE_SCHEMA information_schema
411 TABLE_NAME PARAMETERS
412 TABLE_TYPE SYSTEM VIEW
413 ENGINE NULL
414 VERSION 10
415 ROW_FORMAT NULL
416 TABLE_ROWS #TBLR#
417 AVG_ROW_LENGTH #ARL#
418 DATA_LENGTH #DL#
419 MAX_DATA_LENGTH #MDL#
420 INDEX_LENGTH #IL#
421 DATA_FREE #DF#
422 AUTO_INCREMENT #AI#
423 CREATE_TIME #CRT#
424 UPDATE_TIME #UT#
425 CHECK_TIME #CT#
426 TABLE_COLLATION NULL
427 CHECKSUM NULL
428 CREATE_OPTIONS #CO#
429 TABLE_COMMENT #TC#
430 user_comment
431 Separator -----------------------------------------------------
432 TABLE_CATALOG def
433 TABLE_SCHEMA information_schema
434 TABLE_NAME PARTITIONS
435 TABLE_TYPE SYSTEM VIEW
436 ENGINE NULL
437 VERSION 10
438 ROW_FORMAT NULL
439 TABLE_ROWS #TBLR#
440 AVG_ROW_LENGTH #ARL#
441 DATA_LENGTH #DL#
442 MAX_DATA_LENGTH #MDL#
443 INDEX_LENGTH #IL#
444 DATA_FREE #DF#
445 AUTO_INCREMENT #AI#
446 CREATE_TIME #CRT#
447 UPDATE_TIME #UT#
448 CHECK_TIME #CT#
449 TABLE_COLLATION NULL
450 CHECKSUM NULL
451 CREATE_OPTIONS #CO#
452 TABLE_COMMENT #TC#
453 user_comment
454 Separator -----------------------------------------------------
455 TABLE_CATALOG def
456 TABLE_SCHEMA information_schema
457 TABLE_NAME PLUGINS
458 TABLE_TYPE SYSTEM VIEW
459 ENGINE NULL
460 VERSION 10
461 ROW_FORMAT NULL
462 TABLE_ROWS #TBLR#
463 AVG_ROW_LENGTH #ARL#
464 DATA_LENGTH #DL#
465 MAX_DATA_LENGTH #MDL#
466 INDEX_LENGTH #IL#
467 DATA_FREE #DF#
468 AUTO_INCREMENT #AI#
469 CREATE_TIME #CRT#
470 UPDATE_TIME #UT#
471 CHECK_TIME #CT#
472 TABLE_COLLATION NULL
473 CHECKSUM NULL
474 CREATE_OPTIONS #CO#
475 TABLE_COMMENT #TC#
476 user_comment
477 Separator -----------------------------------------------------
478 TABLE_CATALOG def
479 TABLE_SCHEMA information_schema
480 TABLE_NAME PROCESSLIST
481 TABLE_TYPE SYSTEM VIEW
482 ENGINE NULL
483 VERSION 10
484 ROW_FORMAT NULL
485 TABLE_ROWS #TBLR#
486 AVG_ROW_LENGTH #ARL#
487 DATA_LENGTH #DL#
488 MAX_DATA_LENGTH #MDL#
489 INDEX_LENGTH #IL#
490 DATA_FREE #DF#
491 AUTO_INCREMENT #AI#
492 CREATE_TIME #CRT#
493 UPDATE_TIME #UT#
494 CHECK_TIME #CT#
495 TABLE_COLLATION NULL
496 CHECKSUM NULL
497 CREATE_OPTIONS #CO#
498 TABLE_COMMENT #TC#
499 user_comment
500 Separator -----------------------------------------------------
501 TABLE_CATALOG def
502 TABLE_SCHEMA information_schema
503 TABLE_NAME REFERENTIAL_CONSTRAINTS
504 TABLE_TYPE SYSTEM VIEW
505 ENGINE NULL
506 VERSION 10
507 ROW_FORMAT NULL
508 TABLE_ROWS #TBLR#
509 AVG_ROW_LENGTH #ARL#
510 DATA_LENGTH #DL#
511 MAX_DATA_LENGTH #MDL#
512 INDEX_LENGTH #IL#
513 DATA_FREE #DF#
514 AUTO_INCREMENT #AI#
515 CREATE_TIME #CRT#
516 UPDATE_TIME #UT#
517 CHECK_TIME #CT#
518 TABLE_COLLATION NULL
519 CHECKSUM NULL
520 CREATE_OPTIONS #CO#
521 TABLE_COMMENT #TC#
522 user_comment
523 Separator -----------------------------------------------------
524 TABLE_CATALOG def
525 TABLE_SCHEMA information_schema
526 TABLE_NAME RESOURCE_GROUPS
527 TABLE_TYPE SYSTEM VIEW
528 ENGINE NULL
529 VERSION 10
530 ROW_FORMAT NULL
531 TABLE_ROWS #TBLR#
532 AVG_ROW_LENGTH #ARL#
533 DATA_LENGTH #DL#
534 MAX_DATA_LENGTH #MDL#
535 INDEX_LENGTH #IL#
536 DATA_FREE #DF#
537 AUTO_INCREMENT #AI#
538 CREATE_TIME #CRT#
539 UPDATE_TIME #UT#
540 CHECK_TIME #CT#
541 TABLE_COLLATION NULL
542 CHECKSUM NULL
543 CREATE_OPTIONS #CO#
544 TABLE_COMMENT #TC#
545 user_comment
546 Separator -----------------------------------------------------
547 TABLE_CATALOG def
548 TABLE_SCHEMA information_schema
549 TABLE_NAME ROLE_COLUMN_GRANTS
550 TABLE_TYPE SYSTEM VIEW
551 ENGINE NULL
552 VERSION 10
553 ROW_FORMAT NULL
554 TABLE_ROWS #TBLR#
555 AVG_ROW_LENGTH #ARL#
556 DATA_LENGTH #DL#
557 MAX_DATA_LENGTH #MDL#
558 INDEX_LENGTH #IL#
559 DATA_FREE #DF#
560 AUTO_INCREMENT #AI#
561 CREATE_TIME #CRT#
562 UPDATE_TIME #UT#
563 CHECK_TIME #CT#
564 TABLE_COLLATION NULL
565 CHECKSUM NULL
566 CREATE_OPTIONS #CO#
567 TABLE_COMMENT #TC#
568 user_comment
569 Separator -----------------------------------------------------
570 TABLE_CATALOG def
571 TABLE_SCHEMA information_schema
572 TABLE_NAME ROLE_ROUTINE_GRANTS
573 TABLE_TYPE SYSTEM VIEW
574 ENGINE NULL
575 VERSION 10
576 ROW_FORMAT NULL
577 TABLE_ROWS #TBLR#
578 AVG_ROW_LENGTH #ARL#
579 DATA_LENGTH #DL#
580 MAX_DATA_LENGTH #MDL#
581 INDEX_LENGTH #IL#
582 DATA_FREE #DF#
583 AUTO_INCREMENT #AI#
584 CREATE_TIME #CRT#
585 UPDATE_TIME #UT#
586 CHECK_TIME #CT#
587 TABLE_COLLATION NULL
588 CHECKSUM NULL
589 CREATE_OPTIONS #CO#
590 TABLE_COMMENT #TC#
591 user_comment
592 Separator -----------------------------------------------------
593 TABLE_CATALOG def
594 TABLE_SCHEMA information_schema
595 TABLE_NAME ROLE_TABLE_GRANTS
596 TABLE_TYPE SYSTEM VIEW
597 ENGINE NULL
598 VERSION 10
599 ROW_FORMAT NULL
600 TABLE_ROWS #TBLR#
601 AVG_ROW_LENGTH #ARL#
602 DATA_LENGTH #DL#
603 MAX_DATA_LENGTH #MDL#
604 INDEX_LENGTH #IL#
605 DATA_FREE #DF#
606 AUTO_INCREMENT #AI#
607 CREATE_TIME #CRT#
608 UPDATE_TIME #UT#
609 CHECK_TIME #CT#
610 TABLE_COLLATION NULL
611 CHECKSUM NULL
612 CREATE_OPTIONS #CO#
613 TABLE_COMMENT #TC#
614 user_comment
615 Separator -----------------------------------------------------
616 TABLE_CATALOG def
617 TABLE_SCHEMA information_schema
618 TABLE_NAME ROUTINES
619 TABLE_TYPE SYSTEM VIEW
620 ENGINE NULL
621 VERSION 10
622 ROW_FORMAT NULL
623 TABLE_ROWS #TBLR#
624 AVG_ROW_LENGTH #ARL#
625 DATA_LENGTH #DL#
626 MAX_DATA_LENGTH #MDL#
627 INDEX_LENGTH #IL#
628 DATA_FREE #DF#
629 AUTO_INCREMENT #AI#
630 CREATE_TIME #CRT#
631 UPDATE_TIME #UT#
632 CHECK_TIME #CT#
633 TABLE_COLLATION NULL
634 CHECKSUM NULL
635 CREATE_OPTIONS #CO#
636 TABLE_COMMENT #TC#
637 user_comment
638 Separator -----------------------------------------------------
639 TABLE_CATALOG def
640 TABLE_SCHEMA information_schema
641 TABLE_NAME SCHEMATA
642 TABLE_TYPE SYSTEM VIEW
643 ENGINE NULL
644 VERSION 10
645 ROW_FORMAT NULL
646 TABLE_ROWS #TBLR#
647 AVG_ROW_LENGTH #ARL#
648 DATA_LENGTH #DL#
649 MAX_DATA_LENGTH #MDL#
650 INDEX_LENGTH #IL#
651 DATA_FREE #DF#
652 AUTO_INCREMENT #AI#
653 CREATE_TIME #CRT#
654 UPDATE_TIME #UT#
655 CHECK_TIME #CT#
656 TABLE_COLLATION NULL
657 CHECKSUM NULL
658 CREATE_OPTIONS #CO#
659 TABLE_COMMENT #TC#
660 user_comment
661 Separator -----------------------------------------------------
662 TABLE_CATALOG def
663 TABLE_SCHEMA information_schema
664 TABLE_NAME SCHEMATA_EXTENSIONS
665 TABLE_TYPE SYSTEM VIEW
666 ENGINE NULL
667 VERSION 10
668 ROW_FORMAT NULL
669 TABLE_ROWS #TBLR#
670 AVG_ROW_LENGTH #ARL#
671 DATA_LENGTH #DL#
672 MAX_DATA_LENGTH #MDL#
673 INDEX_LENGTH #IL#
674 DATA_FREE #DF#
675 AUTO_INCREMENT #AI#
676 CREATE_TIME #CRT#
677 UPDATE_TIME #UT#
678 CHECK_TIME #CT#
679 TABLE_COLLATION NULL
680 CHECKSUM NULL
681 CREATE_OPTIONS #CO#
682 TABLE_COMMENT #TC#
683 user_comment
684 Separator -----------------------------------------------------
685 TABLE_CATALOG def
686 TABLE_SCHEMA information_schema
687 TABLE_NAME SCHEMA_PRIVILEGES
688 TABLE_TYPE SYSTEM VIEW
689 ENGINE NULL
690 VERSION 10
691 ROW_FORMAT NULL
692 TABLE_ROWS #TBLR#
693 AVG_ROW_LENGTH #ARL#
694 DATA_LENGTH #DL#
695 MAX_DATA_LENGTH #MDL#
696 INDEX_LENGTH #IL#
697 DATA_FREE #DF#
698 AUTO_INCREMENT #AI#
699 CREATE_TIME #CRT#
700 UPDATE_TIME #UT#
701 CHECK_TIME #CT#
702 TABLE_COLLATION NULL
703 CHECKSUM NULL
704 CREATE_OPTIONS #CO#
705 TABLE_COMMENT #TC#
706 user_comment
707 Separator -----------------------------------------------------
708 TABLE_CATALOG def
709 TABLE_SCHEMA information_schema
710 TABLE_NAME STATISTICS
711 TABLE_TYPE SYSTEM VIEW
712 ENGINE NULL
713 VERSION 10
714 ROW_FORMAT NULL
715 TABLE_ROWS #TBLR#
716 AVG_ROW_LENGTH #ARL#
717 DATA_LENGTH #DL#
718 MAX_DATA_LENGTH #MDL#
719 INDEX_LENGTH #IL#
720 DATA_FREE #DF#
721 AUTO_INCREMENT #AI#
722 CREATE_TIME #CRT#
723 UPDATE_TIME #UT#
724 CHECK_TIME #CT#
725 TABLE_COLLATION NULL
726 CHECKSUM NULL
727 CREATE_OPTIONS #CO#
728 TABLE_COMMENT #TC#
729 user_comment
730 Separator -----------------------------------------------------
731 TABLE_CATALOG def
732 TABLE_SCHEMA information_schema
733 TABLE_NAME ST_GEOMETRY_COLUMNS
734 TABLE_TYPE SYSTEM VIEW
735 ENGINE NULL
736 VERSION 10
737 ROW_FORMAT NULL
738 TABLE_ROWS #TBLR#
739 AVG_ROW_LENGTH #ARL#
740 DATA_LENGTH #DL#
741 MAX_DATA_LENGTH #MDL#
742 INDEX_LENGTH #IL#
743 DATA_FREE #DF#
744 AUTO_INCREMENT #AI#
745 CREATE_TIME #CRT#
746 UPDATE_TIME #UT#
747 CHECK_TIME #CT#
748 TABLE_COLLATION NULL
749 CHECKSUM NULL
750 CREATE_OPTIONS #CO#
751 TABLE_COMMENT #TC#
752 user_comment
753 Separator -----------------------------------------------------
754 TABLE_CATALOG def
755 TABLE_SCHEMA information_schema
756 TABLE_NAME ST_SPATIAL_REFERENCE_SYSTEMS
757 TABLE_TYPE SYSTEM VIEW
758 ENGINE NULL
759 VERSION 10
760 ROW_FORMAT NULL
761 TABLE_ROWS #TBLR#
762 AVG_ROW_LENGTH #ARL#
763 DATA_LENGTH #DL#
764 MAX_DATA_LENGTH #MDL#
765 INDEX_LENGTH #IL#
766 DATA_FREE #DF#
767 AUTO_INCREMENT #AI#
768 CREATE_TIME #CRT#
769 UPDATE_TIME #UT#
770 CHECK_TIME #CT#
771 TABLE_COLLATION NULL
772 CHECKSUM NULL
773 CREATE_OPTIONS #CO#
774 TABLE_COMMENT #TC#
775 user_comment
776 Separator -----------------------------------------------------
777 TABLE_CATALOG def
778 TABLE_SCHEMA information_schema
779 TABLE_NAME ST_UNITS_OF_MEASURE
780 TABLE_TYPE SYSTEM VIEW
781 ENGINE NULL
782 VERSION 10
783 ROW_FORMAT NULL
784 TABLE_ROWS #TBLR#
785 AVG_ROW_LENGTH #ARL#
786 DATA_LENGTH #DL#
787 MAX_DATA_LENGTH #MDL#
788 INDEX_LENGTH #IL#
789 DATA_FREE #DF#
790 AUTO_INCREMENT #AI#
791 CREATE_TIME #CRT#
792 UPDATE_TIME #UT#
793 CHECK_TIME #CT#
794 TABLE_COLLATION NULL
795 CHECKSUM NULL
796 CREATE_OPTIONS #CO#
797 TABLE_COMMENT #TC#
798 user_comment
799 Separator -----------------------------------------------------
800 TABLE_CATALOG def
801 TABLE_SCHEMA information_schema
802 TABLE_NAME TABLES
803 TABLE_TYPE SYSTEM VIEW
804 ENGINE NULL
805 VERSION 10
806 ROW_FORMAT NULL
807 TABLE_ROWS #TBLR#
808 AVG_ROW_LENGTH #ARL#
809 DATA_LENGTH #DL#
810 MAX_DATA_LENGTH #MDL#
811 INDEX_LENGTH #IL#
812 DATA_FREE #DF#
813 AUTO_INCREMENT #AI#
814 CREATE_TIME #CRT#
815 UPDATE_TIME #UT#
816 CHECK_TIME #CT#
817 TABLE_COLLATION NULL
818 CHECKSUM NULL
819 CREATE_OPTIONS #CO#
820 TABLE_COMMENT #TC#
821 user_comment
822 Separator -----------------------------------------------------
823 TABLE_CATALOG def
824 TABLE_SCHEMA information_schema
825 TABLE_NAME TABLESPACES
826 TABLE_TYPE SYSTEM VIEW
827 ENGINE NULL
828 VERSION 10
829 ROW_FORMAT NULL
830 TABLE_ROWS #TBLR#
831 AVG_ROW_LENGTH #ARL#
832 DATA_LENGTH #DL#
833 MAX_DATA_LENGTH #MDL#
834 INDEX_LENGTH #IL#
835 DATA_FREE #DF#
836 AUTO_INCREMENT #AI#
837 CREATE_TIME #CRT#
838 UPDATE_TIME #UT#
839 CHECK_TIME #CT#
840 TABLE_COLLATION NULL
841 CHECKSUM NULL
842 CREATE_OPTIONS #CO#
843 TABLE_COMMENT #TC#
844 user_comment
845 Separator -----------------------------------------------------
846 TABLE_CATALOG def
847 TABLE_SCHEMA information_schema
848 TABLE_NAME TABLESPACES_EXTENSIONS
849 TABLE_TYPE SYSTEM VIEW
850 ENGINE NULL
851 VERSION 10
852 ROW_FORMAT NULL
853 TABLE_ROWS #TBLR#
854 AVG_ROW_LENGTH #ARL#
855 DATA_LENGTH #DL#
856 MAX_DATA_LENGTH #MDL#
857 INDEX_LENGTH #IL#
858 DATA_FREE #DF#
859 AUTO_INCREMENT #AI#
860 CREATE_TIME #CRT#
861 UPDATE_TIME #UT#
862 CHECK_TIME #CT#
863 TABLE_COLLATION NULL
864 CHECKSUM NULL
865 CREATE_OPTIONS #CO#
866 TABLE_COMMENT #TC#
867 user_comment
868 Separator -----------------------------------------------------
869 TABLE_CATALOG def
870 TABLE_SCHEMA information_schema
871 TABLE_NAME TABLES_EXTENSIONS
872 TABLE_TYPE SYSTEM VIEW
873 ENGINE NULL
874 VERSION 10
875 ROW_FORMAT NULL
876 TABLE_ROWS #TBLR#
877 AVG_ROW_LENGTH #ARL#
878 DATA_LENGTH #DL#
879 MAX_DATA_LENGTH #MDL#
880 INDEX_LENGTH #IL#
881 DATA_FREE #DF#
882 AUTO_INCREMENT #AI#
883 CREATE_TIME #CRT#
884 UPDATE_TIME #UT#
885 CHECK_TIME #CT#
886 TABLE_COLLATION NULL
887 CHECKSUM NULL
888 CREATE_OPTIONS #CO#
889 TABLE_COMMENT #TC#
890 user_comment
891 Separator -----------------------------------------------------
892 TABLE_CATALOG def
893 TABLE_SCHEMA information_schema
894 TABLE_NAME TABLE_CONSTRAINTS
895 TABLE_TYPE SYSTEM VIEW
896 ENGINE NULL
897 VERSION 10
898 ROW_FORMAT NULL
899 TABLE_ROWS #TBLR#
900 AVG_ROW_LENGTH #ARL#
901 DATA_LENGTH #DL#
902 MAX_DATA_LENGTH #MDL#
903 INDEX_LENGTH #IL#
904 DATA_FREE #DF#
905 AUTO_INCREMENT #AI#
906 CREATE_TIME #CRT#
907 UPDATE_TIME #UT#
908 CHECK_TIME #CT#
909 TABLE_COLLATION NULL
910 CHECKSUM NULL
911 CREATE_OPTIONS #CO#
912 TABLE_COMMENT #TC#
913 user_comment
914 Separator -----------------------------------------------------
915 TABLE_CATALOG def
916 TABLE_SCHEMA information_schema
917 TABLE_NAME TABLE_CONSTRAINTS_EXTENSIONS
918 TABLE_TYPE SYSTEM VIEW
919 ENGINE NULL
920 VERSION 10
921 ROW_FORMAT NULL
922 TABLE_ROWS #TBLR#
923 AVG_ROW_LENGTH #ARL#
924 DATA_LENGTH #DL#
925 MAX_DATA_LENGTH #MDL#
926 INDEX_LENGTH #IL#
927 DATA_FREE #DF#
928 AUTO_INCREMENT #AI#
929 CREATE_TIME #CRT#
930 UPDATE_TIME #UT#
931 CHECK_TIME #CT#
932 TABLE_COLLATION NULL
933 CHECKSUM NULL
934 CREATE_OPTIONS #CO#
935 TABLE_COMMENT #TC#
936 user_comment
937 Separator -----------------------------------------------------
938 TABLE_CATALOG def
939 TABLE_SCHEMA information_schema
940 TABLE_NAME TABLE_PRIVILEGES
941 TABLE_TYPE SYSTEM VIEW
942 ENGINE NULL
943 VERSION 10
944 ROW_FORMAT NULL
945 TABLE_ROWS #TBLR#
946 AVG_ROW_LENGTH #ARL#
947 DATA_LENGTH #DL#
948 MAX_DATA_LENGTH #MDL#
949 INDEX_LENGTH #IL#
950 DATA_FREE #DF#
951 AUTO_INCREMENT #AI#
952 CREATE_TIME #CRT#
953 UPDATE_TIME #UT#
954 CHECK_TIME #CT#
955 TABLE_COLLATION NULL
956 CHECKSUM NULL
957 CREATE_OPTIONS #CO#
958 TABLE_COMMENT #TC#
959 user_comment
960 Separator -----------------------------------------------------
961 TABLE_CATALOG def
962 TABLE_SCHEMA information_schema
963 TABLE_NAME TRIGGERS
964 TABLE_TYPE SYSTEM VIEW
965 ENGINE NULL
966 VERSION 10
967 ROW_FORMAT NULL
968 TABLE_ROWS #TBLR#
969 AVG_ROW_LENGTH #ARL#
970 DATA_LENGTH #DL#
971 MAX_DATA_LENGTH #MDL#
972 INDEX_LENGTH #IL#
973 DATA_FREE #DF#
974 AUTO_INCREMENT #AI#
975 CREATE_TIME #CRT#
976 UPDATE_TIME #UT#
977 CHECK_TIME #CT#
978 TABLE_COLLATION NULL
979 CHECKSUM NULL
980 CREATE_OPTIONS #CO#
981 TABLE_COMMENT #TC#
982 user_comment
983 Separator -----------------------------------------------------
984 TABLE_CATALOG def
985 TABLE_SCHEMA information_schema
986 TABLE_NAME USER_ATTRIBUTES
987 TABLE_TYPE SYSTEM VIEW
988 ENGINE NULL
989 VERSION 10
990 ROW_FORMAT NULL
991 TABLE_ROWS #TBLR#
992 AVG_ROW_LENGTH #ARL#
993 DATA_LENGTH #DL#
994 MAX_DATA_LENGTH #MDL#
995 INDEX_LENGTH #IL#
996 DATA_FREE #DF#
997 AUTO_INCREMENT #AI#
998 CREATE_TIME #CRT#
999 UPDATE_TIME #UT#
1000 CHECK_TIME #CT#
1001 TABLE_COLLATION NULL
1002 CHECKSUM NULL
1003 CREATE_OPTIONS #CO#
1004 TABLE_COMMENT #TC#
1005 user_comment
1006 Separator -----------------------------------------------------
1007 TABLE_CATALOG def
1008 TABLE_SCHEMA information_schema
1009 TABLE_NAME USER_PRIVILEGES
1010 TABLE_TYPE SYSTEM VIEW
1011 ENGINE NULL
1012 VERSION 10
1013 ROW_FORMAT NULL
1014 TABLE_ROWS #TBLR#
1015 AVG_ROW_LENGTH #ARL#
1016 DATA_LENGTH #DL#
1017 MAX_DATA_LENGTH #MDL#
1018 INDEX_LENGTH #IL#
1019 DATA_FREE #DF#
1020 AUTO_INCREMENT #AI#
1021 CREATE_TIME #CRT#
1022 UPDATE_TIME #UT#
1023 CHECK_TIME #CT#
1024 TABLE_COLLATION NULL
1025 CHECKSUM NULL
1026 CREATE_OPTIONS #CO#
1027 TABLE_COMMENT #TC#
1028 user_comment
1029 Separator -----------------------------------------------------
1030 TABLE_CATALOG def
1031 TABLE_SCHEMA information_schema
1032 TABLE_NAME VIEWS
1033 TABLE_TYPE SYSTEM VIEW
1034 ENGINE NULL
1035 VERSION 10
1036 ROW_FORMAT NULL
1037 TABLE_ROWS #TBLR#
1038 AVG_ROW_LENGTH #ARL#
1039 DATA_LENGTH #DL#
1040 MAX_DATA_LENGTH #MDL#
1041 INDEX_LENGTH #IL#
1042 DATA_FREE #DF#
1043 AUTO_INCREMENT #AI#
1044 CREATE_TIME #CRT#
1045 UPDATE_TIME #UT#
1046 CHECK_TIME #CT#
1047 TABLE_COLLATION NULL
1048 CHECKSUM NULL
1049 CREATE_OPTIONS #CO#
1050 TABLE_COMMENT #TC#
1051 user_comment
1052 Separator -----------------------------------------------------
1053 TABLE_CATALOG def
1054 TABLE_SCHEMA information_schema
1055 TABLE_NAME VIEW_ROUTINE_USAGE
1056 TABLE_TYPE SYSTEM VIEW
1057 ENGINE NULL
1058 VERSION 10
1059 ROW_FORMAT NULL
1060 TABLE_ROWS #TBLR#
1061 AVG_ROW_LENGTH #ARL#
1062 DATA_LENGTH #DL#
1063 MAX_DATA_LENGTH #MDL#
1064 INDEX_LENGTH #IL#
1065 DATA_FREE #DF#
1066 AUTO_INCREMENT #AI#
1067 CREATE_TIME #CRT#
1068 UPDATE_TIME #UT#
1069 CHECK_TIME #CT#
1070 TABLE_COLLATION NULL
1071 CHECKSUM NULL
1072 CREATE_OPTIONS #CO#
1073 TABLE_COMMENT #TC#
1074 user_comment
1075 Separator -----------------------------------------------------
1076 TABLE_CATALOG def
1077 TABLE_SCHEMA information_schema
1078 TABLE_NAME VIEW_TABLE_USAGE
1079 TABLE_TYPE SYSTEM VIEW
1080 ENGINE NULL
1081 VERSION 10
1082 ROW_FORMAT NULL
1083 TABLE_ROWS #TBLR#
1084 AVG_ROW_LENGTH #ARL#
1085 DATA_LENGTH #DL#
1086 MAX_DATA_LENGTH #MDL#
1087 INDEX_LENGTH #IL#
1088 DATA_FREE #DF#
1089 AUTO_INCREMENT #AI#
1090 CREATE_TIME #CRT#
1091 UPDATE_TIME #UT#
1092 CHECK_TIME #CT#
1093 TABLE_COLLATION NULL
1094 CHECKSUM NULL
1095 CREATE_OPTIONS #CO#
1096 TABLE_COMMENT #TC#
1097 user_comment
1098 Separator -----------------------------------------------------
1099 DROP USER testuser1@localhost;
1100 CREATE USER testuser1@localhost;
1101 GRANT SELECT ON test1.* TO testuser1@localhost;
1102 # Establish connection testuser1 (user=testuser1)
1103 SELECT *,
1104 LEFT( table_comment,
1105 IF(INSTR(table_comment,'TMP_TABLE_ENGINE free') = 0
1106 AND INSTR(table_comment,'number_of_replicas') = 0,
1107 LENGTH(table_comment),
1108 INSTR(table_comment,'TMP_TABLE_ENGINE free')
1109 + INSTR(table_comment,'number_of_replicas') - 1))
1110 AS "user_comment",
1111 '-----------------------------------------------------' AS "Separator"
1112 FROM information_schema.tables
1113 WHERE table_schema = 'information_schema'
1114 AND table_name COLLATE utf8_general_ci <> 'profiling'
1115 AND table_name COLLATE utf8_general_ci not like 'innodb_%'
1116 AND table_name not like 'ndb%'
1117 ORDER BY table_schema,table_name COLLATE utf8_general_ci;
1118 TABLE_CATALOG def
1119 TABLE_SCHEMA information_schema
1120 TABLE_NAME ADMINISTRABLE_ROLE_AUTHORIZATIONS
1121 TABLE_TYPE SYSTEM VIEW
1122 ENGINE NULL
1123 VERSION 10
1124 ROW_FORMAT NULL
1125 TABLE_ROWS #TBLR#
1126 AVG_ROW_LENGTH #ARL#
1127 DATA_LENGTH #DL#
1128 MAX_DATA_LENGTH #MDL#
1129 INDEX_LENGTH #IL#
1130 DATA_FREE #DF#
1131 AUTO_INCREMENT #AI#
1132 CREATE_TIME #CRT#
1133 UPDATE_TIME #UT#
1134 CHECK_TIME #CT#
1135 TABLE_COLLATION NULL
1136 CHECKSUM NULL
1137 CREATE_OPTIONS #CO#
1138 TABLE_COMMENT #TC#
1139 user_comment
1140 Separator -----------------------------------------------------
1141 TABLE_CATALOG def
1142 TABLE_SCHEMA information_schema
1143 TABLE_NAME APPLICABLE_ROLES
1144 TABLE_TYPE SYSTEM VIEW
1145 ENGINE NULL
1146 VERSION 10
1147 ROW_FORMAT NULL
1148 TABLE_ROWS #TBLR#
1149 AVG_ROW_LENGTH #ARL#
1150 DATA_LENGTH #DL#
1151 MAX_DATA_LENGTH #MDL#
1152 INDEX_LENGTH #IL#
1153 DATA_FREE #DF#
1154 AUTO_INCREMENT #AI#
1155 CREATE_TIME #CRT#
1156 UPDATE_TIME #UT#
1157 CHECK_TIME #CT#
1158 TABLE_COLLATION NULL
1159 CHECKSUM NULL
1160 CREATE_OPTIONS #CO#
1161 TABLE_COMMENT #TC#
1162 user_comment
1163 Separator -----------------------------------------------------
1164 TABLE_CATALOG def
1165 TABLE_SCHEMA information_schema
1166 TABLE_NAME CHARACTER_SETS
1167 TABLE_TYPE SYSTEM VIEW
1168 ENGINE NULL
1169 VERSION 10
1170 ROW_FORMAT NULL
1171 TABLE_ROWS #TBLR#
1172 AVG_ROW_LENGTH #ARL#
1173 DATA_LENGTH #DL#
1174 MAX_DATA_LENGTH #MDL#
1175 INDEX_LENGTH #IL#
1176 DATA_FREE #DF#
1177 AUTO_INCREMENT #AI#
1178 CREATE_TIME #CRT#
1179 UPDATE_TIME #UT#
1180 CHECK_TIME #CT#
1181 TABLE_COLLATION NULL
1182 CHECKSUM NULL
1183 CREATE_OPTIONS #CO#
1184 TABLE_COMMENT #TC#
1185 user_comment
1186 Separator -----------------------------------------------------
1187 TABLE_CATALOG def
1188 TABLE_SCHEMA information_schema
1189 TABLE_NAME CHECK_CONSTRAINTS
1190 TABLE_TYPE SYSTEM VIEW
1191 ENGINE NULL
1192 VERSION 10
1193 ROW_FORMAT NULL
1194 TABLE_ROWS #TBLR#
1195 AVG_ROW_LENGTH #ARL#
1196 DATA_LENGTH #DL#
1197 MAX_DATA_LENGTH #MDL#
1198 INDEX_LENGTH #IL#
1199 DATA_FREE #DF#
1200 AUTO_INCREMENT #AI#
1201 CREATE_TIME #CRT#
1202 UPDATE_TIME #UT#
1203 CHECK_TIME #CT#
1204 TABLE_COLLATION NULL
1205 CHECKSUM NULL
1206 CREATE_OPTIONS #CO#
1207 TABLE_COMMENT #TC#
1208 user_comment
1209 Separator -----------------------------------------------------
1210 TABLE_CATALOG def
1211 TABLE_SCHEMA information_schema
1212 TABLE_NAME COLLATIONS
1213 TABLE_TYPE SYSTEM VIEW
1214 ENGINE NULL
1215 VERSION 10
1216 ROW_FORMAT NULL
1217 TABLE_ROWS #TBLR#
1218 AVG_ROW_LENGTH #ARL#
1219 DATA_LENGTH #DL#
1220 MAX_DATA_LENGTH #MDL#
1221 INDEX_LENGTH #IL#
1222 DATA_FREE #DF#
1223 AUTO_INCREMENT #AI#
1224 CREATE_TIME #CRT#
1225 UPDATE_TIME #UT#
1226 CHECK_TIME #CT#
1227 TABLE_COLLATION NULL
1228 CHECKSUM NULL
1229 CREATE_OPTIONS #CO#
1230 TABLE_COMMENT #TC#
1231 user_comment
1232 Separator -----------------------------------------------------
1233 TABLE_CATALOG def
1234 TABLE_SCHEMA information_schema
1235 TABLE_NAME COLLATION_CHARACTER_SET_APPLICABILITY
1236 TABLE_TYPE SYSTEM VIEW
1237 ENGINE NULL
1238 VERSION 10
1239 ROW_FORMAT NULL
1240 TABLE_ROWS #TBLR#
1241 AVG_ROW_LENGTH #ARL#
1242 DATA_LENGTH #DL#
1243 MAX_DATA_LENGTH #MDL#
1244 INDEX_LENGTH #IL#
1245 DATA_FREE #DF#
1246 AUTO_INCREMENT #AI#
1247 CREATE_TIME #CRT#
1248 UPDATE_TIME #UT#
1249 CHECK_TIME #CT#
1250 TABLE_COLLATION NULL
1251 CHECKSUM NULL
1252 CREATE_OPTIONS #CO#
1253 TABLE_COMMENT #TC#
1254 user_comment
1255 Separator -----------------------------------------------------
1256 TABLE_CATALOG def
1257 TABLE_SCHEMA information_schema
1258 TABLE_NAME COLUMNS
1259 TABLE_TYPE SYSTEM VIEW
1260 ENGINE NULL
1261 VERSION 10
1262 ROW_FORMAT NULL
1263 TABLE_ROWS #TBLR#
1264 AVG_ROW_LENGTH #ARL#
1265 DATA_LENGTH #DL#
1266 MAX_DATA_LENGTH #MDL#
1267 INDEX_LENGTH #IL#
1268 DATA_FREE #DF#
1269 AUTO_INCREMENT #AI#
1270 CREATE_TIME #CRT#
1271 UPDATE_TIME #UT#
1272 CHECK_TIME #CT#
1273 TABLE_COLLATION NULL
1274 CHECKSUM NULL
1275 CREATE_OPTIONS #CO#
1276 TABLE_COMMENT #TC#
1277 user_comment
1278 Separator -----------------------------------------------------
1279 TABLE_CATALOG def
1280 TABLE_SCHEMA information_schema
1281 TABLE_NAME COLUMNS_EXTENSIONS
1282 TABLE_TYPE SYSTEM VIEW
1283 ENGINE NULL
1284 VERSION 10
1285 ROW_FORMAT NULL
1286 TABLE_ROWS #TBLR#
1287 AVG_ROW_LENGTH #ARL#
1288 DATA_LENGTH #DL#
1289 MAX_DATA_LENGTH #MDL#
1290 INDEX_LENGTH #IL#
1291 DATA_FREE #DF#
1292 AUTO_INCREMENT #AI#
1293 CREATE_TIME #CRT#
1294 UPDATE_TIME #UT#
1295 CHECK_TIME #CT#
1296 TABLE_COLLATION NULL
1297 CHECKSUM NULL
1298 CREATE_OPTIONS #CO#
1299 TABLE_COMMENT #TC#
1300 user_comment
1301 Separator -----------------------------------------------------
1302 TABLE_CATALOG def
1303 TABLE_SCHEMA information_schema
1304 TABLE_NAME COLUMN_PRIVILEGES
1305 TABLE_TYPE SYSTEM VIEW
1306 ENGINE NULL
1307 VERSION 10
1308 ROW_FORMAT NULL
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 #AI#
1316 CREATE_TIME #CRT#
1317 UPDATE_TIME #UT#
1318 CHECK_TIME #CT#
1319 TABLE_COLLATION NULL
1320 CHECKSUM NULL
1321 CREATE_OPTIONS #CO#
1322 TABLE_COMMENT #TC#
1323 user_comment
1324 Separator -----------------------------------------------------
1325 TABLE_CATALOG def
1326 TABLE_SCHEMA information_schema
1327 TABLE_NAME COLUMN_STATISTICS
1328 TABLE_TYPE SYSTEM VIEW
1329 ENGINE NULL
1330 VERSION 10
1331 ROW_FORMAT NULL
1332 TABLE_ROWS #TBLR#
1333 AVG_ROW_LENGTH #ARL#
1334 DATA_LENGTH #DL#
1335 MAX_DATA_LENGTH #MDL#
1336 INDEX_LENGTH #IL#
1337 DATA_FREE #DF#
1338 AUTO_INCREMENT #AI#
1339 CREATE_TIME #CRT#
1340 UPDATE_TIME #UT#
1341 CHECK_TIME #CT#
1342 TABLE_COLLATION NULL
1343 CHECKSUM NULL
1344 CREATE_OPTIONS #CO#
1345 TABLE_COMMENT #TC#
1346 user_comment
1347 Separator -----------------------------------------------------
1348 TABLE_CATALOG def
1349 TABLE_SCHEMA information_schema
1350 TABLE_NAME ENABLED_ROLES
1351 TABLE_TYPE SYSTEM VIEW
1352 ENGINE NULL
1353 VERSION 10
1354 ROW_FORMAT NULL
1355 TABLE_ROWS #TBLR#
1356 AVG_ROW_LENGTH #ARL#
1357 DATA_LENGTH #DL#
1358 MAX_DATA_LENGTH #MDL#
1359 INDEX_LENGTH #IL#
1360 DATA_FREE #DF#
1361 AUTO_INCREMENT #AI#
1362 CREATE_TIME #CRT#
1363 UPDATE_TIME #UT#
1364 CHECK_TIME #CT#
1365 TABLE_COLLATION NULL
1366 CHECKSUM NULL
1367 CREATE_OPTIONS #CO#
1368 TABLE_COMMENT #TC#
1369 user_comment
1370 Separator -----------------------------------------------------
1371 TABLE_CATALOG def
1372 TABLE_SCHEMA information_schema
1373 TABLE_NAME ENGINES
1374 TABLE_TYPE SYSTEM VIEW
1375 ENGINE NULL
1376 VERSION 10
1377 ROW_FORMAT NULL
1378 TABLE_ROWS #TBLR#
1379 AVG_ROW_LENGTH #ARL#
1380 DATA_LENGTH #DL#
1381 MAX_DATA_LENGTH #MDL#
1382 INDEX_LENGTH #IL#
1383 DATA_FREE #DF#
1384 AUTO_INCREMENT #AI#
1385 CREATE_TIME #CRT#
1386 UPDATE_TIME #UT#
1387 CHECK_TIME #CT#
1388 TABLE_COLLATION NULL
1389 CHECKSUM NULL
1390 CREATE_OPTIONS #CO#
1391 TABLE_COMMENT #TC#
1392 user_comment
1393 Separator -----------------------------------------------------
1394 TABLE_CATALOG def
1395 TABLE_SCHEMA information_schema
1396 TABLE_NAME EVENTS
1397 TABLE_TYPE SYSTEM VIEW
1398 ENGINE NULL
1399 VERSION 10
1400 ROW_FORMAT NULL
1401 TABLE_ROWS #TBLR#
1402 AVG_ROW_LENGTH #ARL#
1403 DATA_LENGTH #DL#
1404 MAX_DATA_LENGTH #MDL#
1405 INDEX_LENGTH #IL#
1406 DATA_FREE #DF#
1407 AUTO_INCREMENT #AI#
1408 CREATE_TIME #CRT#
1409 UPDATE_TIME #UT#
1410 CHECK_TIME #CT#
1411 TABLE_COLLATION NULL
1412 CHECKSUM NULL
1413 CREATE_OPTIONS #CO#
1414 TABLE_COMMENT #TC#
1415 user_comment
1416 Separator -----------------------------------------------------
1417 TABLE_CATALOG def
1418 TABLE_SCHEMA information_schema
1419 TABLE_NAME FILES
1420 TABLE_TYPE SYSTEM VIEW
1421 ENGINE NULL
1422 VERSION 10
1423 ROW_FORMAT NULL
1424 TABLE_ROWS #TBLR#
1425 AVG_ROW_LENGTH #ARL#
1426 DATA_LENGTH #DL#
1427 MAX_DATA_LENGTH #MDL#
1428 INDEX_LENGTH #IL#
1429 DATA_FREE #DF#
1430 AUTO_INCREMENT #AI#
1431 CREATE_TIME #CRT#
1432 UPDATE_TIME #UT#
1433 CHECK_TIME #CT#
1434 TABLE_COLLATION NULL
1435 CHECKSUM NULL
1436 CREATE_OPTIONS #CO#
1437 TABLE_COMMENT #TC#
1438 user_comment
1439 Separator -----------------------------------------------------
1440 TABLE_CATALOG def
1441 TABLE_SCHEMA information_schema
1442 TABLE_NAME KEYWORDS
1443 TABLE_TYPE SYSTEM VIEW
1444 ENGINE NULL
1445 VERSION 10
1446 ROW_FORMAT NULL
1447 TABLE_ROWS #TBLR#
1448 AVG_ROW_LENGTH #ARL#
1449 DATA_LENGTH #DL#
1450 MAX_DATA_LENGTH #MDL#
1451 INDEX_LENGTH #IL#
1452 DATA_FREE #DF#
1453 AUTO_INCREMENT #AI#
1454 CREATE_TIME #CRT#
1455 UPDATE_TIME #UT#
1456 CHECK_TIME #CT#
1457 TABLE_COLLATION NULL
1458 CHECKSUM NULL
1459 CREATE_OPTIONS #CO#
1460 TABLE_COMMENT #TC#
1461 user_comment
1462 Separator -----------------------------------------------------
1463 TABLE_CATALOG def
1464 TABLE_SCHEMA information_schema
1465 TABLE_NAME KEY_COLUMN_USAGE
1466 TABLE_TYPE SYSTEM VIEW
1467 ENGINE NULL
1468 VERSION 10
1469 ROW_FORMAT NULL
1470 TABLE_ROWS #TBLR#
1471 AVG_ROW_LENGTH #ARL#
1472 DATA_LENGTH #DL#
1473 MAX_DATA_LENGTH #MDL#
1474 INDEX_LENGTH #IL#
1475 DATA_FREE #DF#
1476 AUTO_INCREMENT #AI#
1477 CREATE_TIME #CRT#
1478 UPDATE_TIME #UT#
1479 CHECK_TIME #CT#
1480 TABLE_COLLATION NULL
1481 CHECKSUM NULL
1482 CREATE_OPTIONS #CO#
1483 TABLE_COMMENT #TC#
1484 user_comment
1485 Separator -----------------------------------------------------
1486 TABLE_CATALOG def
1487 TABLE_SCHEMA information_schema
1488 TABLE_NAME OPTIMIZER_TRACE
1489 TABLE_TYPE SYSTEM VIEW
1490 ENGINE NULL
1491 VERSION 10
1492 ROW_FORMAT NULL
1493 TABLE_ROWS #TBLR#
1494 AVG_ROW_LENGTH #ARL#
1495 DATA_LENGTH #DL#
1496 MAX_DATA_LENGTH #MDL#
1497 INDEX_LENGTH #IL#
1498 DATA_FREE #DF#
1499 AUTO_INCREMENT #AI#
1500 CREATE_TIME #CRT#
1501 UPDATE_TIME #UT#
1502 CHECK_TIME #CT#
1503 TABLE_COLLATION NULL
1504 CHECKSUM NULL
1505 CREATE_OPTIONS #CO#
1506 TABLE_COMMENT #TC#
1507 user_comment
1508 Separator -----------------------------------------------------
1509 TABLE_CATALOG def
1510 TABLE_SCHEMA information_schema
1511 TABLE_NAME PARAMETERS
1512 TABLE_TYPE SYSTEM VIEW
1513 ENGINE NULL
1514 VERSION 10
1515 ROW_FORMAT NULL
1516 TABLE_ROWS #TBLR#
1517 AVG_ROW_LENGTH #ARL#
1518 DATA_LENGTH #DL#
1519 MAX_DATA_LENGTH #MDL#
1520 INDEX_LENGTH #IL#
1521 DATA_FREE #DF#
1522 AUTO_INCREMENT #AI#
1523 CREATE_TIME #CRT#
1524 UPDATE_TIME #UT#
1525 CHECK_TIME #CT#
1526 TABLE_COLLATION NULL
1527 CHECKSUM NULL
1528 CREATE_OPTIONS #CO#
1529 TABLE_COMMENT #TC#
1530 user_comment
1531 Separator -----------------------------------------------------
1532 TABLE_CATALOG def
1533 TABLE_SCHEMA information_schema
1534 TABLE_NAME PARTITIONS
1535 TABLE_TYPE SYSTEM VIEW
1536 ENGINE NULL
1537 VERSION 10
1538 ROW_FORMAT NULL
1539 TABLE_ROWS #TBLR#
1540 AVG_ROW_LENGTH #ARL#
1541 DATA_LENGTH #DL#
1542 MAX_DATA_LENGTH #MDL#
1543 INDEX_LENGTH #IL#
1544 DATA_FREE #DF#
1545 AUTO_INCREMENT #AI#
1546 CREATE_TIME #CRT#
1547 UPDATE_TIME #UT#
1548 CHECK_TIME #CT#
1549 TABLE_COLLATION NULL
1550 CHECKSUM NULL
1551 CREATE_OPTIONS #CO#
1552 TABLE_COMMENT #TC#
1553 user_comment
1554 Separator -----------------------------------------------------
1555 TABLE_CATALOG def
1556 TABLE_SCHEMA information_schema
1557 TABLE_NAME PLUGINS
1558 TABLE_TYPE SYSTEM VIEW
1559 ENGINE NULL
1560 VERSION 10
1561 ROW_FORMAT NULL
1562 TABLE_ROWS #TBLR#
1563 AVG_ROW_LENGTH #ARL#
1564 DATA_LENGTH #DL#
1565 MAX_DATA_LENGTH #MDL#
1566 INDEX_LENGTH #IL#
1567 DATA_FREE #DF#
1568 AUTO_INCREMENT #AI#
1569 CREATE_TIME #CRT#
1570 UPDATE_TIME #UT#
1571 CHECK_TIME #CT#
1572 TABLE_COLLATION NULL
1573 CHECKSUM NULL
1574 CREATE_OPTIONS #CO#
1575 TABLE_COMMENT #TC#
1576 user_comment
1577 Separator -----------------------------------------------------
1578 TABLE_CATALOG def
1579 TABLE_SCHEMA information_schema
1580 TABLE_NAME PROCESSLIST
1581 TABLE_TYPE SYSTEM VIEW
1582 ENGINE NULL
1583 VERSION 10
1584 ROW_FORMAT NULL
1585 TABLE_ROWS #TBLR#
1586 AVG_ROW_LENGTH #ARL#
1587 DATA_LENGTH #DL#
1588 MAX_DATA_LENGTH #MDL#
1589 INDEX_LENGTH #IL#
1590 DATA_FREE #DF#
1591 AUTO_INCREMENT #AI#
1592 CREATE_TIME #CRT#
1593 UPDATE_TIME #UT#
1594 CHECK_TIME #CT#
1595 TABLE_COLLATION NULL
1596 CHECKSUM NULL
1597 CREATE_OPTIONS #CO#
1598 TABLE_COMMENT #TC#
1599 user_comment
1600 Separator -----------------------------------------------------
1601 TABLE_CATALOG def
1602 TABLE_SCHEMA information_schema
1603 TABLE_NAME REFERENTIAL_CONSTRAINTS
1604 TABLE_TYPE SYSTEM VIEW
1605 ENGINE NULL
1606 VERSION 10
1607 ROW_FORMAT NULL
1608 TABLE_ROWS #TBLR#
1609 AVG_ROW_LENGTH #ARL#
1610 DATA_LENGTH #DL#
1611 MAX_DATA_LENGTH #MDL#
1612 INDEX_LENGTH #IL#
1613 DATA_FREE #DF#
1614 AUTO_INCREMENT #AI#
1615 CREATE_TIME #CRT#
1616 UPDATE_TIME #UT#
1617 CHECK_TIME #CT#
1618 TABLE_COLLATION NULL
1619 CHECKSUM NULL
1620 CREATE_OPTIONS #CO#
1621 TABLE_COMMENT #TC#
1622 user_comment
1623 Separator -----------------------------------------------------
1624 TABLE_CATALOG def
1625 TABLE_SCHEMA information_schema
1626 TABLE_NAME RESOURCE_GROUPS
1627 TABLE_TYPE SYSTEM VIEW
1628 ENGINE NULL
1629 VERSION 10
1630 ROW_FORMAT NULL
1631 TABLE_ROWS #TBLR#
1632 AVG_ROW_LENGTH #ARL#
1633 DATA_LENGTH #DL#
1634 MAX_DATA_LENGTH #MDL#
1635 INDEX_LENGTH #IL#
1636 DATA_FREE #DF#
1637 AUTO_INCREMENT #AI#
1638 CREATE_TIME #CRT#
1639 UPDATE_TIME #UT#
1640 CHECK_TIME #CT#
1641 TABLE_COLLATION NULL
1642 CHECKSUM NULL
1643 CREATE_OPTIONS #CO#
1644 TABLE_COMMENT #TC#
1645 user_comment
1646 Separator -----------------------------------------------------
1647 TABLE_CATALOG def
1648 TABLE_SCHEMA information_schema
1649 TABLE_NAME ROLE_COLUMN_GRANTS
1650 TABLE_TYPE SYSTEM VIEW
1651 ENGINE NULL
1652 VERSION 10
1653 ROW_FORMAT NULL
1654 TABLE_ROWS #TBLR#
1655 AVG_ROW_LENGTH #ARL#
1656 DATA_LENGTH #DL#
1657 MAX_DATA_LENGTH #MDL#
1658 INDEX_LENGTH #IL#
1659 DATA_FREE #DF#
1660 AUTO_INCREMENT #AI#
1661 CREATE_TIME #CRT#
1662 UPDATE_TIME #UT#
1663 CHECK_TIME #CT#
1664 TABLE_COLLATION NULL
1665 CHECKSUM NULL
1666 CREATE_OPTIONS #CO#
1667 TABLE_COMMENT #TC#
1668 user_comment
1669 Separator -----------------------------------------------------
1670 TABLE_CATALOG def
1671 TABLE_SCHEMA information_schema
1672 TABLE_NAME ROLE_ROUTINE_GRANTS
1673 TABLE_TYPE SYSTEM VIEW
1674 ENGINE NULL
1675 VERSION 10
1676 ROW_FORMAT NULL
1677 TABLE_ROWS #TBLR#
1678 AVG_ROW_LENGTH #ARL#
1679 DATA_LENGTH #DL#
1680 MAX_DATA_LENGTH #MDL#
1681 INDEX_LENGTH #IL#
1682 DATA_FREE #DF#
1683 AUTO_INCREMENT #AI#
1684 CREATE_TIME #CRT#
1685 UPDATE_TIME #UT#
1686 CHECK_TIME #CT#
1687 TABLE_COLLATION NULL
1688 CHECKSUM NULL
1689 CREATE_OPTIONS #CO#
1690 TABLE_COMMENT #TC#
1691 user_comment
1692 Separator -----------------------------------------------------
1693 TABLE_CATALOG def
1694 TABLE_SCHEMA information_schema
1695 TABLE_NAME ROLE_TABLE_GRANTS
1696 TABLE_TYPE SYSTEM VIEW
1697 ENGINE NULL
1698 VERSION 10
1699 ROW_FORMAT NULL
1700 TABLE_ROWS #TBLR#
1701 AVG_ROW_LENGTH #ARL#
1702 DATA_LENGTH #DL#
1703 MAX_DATA_LENGTH #MDL#
1704 INDEX_LENGTH #IL#
1705 DATA_FREE #DF#
1706 AUTO_INCREMENT #AI#
1707 CREATE_TIME #CRT#
1708 UPDATE_TIME #UT#
1709 CHECK_TIME #CT#
1710 TABLE_COLLATION NULL
1711 CHECKSUM NULL
1712 CREATE_OPTIONS #CO#
1713 TABLE_COMMENT #TC#
1714 user_comment
1715 Separator -----------------------------------------------------
1716 TABLE_CATALOG def
1717 TABLE_SCHEMA information_schema
1718 TABLE_NAME ROUTINES
1719 TABLE_TYPE SYSTEM VIEW
1720 ENGINE NULL
1721 VERSION 10
1722 ROW_FORMAT NULL
1723 TABLE_ROWS #TBLR#
1724 AVG_ROW_LENGTH #ARL#
1725 DATA_LENGTH #DL#
1726 MAX_DATA_LENGTH #MDL#
1727 INDEX_LENGTH #IL#
1728 DATA_FREE #DF#
1729 AUTO_INCREMENT #AI#
1730 CREATE_TIME #CRT#
1731 UPDATE_TIME #UT#
1732 CHECK_TIME #CT#
1733 TABLE_COLLATION NULL
1734 CHECKSUM NULL
1735 CREATE_OPTIONS #CO#
1736 TABLE_COMMENT #TC#
1737 user_comment
1738 Separator -----------------------------------------------------
1739 TABLE_CATALOG def
1740 TABLE_SCHEMA information_schema
1741 TABLE_NAME SCHEMATA
1742 TABLE_TYPE SYSTEM VIEW
1743 ENGINE NULL
1744 VERSION 10
1745 ROW_FORMAT NULL
1746 TABLE_ROWS #TBLR#
1747 AVG_ROW_LENGTH #ARL#
1748 DATA_LENGTH #DL#
1749 MAX_DATA_LENGTH #MDL#
1750 INDEX_LENGTH #IL#
1751 DATA_FREE #DF#
1752 AUTO_INCREMENT #AI#
1753 CREATE_TIME #CRT#
1754 UPDATE_TIME #UT#
1755 CHECK_TIME #CT#
1756 TABLE_COLLATION NULL
1757 CHECKSUM NULL
1758 CREATE_OPTIONS #CO#
1759 TABLE_COMMENT #TC#
1760 user_comment
1761 Separator -----------------------------------------------------
1762 TABLE_CATALOG def
1763 TABLE_SCHEMA information_schema
1764 TABLE_NAME SCHEMATA_EXTENSIONS
1765 TABLE_TYPE SYSTEM VIEW
1766 ENGINE NULL
1767 VERSION 10
1768 ROW_FORMAT NULL
1769 TABLE_ROWS #TBLR#
1770 AVG_ROW_LENGTH #ARL#
1771 DATA_LENGTH #DL#
1772 MAX_DATA_LENGTH #MDL#
1773 INDEX_LENGTH #IL#
1774 DATA_FREE #DF#
1775 AUTO_INCREMENT #AI#
1776 CREATE_TIME #CRT#
1777 UPDATE_TIME #UT#
1778 CHECK_TIME #CT#
1779 TABLE_COLLATION NULL
1780 CHECKSUM NULL
1781 CREATE_OPTIONS #CO#
1782 TABLE_COMMENT #TC#
1783 user_comment
1784 Separator -----------------------------------------------------
1785 TABLE_CATALOG def
1786 TABLE_SCHEMA information_schema
1787 TABLE_NAME SCHEMA_PRIVILEGES
1788 TABLE_TYPE SYSTEM VIEW
1789 ENGINE NULL
1790 VERSION 10
1791 ROW_FORMAT NULL
1792 TABLE_ROWS #TBLR#
1793 AVG_ROW_LENGTH #ARL#
1794 DATA_LENGTH #DL#
1795 MAX_DATA_LENGTH #MDL#
1796 INDEX_LENGTH #IL#
1797 DATA_FREE #DF#
1798 AUTO_INCREMENT #AI#
1799 CREATE_TIME #CRT#
1800 UPDATE_TIME #UT#
1801 CHECK_TIME #CT#
1802 TABLE_COLLATION NULL
1803 CHECKSUM NULL
1804 CREATE_OPTIONS #CO#
1805 TABLE_COMMENT #TC#
1806 user_comment
1807 Separator -----------------------------------------------------
1808 TABLE_CATALOG def
1809 TABLE_SCHEMA information_schema
1810 TABLE_NAME STATISTICS
1811 TABLE_TYPE SYSTEM VIEW
1812 ENGINE NULL
1813 VERSION 10
1814 ROW_FORMAT NULL
1815 TABLE_ROWS #TBLR#
1816 AVG_ROW_LENGTH #ARL#
1817 DATA_LENGTH #DL#
1818 MAX_DATA_LENGTH #MDL#
1819 INDEX_LENGTH #IL#
1820 DATA_FREE #DF#
1821 AUTO_INCREMENT #AI#
1822 CREATE_TIME #CRT#
1823 UPDATE_TIME #UT#
1824 CHECK_TIME #CT#
1825 TABLE_COLLATION NULL
1826 CHECKSUM NULL
1827 CREATE_OPTIONS #CO#
1828 TABLE_COMMENT #TC#
1829 user_comment
1830 Separator -----------------------------------------------------
1831 TABLE_CATALOG def
1832 TABLE_SCHEMA information_schema
1833 TABLE_NAME ST_GEOMETRY_COLUMNS
1834 TABLE_TYPE SYSTEM VIEW
1835 ENGINE NULL
1836 VERSION 10
1837 ROW_FORMAT NULL
1838 TABLE_ROWS #TBLR#
1839 AVG_ROW_LENGTH #ARL#
1840 DATA_LENGTH #DL#
1841 MAX_DATA_LENGTH #MDL#
1842 INDEX_LENGTH #IL#
1843 DATA_FREE #DF#
1844 AUTO_INCREMENT #AI#
1845 CREATE_TIME #CRT#
1846 UPDATE_TIME #UT#
1847 CHECK_TIME #CT#
1848 TABLE_COLLATION NULL
1849 CHECKSUM NULL
1850 CREATE_OPTIONS #CO#
1851 TABLE_COMMENT #TC#
1852 user_comment
1853 Separator -----------------------------------------------------
1854 TABLE_CATALOG def
1855 TABLE_SCHEMA information_schema
1856 TABLE_NAME ST_SPATIAL_REFERENCE_SYSTEMS
1857 TABLE_TYPE SYSTEM VIEW
1858 ENGINE NULL
1859 VERSION 10
1860 ROW_FORMAT NULL
1861 TABLE_ROWS #TBLR#
1862 AVG_ROW_LENGTH #ARL#
1863 DATA_LENGTH #DL#
1864 MAX_DATA_LENGTH #MDL#
1865 INDEX_LENGTH #IL#
1866 DATA_FREE #DF#
1867 AUTO_INCREMENT #AI#
1868 CREATE_TIME #CRT#
1869 UPDATE_TIME #UT#
1870 CHECK_TIME #CT#
1871 TABLE_COLLATION NULL
1872 CHECKSUM NULL
1873 CREATE_OPTIONS #CO#
1874 TABLE_COMMENT #TC#
1875 user_comment
1876 Separator -----------------------------------------------------
1877 TABLE_CATALOG def
1878 TABLE_SCHEMA information_schema
1879 TABLE_NAME ST_UNITS_OF_MEASURE
1880 TABLE_TYPE SYSTEM VIEW
1881 ENGINE NULL
1882 VERSION 10
1883 ROW_FORMAT NULL
1884 TABLE_ROWS #TBLR#
1885 AVG_ROW_LENGTH #ARL#
1886 DATA_LENGTH #DL#
1887 MAX_DATA_LENGTH #MDL#
1888 INDEX_LENGTH #IL#
1889 DATA_FREE #DF#
1890 AUTO_INCREMENT #AI#
1891 CREATE_TIME #CRT#
1892 UPDATE_TIME #UT#
1893 CHECK_TIME #CT#
1894 TABLE_COLLATION NULL
1895 CHECKSUM NULL
1896 CREATE_OPTIONS #CO#
1897 TABLE_COMMENT #TC#
1898 user_comment
1899 Separator -----------------------------------------------------
1900 TABLE_CATALOG def
1901 TABLE_SCHEMA information_schema
1902 TABLE_NAME TABLES
1903 TABLE_TYPE SYSTEM VIEW
1904 ENGINE NULL
1905 VERSION 10
1906 ROW_FORMAT NULL
1907 TABLE_ROWS #TBLR#
1908 AVG_ROW_LENGTH #ARL#
1909 DATA_LENGTH #DL#
1910 MAX_DATA_LENGTH #MDL#
1911 INDEX_LENGTH #IL#
1912 DATA_FREE #DF#
1913 AUTO_INCREMENT #AI#
1914 CREATE_TIME #CRT#
1915 UPDATE_TIME #UT#
1916 CHECK_TIME #CT#
1917 TABLE_COLLATION NULL
1918 CHECKSUM NULL
1919 CREATE_OPTIONS #CO#
1920 TABLE_COMMENT #TC#
1921 user_comment
1922 Separator -----------------------------------------------------
1923 TABLE_CATALOG def
1924 TABLE_SCHEMA information_schema
1925 TABLE_NAME TABLESPACES
1926 TABLE_TYPE SYSTEM VIEW
1927 ENGINE NULL
1928 VERSION 10
1929 ROW_FORMAT NULL
1930 TABLE_ROWS #TBLR#
1931 AVG_ROW_LENGTH #ARL#
1932 DATA_LENGTH #DL#
1933 MAX_DATA_LENGTH #MDL#
1934 INDEX_LENGTH #IL#
1935 DATA_FREE #DF#
1936 AUTO_INCREMENT #AI#
1937 CREATE_TIME #CRT#
1938 UPDATE_TIME #UT#
1939 CHECK_TIME #CT#
1940 TABLE_COLLATION NULL
1941 CHECKSUM NULL
1942 CREATE_OPTIONS #CO#
1943 TABLE_COMMENT #TC#
1944 user_comment
1945 Separator -----------------------------------------------------
1946 TABLE_CATALOG def
1947 TABLE_SCHEMA information_schema
1948 TABLE_NAME TABLESPACES_EXTENSIONS
1949 TABLE_TYPE SYSTEM VIEW
1950 ENGINE NULL
1951 VERSION 10
1952 ROW_FORMAT NULL
1953 TABLE_ROWS #TBLR#
1954 AVG_ROW_LENGTH #ARL#
1955 DATA_LENGTH #DL#
1956 MAX_DATA_LENGTH #MDL#
1957 INDEX_LENGTH #IL#
1958 DATA_FREE #DF#
1959 AUTO_INCREMENT #AI#
1960 CREATE_TIME #CRT#
1961 UPDATE_TIME #UT#
1962 CHECK_TIME #CT#
1963 TABLE_COLLATION NULL
1964 CHECKSUM NULL
1965 CREATE_OPTIONS #CO#
1966 TABLE_COMMENT #TC#
1967 user_comment
1968 Separator -----------------------------------------------------
1969 TABLE_CATALOG def
1970 TABLE_SCHEMA information_schema
1971 TABLE_NAME TABLES_EXTENSIONS
1972 TABLE_TYPE SYSTEM VIEW
1973 ENGINE NULL
1974 VERSION 10
1975 ROW_FORMAT NULL
1976 TABLE_ROWS #TBLR#
1977 AVG_ROW_LENGTH #ARL#
1978 DATA_LENGTH #DL#
1979 MAX_DATA_LENGTH #MDL#
1980 INDEX_LENGTH #IL#
1981 DATA_FREE #DF#
1982 AUTO_INCREMENT #AI#
1983 CREATE_TIME #CRT#
1984 UPDATE_TIME #UT#
1985 CHECK_TIME #CT#
1986 TABLE_COLLATION NULL
1987 CHECKSUM NULL
1988 CREATE_OPTIONS #CO#
1989 TABLE_COMMENT #TC#
1990 user_comment
1991 Separator -----------------------------------------------------
1992 TABLE_CATALOG def
1993 TABLE_SCHEMA information_schema
1994 TABLE_NAME TABLE_CONSTRAINTS
1995 TABLE_TYPE SYSTEM VIEW
1996 ENGINE NULL
1997 VERSION 10
1998 ROW_FORMAT NULL
1999 TABLE_ROWS #TBLR#
2000 AVG_ROW_LENGTH #ARL#
2001 DATA_LENGTH #DL#
2002 MAX_DATA_LENGTH #MDL#
2003 INDEX_LENGTH #IL#
2004 DATA_FREE #DF#
2005 AUTO_INCREMENT #AI#
2006 CREATE_TIME #CRT#
2007 UPDATE_TIME #UT#
2008 CHECK_TIME #CT#
2009 TABLE_COLLATION NULL
2010 CHECKSUM NULL
2011 CREATE_OPTIONS #CO#
2012 TABLE_COMMENT #TC#
2013 user_comment
2014 Separator -----------------------------------------------------
2015 TABLE_CATALOG def
2016 TABLE_SCHEMA information_schema
2017 TABLE_NAME TABLE_CONSTRAINTS_EXTENSIONS
2018 TABLE_TYPE SYSTEM VIEW
2019 ENGINE NULL
2020 VERSION 10
2021 ROW_FORMAT NULL
2022 TABLE_ROWS #TBLR#
2023 AVG_ROW_LENGTH #ARL#
2024 DATA_LENGTH #DL#
2025 MAX_DATA_LENGTH #MDL#
2026 INDEX_LENGTH #IL#
2027 DATA_FREE #DF#
2028 AUTO_INCREMENT #AI#
2029 CREATE_TIME #CRT#
2030 UPDATE_TIME #UT#
2031 CHECK_TIME #CT#
2032 TABLE_COLLATION NULL
2033 CHECKSUM NULL
2034 CREATE_OPTIONS #CO#
2035 TABLE_COMMENT #TC#
2036 user_comment
2037 Separator -----------------------------------------------------
2038 TABLE_CATALOG def
2039 TABLE_SCHEMA information_schema
2040 TABLE_NAME TABLE_PRIVILEGES
2041 TABLE_TYPE SYSTEM VIEW
2042 ENGINE NULL
2043 VERSION 10
2044 ROW_FORMAT NULL
2045 TABLE_ROWS #TBLR#
2046 AVG_ROW_LENGTH #ARL#
2047 DATA_LENGTH #DL#
2048 MAX_DATA_LENGTH #MDL#
2049 INDEX_LENGTH #IL#
2050 DATA_FREE #DF#
2051 AUTO_INCREMENT #AI#
2052 CREATE_TIME #CRT#
2053 UPDATE_TIME #UT#
2054 CHECK_TIME #CT#
2055 TABLE_COLLATION NULL
2056 CHECKSUM NULL
2057 CREATE_OPTIONS #CO#
2058 TABLE_COMMENT #TC#
2059 user_comment
2060 Separator -----------------------------------------------------
2061 TABLE_CATALOG def
2062 TABLE_SCHEMA information_schema
2063 TABLE_NAME TRIGGERS
2064 TABLE_TYPE SYSTEM VIEW
2065 ENGINE NULL
2066 VERSION 10
2067 ROW_FORMAT NULL
2068 TABLE_ROWS #TBLR#
2069 AVG_ROW_LENGTH #ARL#
2070 DATA_LENGTH #DL#
2071 MAX_DATA_LENGTH #MDL#
2072 INDEX_LENGTH #IL#
2073 DATA_FREE #DF#
2074 AUTO_INCREMENT #AI#
2075 CREATE_TIME #CRT#
2076 UPDATE_TIME #UT#
2077 CHECK_TIME #CT#
2078 TABLE_COLLATION NULL
2079 CHECKSUM NULL
2080 CREATE_OPTIONS #CO#
2081 TABLE_COMMENT #TC#
2082 user_comment
2083 Separator -----------------------------------------------------
2084 TABLE_CATALOG def
2085 TABLE_SCHEMA information_schema
2086 TABLE_NAME USER_ATTRIBUTES
2087 TABLE_TYPE SYSTEM VIEW
2088 ENGINE NULL
2089 VERSION 10
2090 ROW_FORMAT NULL
2091 TABLE_ROWS #TBLR#
2092 AVG_ROW_LENGTH #ARL#
2093 DATA_LENGTH #DL#
2094 MAX_DATA_LENGTH #MDL#
2095 INDEX_LENGTH #IL#
2096 DATA_FREE #DF#
2097 AUTO_INCREMENT #AI#
2098 CREATE_TIME #CRT#
2099 UPDATE_TIME #UT#
2100 CHECK_TIME #CT#
2101 TABLE_COLLATION NULL
2102 CHECKSUM NULL
2103 CREATE_OPTIONS #CO#
2104 TABLE_COMMENT #TC#
2105 user_comment
2106 Separator -----------------------------------------------------
2107 TABLE_CATALOG def
2108 TABLE_SCHEMA information_schema
2109 TABLE_NAME USER_PRIVILEGES
2110 TABLE_TYPE SYSTEM VIEW
2111 ENGINE NULL
2112 VERSION 10
2113 ROW_FORMAT NULL
2114 TABLE_ROWS #TBLR#
2115 AVG_ROW_LENGTH #ARL#
2116 DATA_LENGTH #DL#
2117 MAX_DATA_LENGTH #MDL#
2118 INDEX_LENGTH #IL#
2119 DATA_FREE #DF#
2120 AUTO_INCREMENT #AI#
2121 CREATE_TIME #CRT#
2122 UPDATE_TIME #UT#
2123 CHECK_TIME #CT#
2124 TABLE_COLLATION NULL
2125 CHECKSUM NULL
2126 CREATE_OPTIONS #CO#
2127 TABLE_COMMENT #TC#
2128 user_comment
2129 Separator -----------------------------------------------------
2130 TABLE_CATALOG def
2131 TABLE_SCHEMA information_schema
2132 TABLE_NAME VIEWS
2133 TABLE_TYPE SYSTEM VIEW
2134 ENGINE NULL
2135 VERSION 10
2136 ROW_FORMAT NULL
2137 TABLE_ROWS #TBLR#
2138 AVG_ROW_LENGTH #ARL#
2139 DATA_LENGTH #DL#
2140 MAX_DATA_LENGTH #MDL#
2141 INDEX_LENGTH #IL#
2142 DATA_FREE #DF#
2143 AUTO_INCREMENT #AI#
2144 CREATE_TIME #CRT#
2145 UPDATE_TIME #UT#
2146 CHECK_TIME #CT#
2147 TABLE_COLLATION NULL
2148 CHECKSUM NULL
2149 CREATE_OPTIONS #CO#
2150 TABLE_COMMENT #TC#
2151 user_comment
2152 Separator -----------------------------------------------------
2153 TABLE_CATALOG def
2154 TABLE_SCHEMA information_schema
2155 TABLE_NAME VIEW_ROUTINE_USAGE
2156 TABLE_TYPE SYSTEM VIEW
2157 ENGINE NULL
2158 VERSION 10
2159 ROW_FORMAT NULL
2160 TABLE_ROWS #TBLR#
2161 AVG_ROW_LENGTH #ARL#
2162 DATA_LENGTH #DL#
2163 MAX_DATA_LENGTH #MDL#
2164 INDEX_LENGTH #IL#
2165 DATA_FREE #DF#
2166 AUTO_INCREMENT #AI#
2167 CREATE_TIME #CRT#
2168 UPDATE_TIME #UT#
2169 CHECK_TIME #CT#
2170 TABLE_COLLATION NULL
2171 CHECKSUM NULL
2172 CREATE_OPTIONS #CO#
2173 TABLE_COMMENT #TC#
2174 user_comment
2175 Separator -----------------------------------------------------
2176 TABLE_CATALOG def
2177 TABLE_SCHEMA information_schema
2178 TABLE_NAME VIEW_TABLE_USAGE
2179 TABLE_TYPE SYSTEM VIEW
2180 ENGINE NULL
2181 VERSION 10
2182 ROW_FORMAT NULL
2183 TABLE_ROWS #TBLR#
2184 AVG_ROW_LENGTH #ARL#
2185 DATA_LENGTH #DL#
2186 MAX_DATA_LENGTH #MDL#
2187 INDEX_LENGTH #IL#
2188 DATA_FREE #DF#
2189 AUTO_INCREMENT #AI#
2190 CREATE_TIME #CRT#
2191 UPDATE_TIME #UT#
2192 CHECK_TIME #CT#
2193 TABLE_COLLATION NULL
2194 CHECKSUM NULL
2195 CREATE_OPTIONS #CO#
2196 TABLE_COMMENT #TC#
2197 user_comment
2198 Separator -----------------------------------------------------
2199 # Switch to connection default and close connection testuser1
2200 DROP USER testuser1@localhost;
2201 DROP DATABASE test1;