[tomato.git] / release / src / router / mysql / mysql-test / suite / funcs_1 / r / is_tables_mysql_embedded.result
| blob | df7a1ea5e373ed45ac2e446cf2f1b877f5b6c97e |
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 AND INSTR(table_comment,'number_of_replicas') = 0,
7 LENGTH(table_comment),
8 INSTR(table_comment,'InnoDB 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'
14 ORDER BY table_schema,table_name;
15 TABLE_CATALOG NULL
16 TABLE_SCHEMA mysql
17 TABLE_NAME columns_priv
18 TABLE_TYPE BASE TABLE
19 ENGINE MyISAM
20 VERSION 10
21 ROW_FORMAT Fixed
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 NULL
29 CREATE_TIME #CRT#
30 UPDATE_TIME #UT#
31 CHECK_TIME #CT#
32 TABLE_COLLATION utf8_bin
33 CHECKSUM NULL
34 CREATE_OPTIONS #CO#
35 TABLE_COMMENT #TC#
36 user_comment Column privileges
37 Separator -----------------------------------------------------
38 TABLE_CATALOG NULL
39 TABLE_SCHEMA mysql
40 TABLE_NAME db
41 TABLE_TYPE BASE TABLE
42 ENGINE MyISAM
43 VERSION 10
44 ROW_FORMAT Fixed
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 utf8_bin
56 CHECKSUM NULL
57 CREATE_OPTIONS #CO#
58 TABLE_COMMENT #TC#
59 user_comment Database privileges
60 Separator -----------------------------------------------------
61 TABLE_CATALOG NULL
62 TABLE_SCHEMA mysql
63 TABLE_NAME event
64 TABLE_TYPE BASE TABLE
65 ENGINE MyISAM
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 NULL
75 CREATE_TIME #CRT#
76 UPDATE_TIME #UT#
77 CHECK_TIME #CT#
78 TABLE_COLLATION utf8_general_ci
79 CHECKSUM NULL
80 CREATE_OPTIONS #CO#
81 TABLE_COMMENT #TC#
82 user_comment Events
83 Separator -----------------------------------------------------
84 TABLE_CATALOG NULL
85 TABLE_SCHEMA mysql
86 TABLE_NAME func
87 TABLE_TYPE BASE TABLE
88 ENGINE MyISAM
89 VERSION 10
90 ROW_FORMAT Fixed
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 NULL
98 CREATE_TIME #CRT#
99 UPDATE_TIME #UT#
100 CHECK_TIME #CT#
101 TABLE_COLLATION utf8_bin
102 CHECKSUM NULL
103 CREATE_OPTIONS #CO#
104 TABLE_COMMENT #TC#
105 user_comment User defined functions
106 Separator -----------------------------------------------------
107 TABLE_CATALOG NULL
108 TABLE_SCHEMA mysql
109 TABLE_NAME general_log
110 TABLE_TYPE BASE TABLE
111 ENGINE CSV
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 NULL
121 CREATE_TIME #CRT#
122 UPDATE_TIME #UT#
123 CHECK_TIME #CT#
124 TABLE_COLLATION utf8_general_ci
125 CHECKSUM NULL
126 CREATE_OPTIONS #CO#
127 TABLE_COMMENT #TC#
128 user_comment General log
129 Separator -----------------------------------------------------
130 TABLE_CATALOG NULL
131 TABLE_SCHEMA mysql
132 TABLE_NAME help_category
133 TABLE_TYPE BASE TABLE
134 ENGINE MyISAM
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 NULL
144 CREATE_TIME #CRT#
145 UPDATE_TIME #UT#
146 CHECK_TIME #CT#
147 TABLE_COLLATION utf8_general_ci
148 CHECKSUM NULL
149 CREATE_OPTIONS #CO#
150 TABLE_COMMENT #TC#
151 user_comment help categories
152 Separator -----------------------------------------------------
153 TABLE_CATALOG NULL
154 TABLE_SCHEMA mysql
155 TABLE_NAME help_keyword
156 TABLE_TYPE BASE TABLE
157 ENGINE MyISAM
158 VERSION 10
159 ROW_FORMAT Fixed
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 NULL
167 CREATE_TIME #CRT#
168 UPDATE_TIME #UT#
169 CHECK_TIME #CT#
170 TABLE_COLLATION utf8_general_ci
171 CHECKSUM NULL
172 CREATE_OPTIONS #CO#
173 TABLE_COMMENT #TC#
174 user_comment help keywords
175 Separator -----------------------------------------------------
176 TABLE_CATALOG NULL
177 TABLE_SCHEMA mysql
178 TABLE_NAME help_relation
179 TABLE_TYPE BASE TABLE
180 ENGINE MyISAM
181 VERSION 10
182 ROW_FORMAT Fixed
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 NULL
190 CREATE_TIME #CRT#
191 UPDATE_TIME #UT#
192 CHECK_TIME #CT#
193 TABLE_COLLATION utf8_general_ci
194 CHECKSUM NULL
195 CREATE_OPTIONS #CO#
196 TABLE_COMMENT #TC#
197 user_comment keyword-topic relation
198 Separator -----------------------------------------------------
199 TABLE_CATALOG NULL
200 TABLE_SCHEMA mysql
201 TABLE_NAME help_topic
202 TABLE_TYPE BASE TABLE
203 ENGINE MyISAM
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 NULL
213 CREATE_TIME #CRT#
214 UPDATE_TIME #UT#
215 CHECK_TIME #CT#
216 TABLE_COLLATION utf8_general_ci
217 CHECKSUM NULL
218 CREATE_OPTIONS #CO#
219 TABLE_COMMENT #TC#
220 user_comment help topics
221 Separator -----------------------------------------------------
222 TABLE_CATALOG NULL
223 TABLE_SCHEMA mysql
224 TABLE_NAME host
225 TABLE_TYPE BASE TABLE
226 ENGINE MyISAM
227 VERSION 10
228 ROW_FORMAT Fixed
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 NULL
236 CREATE_TIME #CRT#
237 UPDATE_TIME #UT#
238 CHECK_TIME #CT#
239 TABLE_COLLATION utf8_bin
240 CHECKSUM NULL
241 CREATE_OPTIONS #CO#
242 TABLE_COMMENT #TC#
243 user_comment Host privileges; Merged with database privileges
244 Separator -----------------------------------------------------
245 TABLE_CATALOG NULL
246 TABLE_SCHEMA mysql
247 TABLE_NAME ndb_binlog_index
248 TABLE_TYPE BASE TABLE
249 ENGINE MyISAM
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 NULL
259 CREATE_TIME #CRT#
260 UPDATE_TIME #UT#
261 CHECK_TIME #CT#
262 TABLE_COLLATION latin1_swedish_ci
263 CHECKSUM NULL
264 CREATE_OPTIONS #CO#
265 TABLE_COMMENT #TC#
266 user_comment
267 Separator -----------------------------------------------------
268 TABLE_CATALOG NULL
269 TABLE_SCHEMA mysql
270 TABLE_NAME plugin
271 TABLE_TYPE BASE TABLE
272 ENGINE MyISAM
273 VERSION 10
274 ROW_FORMAT Fixed
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 NULL
282 CREATE_TIME #CRT#
283 UPDATE_TIME #UT#
284 CHECK_TIME #CT#
285 TABLE_COLLATION utf8_bin
286 CHECKSUM NULL
287 CREATE_OPTIONS #CO#
288 TABLE_COMMENT #TC#
289 user_comment MySQL plugins
290 Separator -----------------------------------------------------
291 TABLE_CATALOG NULL
292 TABLE_SCHEMA mysql
293 TABLE_NAME proc
294 TABLE_TYPE BASE TABLE
295 ENGINE MyISAM
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 NULL
305 CREATE_TIME #CRT#
306 UPDATE_TIME #UT#
307 CHECK_TIME #CT#
308 TABLE_COLLATION utf8_general_ci
309 CHECKSUM NULL
310 CREATE_OPTIONS #CO#
311 TABLE_COMMENT #TC#
312 user_comment Stored Procedures
313 Separator -----------------------------------------------------
314 TABLE_CATALOG NULL
315 TABLE_SCHEMA mysql
316 TABLE_NAME procs_priv
317 TABLE_TYPE BASE TABLE
318 ENGINE MyISAM
319 VERSION 10
320 ROW_FORMAT Fixed
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 NULL
328 CREATE_TIME #CRT#
329 UPDATE_TIME #UT#
330 CHECK_TIME #CT#
331 TABLE_COLLATION utf8_bin
332 CHECKSUM NULL
333 CREATE_OPTIONS #CO#
334 TABLE_COMMENT #TC#
335 user_comment Procedure privileges
336 Separator -----------------------------------------------------
337 TABLE_CATALOG NULL
338 TABLE_SCHEMA mysql
339 TABLE_NAME servers
340 TABLE_TYPE BASE TABLE
341 ENGINE MyISAM
342 VERSION 10
343 ROW_FORMAT Fixed
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 NULL
351 CREATE_TIME #CRT#
352 UPDATE_TIME #UT#
353 CHECK_TIME #CT#
354 TABLE_COLLATION utf8_general_ci
355 CHECKSUM NULL
356 CREATE_OPTIONS #CO#
357 TABLE_COMMENT #TC#
358 user_comment MySQL Foreign Servers table
359 Separator -----------------------------------------------------
360 TABLE_CATALOG NULL
361 TABLE_SCHEMA mysql
362 TABLE_NAME slow_log
363 TABLE_TYPE BASE TABLE
364 ENGINE CSV
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 NULL
374 CREATE_TIME #CRT#
375 UPDATE_TIME #UT#
376 CHECK_TIME #CT#
377 TABLE_COLLATION utf8_general_ci
378 CHECKSUM NULL
379 CREATE_OPTIONS #CO#
380 TABLE_COMMENT #TC#
381 user_comment Slow log
382 Separator -----------------------------------------------------
383 TABLE_CATALOG NULL
384 TABLE_SCHEMA mysql
385 TABLE_NAME tables_priv
386 TABLE_TYPE BASE TABLE
387 ENGINE MyISAM
388 VERSION 10
389 ROW_FORMAT Fixed
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 NULL
397 CREATE_TIME #CRT#
398 UPDATE_TIME #UT#
399 CHECK_TIME #CT#
400 TABLE_COLLATION utf8_bin
401 CHECKSUM NULL
402 CREATE_OPTIONS #CO#
403 TABLE_COMMENT #TC#
404 user_comment Table privileges
405 Separator -----------------------------------------------------
406 TABLE_CATALOG NULL
407 TABLE_SCHEMA mysql
408 TABLE_NAME time_zone
409 TABLE_TYPE BASE TABLE
410 ENGINE MyISAM
411 VERSION 10
412 ROW_FORMAT Fixed
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 6
420 CREATE_TIME #CRT#
421 UPDATE_TIME #UT#
422 CHECK_TIME #CT#
423 TABLE_COLLATION utf8_general_ci
424 CHECKSUM NULL
425 CREATE_OPTIONS #CO#
426 TABLE_COMMENT #TC#
427 user_comment Time zones
428 Separator -----------------------------------------------------
429 TABLE_CATALOG NULL
430 TABLE_SCHEMA mysql
431 TABLE_NAME time_zone_leap_second
432 TABLE_TYPE BASE TABLE
433 ENGINE MyISAM
434 VERSION 10
435 ROW_FORMAT Fixed
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 NULL
443 CREATE_TIME #CRT#
444 UPDATE_TIME #UT#
445 CHECK_TIME #CT#
446 TABLE_COLLATION utf8_general_ci
447 CHECKSUM NULL
448 CREATE_OPTIONS #CO#
449 TABLE_COMMENT #TC#
450 user_comment Leap seconds information for time zones
451 Separator -----------------------------------------------------
452 TABLE_CATALOG NULL
453 TABLE_SCHEMA mysql
454 TABLE_NAME time_zone_name
455 TABLE_TYPE BASE TABLE
456 ENGINE MyISAM
457 VERSION 10
458 ROW_FORMAT Fixed
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 NULL
466 CREATE_TIME #CRT#
467 UPDATE_TIME #UT#
468 CHECK_TIME #CT#
469 TABLE_COLLATION utf8_general_ci
470 CHECKSUM NULL
471 CREATE_OPTIONS #CO#
472 TABLE_COMMENT #TC#
473 user_comment Time zone names
474 Separator -----------------------------------------------------
475 TABLE_CATALOG NULL
476 TABLE_SCHEMA mysql
477 TABLE_NAME time_zone_transition
478 TABLE_TYPE BASE TABLE
479 ENGINE MyISAM
480 VERSION 10
481 ROW_FORMAT Fixed
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 NULL
489 CREATE_TIME #CRT#
490 UPDATE_TIME #UT#
491 CHECK_TIME #CT#
492 TABLE_COLLATION utf8_general_ci
493 CHECKSUM NULL
494 CREATE_OPTIONS #CO#
495 TABLE_COMMENT #TC#
496 user_comment Time zone transitions
497 Separator -----------------------------------------------------
498 TABLE_CATALOG NULL
499 TABLE_SCHEMA mysql
500 TABLE_NAME time_zone_transition_type
501 TABLE_TYPE BASE TABLE
502 ENGINE MyISAM
503 VERSION 10
504 ROW_FORMAT Fixed
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 NULL
512 CREATE_TIME #CRT#
513 UPDATE_TIME #UT#
514 CHECK_TIME #CT#
515 TABLE_COLLATION utf8_general_ci
516 CHECKSUM NULL
517 CREATE_OPTIONS #CO#
518 TABLE_COMMENT #TC#
519 user_comment Time zone transition types
520 Separator -----------------------------------------------------
521 TABLE_CATALOG NULL
522 TABLE_SCHEMA mysql
523 TABLE_NAME user
524 TABLE_TYPE BASE TABLE
525 ENGINE MyISAM
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 NULL
535 CREATE_TIME #CRT#
536 UPDATE_TIME #UT#
537 CHECK_TIME #CT#
538 TABLE_COLLATION utf8_bin
539 CHECKSUM NULL
540 CREATE_OPTIONS #CO#
541 TABLE_COMMENT #TC#
542 user_comment Users and global privileges
543 Separator -----------------------------------------------------
544 DROP USER testuser1@localhost;
545 CREATE USER testuser1@localhost;
546 GRANT SELECT ON test1.* TO testuser1@localhost;
547 # Establish connection testuser1 (user=testuser1)
548 SELECT *,
549 LEFT( table_comment,
550 IF(INSTR(table_comment,'InnoDB free') = 0
551 AND INSTR(table_comment,'number_of_replicas') = 0,
552 LENGTH(table_comment),
553 INSTR(table_comment,'InnoDB free')
554 + INSTR(table_comment,'number_of_replicas') - 1))
555 AS "user_comment",
556 '-----------------------------------------------------' AS "Separator"
557 FROM information_schema.tables
558 WHERE table_schema = 'mysql'
559 ORDER BY table_schema,table_name;
560 TABLE_CATALOG NULL
561 TABLE_SCHEMA mysql
562 TABLE_NAME columns_priv
563 TABLE_TYPE BASE TABLE
564 ENGINE MyISAM
565 VERSION 10
566 ROW_FORMAT Fixed
567 TABLE_ROWS #TBLR#
568 AVG_ROW_LENGTH #ARL#
569 DATA_LENGTH #DL#
570 MAX_DATA_LENGTH #MDL#
571 INDEX_LENGTH #IL#
572 DATA_FREE #DF#
573 AUTO_INCREMENT NULL
574 CREATE_TIME #CRT#
575 UPDATE_TIME #UT#
576 CHECK_TIME #CT#
577 TABLE_COLLATION utf8_bin
578 CHECKSUM NULL
579 CREATE_OPTIONS #CO#
580 TABLE_COMMENT #TC#
581 user_comment Column privileges
582 Separator -----------------------------------------------------
583 TABLE_CATALOG NULL
584 TABLE_SCHEMA mysql
585 TABLE_NAME db
586 TABLE_TYPE BASE TABLE
587 ENGINE MyISAM
588 VERSION 10
589 ROW_FORMAT Fixed
590 TABLE_ROWS #TBLR#
591 AVG_ROW_LENGTH #ARL#
592 DATA_LENGTH #DL#
593 MAX_DATA_LENGTH #MDL#
594 INDEX_LENGTH #IL#
595 DATA_FREE #DF#
596 AUTO_INCREMENT NULL
597 CREATE_TIME #CRT#
598 UPDATE_TIME #UT#
599 CHECK_TIME #CT#
600 TABLE_COLLATION utf8_bin
601 CHECKSUM NULL
602 CREATE_OPTIONS #CO#
603 TABLE_COMMENT #TC#
604 user_comment Database privileges
605 Separator -----------------------------------------------------
606 TABLE_CATALOG NULL
607 TABLE_SCHEMA mysql
608 TABLE_NAME event
609 TABLE_TYPE BASE TABLE
610 ENGINE MyISAM
611 VERSION 10
612 ROW_FORMAT Dynamic
613 TABLE_ROWS #TBLR#
614 AVG_ROW_LENGTH #ARL#
615 DATA_LENGTH #DL#
616 MAX_DATA_LENGTH #MDL#
617 INDEX_LENGTH #IL#
618 DATA_FREE #DF#
619 AUTO_INCREMENT NULL
620 CREATE_TIME #CRT#
621 UPDATE_TIME #UT#
622 CHECK_TIME #CT#
623 TABLE_COLLATION utf8_general_ci
624 CHECKSUM NULL
625 CREATE_OPTIONS #CO#
626 TABLE_COMMENT #TC#
627 user_comment Events
628 Separator -----------------------------------------------------
629 TABLE_CATALOG NULL
630 TABLE_SCHEMA mysql
631 TABLE_NAME func
632 TABLE_TYPE BASE TABLE
633 ENGINE MyISAM
634 VERSION 10
635 ROW_FORMAT Fixed
636 TABLE_ROWS #TBLR#
637 AVG_ROW_LENGTH #ARL#
638 DATA_LENGTH #DL#
639 MAX_DATA_LENGTH #MDL#
640 INDEX_LENGTH #IL#
641 DATA_FREE #DF#
642 AUTO_INCREMENT NULL
643 CREATE_TIME #CRT#
644 UPDATE_TIME #UT#
645 CHECK_TIME #CT#
646 TABLE_COLLATION utf8_bin
647 CHECKSUM NULL
648 CREATE_OPTIONS #CO#
649 TABLE_COMMENT #TC#
650 user_comment User defined functions
651 Separator -----------------------------------------------------
652 TABLE_CATALOG NULL
653 TABLE_SCHEMA mysql
654 TABLE_NAME general_log
655 TABLE_TYPE BASE TABLE
656 ENGINE CSV
657 VERSION 10
658 ROW_FORMAT Dynamic
659 TABLE_ROWS #TBLR#
660 AVG_ROW_LENGTH #ARL#
661 DATA_LENGTH #DL#
662 MAX_DATA_LENGTH #MDL#
663 INDEX_LENGTH #IL#
664 DATA_FREE #DF#
665 AUTO_INCREMENT NULL
666 CREATE_TIME #CRT#
667 UPDATE_TIME #UT#
668 CHECK_TIME #CT#
669 TABLE_COLLATION utf8_general_ci
670 CHECKSUM NULL
671 CREATE_OPTIONS #CO#
672 TABLE_COMMENT #TC#
673 user_comment General log
674 Separator -----------------------------------------------------
675 TABLE_CATALOG NULL
676 TABLE_SCHEMA mysql
677 TABLE_NAME help_category
678 TABLE_TYPE BASE TABLE
679 ENGINE MyISAM
680 VERSION 10
681 ROW_FORMAT Dynamic
682 TABLE_ROWS #TBLR#
683 AVG_ROW_LENGTH #ARL#
684 DATA_LENGTH #DL#
685 MAX_DATA_LENGTH #MDL#
686 INDEX_LENGTH #IL#
687 DATA_FREE #DF#
688 AUTO_INCREMENT NULL
689 CREATE_TIME #CRT#
690 UPDATE_TIME #UT#
691 CHECK_TIME #CT#
692 TABLE_COLLATION utf8_general_ci
693 CHECKSUM NULL
694 CREATE_OPTIONS #CO#
695 TABLE_COMMENT #TC#
696 user_comment help categories
697 Separator -----------------------------------------------------
698 TABLE_CATALOG NULL
699 TABLE_SCHEMA mysql
700 TABLE_NAME help_keyword
701 TABLE_TYPE BASE TABLE
702 ENGINE MyISAM
703 VERSION 10
704 ROW_FORMAT Fixed
705 TABLE_ROWS #TBLR#
706 AVG_ROW_LENGTH #ARL#
707 DATA_LENGTH #DL#
708 MAX_DATA_LENGTH #MDL#
709 INDEX_LENGTH #IL#
710 DATA_FREE #DF#
711 AUTO_INCREMENT NULL
712 CREATE_TIME #CRT#
713 UPDATE_TIME #UT#
714 CHECK_TIME #CT#
715 TABLE_COLLATION utf8_general_ci
716 CHECKSUM NULL
717 CREATE_OPTIONS #CO#
718 TABLE_COMMENT #TC#
719 user_comment help keywords
720 Separator -----------------------------------------------------
721 TABLE_CATALOG NULL
722 TABLE_SCHEMA mysql
723 TABLE_NAME help_relation
724 TABLE_TYPE BASE TABLE
725 ENGINE MyISAM
726 VERSION 10
727 ROW_FORMAT Fixed
728 TABLE_ROWS #TBLR#
729 AVG_ROW_LENGTH #ARL#
730 DATA_LENGTH #DL#
731 MAX_DATA_LENGTH #MDL#
732 INDEX_LENGTH #IL#
733 DATA_FREE #DF#
734 AUTO_INCREMENT NULL
735 CREATE_TIME #CRT#
736 UPDATE_TIME #UT#
737 CHECK_TIME #CT#
738 TABLE_COLLATION utf8_general_ci
739 CHECKSUM NULL
740 CREATE_OPTIONS #CO#
741 TABLE_COMMENT #TC#
742 user_comment keyword-topic relation
743 Separator -----------------------------------------------------
744 TABLE_CATALOG NULL
745 TABLE_SCHEMA mysql
746 TABLE_NAME help_topic
747 TABLE_TYPE BASE TABLE
748 ENGINE MyISAM
749 VERSION 10
750 ROW_FORMAT Dynamic
751 TABLE_ROWS #TBLR#
752 AVG_ROW_LENGTH #ARL#
753 DATA_LENGTH #DL#
754 MAX_DATA_LENGTH #MDL#
755 INDEX_LENGTH #IL#
756 DATA_FREE #DF#
757 AUTO_INCREMENT NULL
758 CREATE_TIME #CRT#
759 UPDATE_TIME #UT#
760 CHECK_TIME #CT#
761 TABLE_COLLATION utf8_general_ci
762 CHECKSUM NULL
763 CREATE_OPTIONS #CO#
764 TABLE_COMMENT #TC#
765 user_comment help topics
766 Separator -----------------------------------------------------
767 TABLE_CATALOG NULL
768 TABLE_SCHEMA mysql
769 TABLE_NAME host
770 TABLE_TYPE BASE TABLE
771 ENGINE MyISAM
772 VERSION 10
773 ROW_FORMAT Fixed
774 TABLE_ROWS #TBLR#
775 AVG_ROW_LENGTH #ARL#
776 DATA_LENGTH #DL#
777 MAX_DATA_LENGTH #MDL#
778 INDEX_LENGTH #IL#
779 DATA_FREE #DF#
780 AUTO_INCREMENT NULL
781 CREATE_TIME #CRT#
782 UPDATE_TIME #UT#
783 CHECK_TIME #CT#
784 TABLE_COLLATION utf8_bin
785 CHECKSUM NULL
786 CREATE_OPTIONS #CO#
787 TABLE_COMMENT #TC#
788 user_comment Host privileges; Merged with database privileges
789 Separator -----------------------------------------------------
790 TABLE_CATALOG NULL
791 TABLE_SCHEMA mysql
792 TABLE_NAME ndb_binlog_index
793 TABLE_TYPE BASE TABLE
794 ENGINE MyISAM
795 VERSION 10
796 ROW_FORMAT Dynamic
797 TABLE_ROWS #TBLR#
798 AVG_ROW_LENGTH #ARL#
799 DATA_LENGTH #DL#
800 MAX_DATA_LENGTH #MDL#
801 INDEX_LENGTH #IL#
802 DATA_FREE #DF#
803 AUTO_INCREMENT NULL
804 CREATE_TIME #CRT#
805 UPDATE_TIME #UT#
806 CHECK_TIME #CT#
807 TABLE_COLLATION latin1_swedish_ci
808 CHECKSUM NULL
809 CREATE_OPTIONS #CO#
810 TABLE_COMMENT #TC#
811 user_comment
812 Separator -----------------------------------------------------
813 TABLE_CATALOG NULL
814 TABLE_SCHEMA mysql
815 TABLE_NAME plugin
816 TABLE_TYPE BASE TABLE
817 ENGINE MyISAM
818 VERSION 10
819 ROW_FORMAT Fixed
820 TABLE_ROWS #TBLR#
821 AVG_ROW_LENGTH #ARL#
822 DATA_LENGTH #DL#
823 MAX_DATA_LENGTH #MDL#
824 INDEX_LENGTH #IL#
825 DATA_FREE #DF#
826 AUTO_INCREMENT NULL
827 CREATE_TIME #CRT#
828 UPDATE_TIME #UT#
829 CHECK_TIME #CT#
830 TABLE_COLLATION utf8_bin
831 CHECKSUM NULL
832 CREATE_OPTIONS #CO#
833 TABLE_COMMENT #TC#
834 user_comment MySQL plugins
835 Separator -----------------------------------------------------
836 TABLE_CATALOG NULL
837 TABLE_SCHEMA mysql
838 TABLE_NAME proc
839 TABLE_TYPE BASE TABLE
840 ENGINE MyISAM
841 VERSION 10
842 ROW_FORMAT Dynamic
843 TABLE_ROWS #TBLR#
844 AVG_ROW_LENGTH #ARL#
845 DATA_LENGTH #DL#
846 MAX_DATA_LENGTH #MDL#
847 INDEX_LENGTH #IL#
848 DATA_FREE #DF#
849 AUTO_INCREMENT NULL
850 CREATE_TIME #CRT#
851 UPDATE_TIME #UT#
852 CHECK_TIME #CT#
853 TABLE_COLLATION utf8_general_ci
854 CHECKSUM NULL
855 CREATE_OPTIONS #CO#
856 TABLE_COMMENT #TC#
857 user_comment Stored Procedures
858 Separator -----------------------------------------------------
859 TABLE_CATALOG NULL
860 TABLE_SCHEMA mysql
861 TABLE_NAME procs_priv
862 TABLE_TYPE BASE TABLE
863 ENGINE MyISAM
864 VERSION 10
865 ROW_FORMAT Fixed
866 TABLE_ROWS #TBLR#
867 AVG_ROW_LENGTH #ARL#
868 DATA_LENGTH #DL#
869 MAX_DATA_LENGTH #MDL#
870 INDEX_LENGTH #IL#
871 DATA_FREE #DF#
872 AUTO_INCREMENT NULL
873 CREATE_TIME #CRT#
874 UPDATE_TIME #UT#
875 CHECK_TIME #CT#
876 TABLE_COLLATION utf8_bin
877 CHECKSUM NULL
878 CREATE_OPTIONS #CO#
879 TABLE_COMMENT #TC#
880 user_comment Procedure privileges
881 Separator -----------------------------------------------------
882 TABLE_CATALOG NULL
883 TABLE_SCHEMA mysql
884 TABLE_NAME servers
885 TABLE_TYPE BASE TABLE
886 ENGINE MyISAM
887 VERSION 10
888 ROW_FORMAT Fixed
889 TABLE_ROWS #TBLR#
890 AVG_ROW_LENGTH #ARL#
891 DATA_LENGTH #DL#
892 MAX_DATA_LENGTH #MDL#
893 INDEX_LENGTH #IL#
894 DATA_FREE #DF#
895 AUTO_INCREMENT NULL
896 CREATE_TIME #CRT#
897 UPDATE_TIME #UT#
898 CHECK_TIME #CT#
899 TABLE_COLLATION utf8_general_ci
900 CHECKSUM NULL
901 CREATE_OPTIONS #CO#
902 TABLE_COMMENT #TC#
903 user_comment MySQL Foreign Servers table
904 Separator -----------------------------------------------------
905 TABLE_CATALOG NULL
906 TABLE_SCHEMA mysql
907 TABLE_NAME slow_log
908 TABLE_TYPE BASE TABLE
909 ENGINE CSV
910 VERSION 10
911 ROW_FORMAT Dynamic
912 TABLE_ROWS #TBLR#
913 AVG_ROW_LENGTH #ARL#
914 DATA_LENGTH #DL#
915 MAX_DATA_LENGTH #MDL#
916 INDEX_LENGTH #IL#
917 DATA_FREE #DF#
918 AUTO_INCREMENT NULL
919 CREATE_TIME #CRT#
920 UPDATE_TIME #UT#
921 CHECK_TIME #CT#
922 TABLE_COLLATION utf8_general_ci
923 CHECKSUM NULL
924 CREATE_OPTIONS #CO#
925 TABLE_COMMENT #TC#
926 user_comment Slow log
927 Separator -----------------------------------------------------
928 TABLE_CATALOG NULL
929 TABLE_SCHEMA mysql
930 TABLE_NAME tables_priv
931 TABLE_TYPE BASE TABLE
932 ENGINE MyISAM
933 VERSION 10
934 ROW_FORMAT Fixed
935 TABLE_ROWS #TBLR#
936 AVG_ROW_LENGTH #ARL#
937 DATA_LENGTH #DL#
938 MAX_DATA_LENGTH #MDL#
939 INDEX_LENGTH #IL#
940 DATA_FREE #DF#
941 AUTO_INCREMENT NULL
942 CREATE_TIME #CRT#
943 UPDATE_TIME #UT#
944 CHECK_TIME #CT#
945 TABLE_COLLATION utf8_bin
946 CHECKSUM NULL
947 CREATE_OPTIONS #CO#
948 TABLE_COMMENT #TC#
949 user_comment Table privileges
950 Separator -----------------------------------------------------
951 TABLE_CATALOG NULL
952 TABLE_SCHEMA mysql
953 TABLE_NAME time_zone
954 TABLE_TYPE BASE TABLE
955 ENGINE MyISAM
956 VERSION 10
957 ROW_FORMAT Fixed
958 TABLE_ROWS #TBLR#
959 AVG_ROW_LENGTH #ARL#
960 DATA_LENGTH #DL#
961 MAX_DATA_LENGTH #MDL#
962 INDEX_LENGTH #IL#
963 DATA_FREE #DF#
964 AUTO_INCREMENT 6
965 CREATE_TIME #CRT#
966 UPDATE_TIME #UT#
967 CHECK_TIME #CT#
968 TABLE_COLLATION utf8_general_ci
969 CHECKSUM NULL
970 CREATE_OPTIONS #CO#
971 TABLE_COMMENT #TC#
972 user_comment Time zones
973 Separator -----------------------------------------------------
974 TABLE_CATALOG NULL
975 TABLE_SCHEMA mysql
976 TABLE_NAME time_zone_leap_second
977 TABLE_TYPE BASE TABLE
978 ENGINE MyISAM
979 VERSION 10
980 ROW_FORMAT Fixed
981 TABLE_ROWS #TBLR#
982 AVG_ROW_LENGTH #ARL#
983 DATA_LENGTH #DL#
984 MAX_DATA_LENGTH #MDL#
985 INDEX_LENGTH #IL#
986 DATA_FREE #DF#
987 AUTO_INCREMENT NULL
988 CREATE_TIME #CRT#
989 UPDATE_TIME #UT#
990 CHECK_TIME #CT#
991 TABLE_COLLATION utf8_general_ci
992 CHECKSUM NULL
993 CREATE_OPTIONS #CO#
994 TABLE_COMMENT #TC#
995 user_comment Leap seconds information for time zones
996 Separator -----------------------------------------------------
997 TABLE_CATALOG NULL
998 TABLE_SCHEMA mysql
999 TABLE_NAME time_zone_name
1000 TABLE_TYPE BASE TABLE
1001 ENGINE MyISAM
1002 VERSION 10
1003 ROW_FORMAT Fixed
1004 TABLE_ROWS #TBLR#
1005 AVG_ROW_LENGTH #ARL#
1006 DATA_LENGTH #DL#
1007 MAX_DATA_LENGTH #MDL#
1008 INDEX_LENGTH #IL#
1009 DATA_FREE #DF#
1010 AUTO_INCREMENT NULL
1011 CREATE_TIME #CRT#
1012 UPDATE_TIME #UT#
1013 CHECK_TIME #CT#
1014 TABLE_COLLATION utf8_general_ci
1015 CHECKSUM NULL
1016 CREATE_OPTIONS #CO#
1017 TABLE_COMMENT #TC#
1018 user_comment Time zone names
1019 Separator -----------------------------------------------------
1020 TABLE_CATALOG NULL
1021 TABLE_SCHEMA mysql
1022 TABLE_NAME time_zone_transition
1023 TABLE_TYPE BASE TABLE
1024 ENGINE MyISAM
1025 VERSION 10
1026 ROW_FORMAT Fixed
1027 TABLE_ROWS #TBLR#
1028 AVG_ROW_LENGTH #ARL#
1029 DATA_LENGTH #DL#
1030 MAX_DATA_LENGTH #MDL#
1031 INDEX_LENGTH #IL#
1032 DATA_FREE #DF#
1033 AUTO_INCREMENT NULL
1034 CREATE_TIME #CRT#
1035 UPDATE_TIME #UT#
1036 CHECK_TIME #CT#
1037 TABLE_COLLATION utf8_general_ci
1038 CHECKSUM NULL
1039 CREATE_OPTIONS #CO#
1040 TABLE_COMMENT #TC#
1041 user_comment Time zone transitions
1042 Separator -----------------------------------------------------
1043 TABLE_CATALOG NULL
1044 TABLE_SCHEMA mysql
1045 TABLE_NAME time_zone_transition_type
1046 TABLE_TYPE BASE TABLE
1047 ENGINE MyISAM
1048 VERSION 10
1049 ROW_FORMAT Fixed
1050 TABLE_ROWS #TBLR#
1051 AVG_ROW_LENGTH #ARL#
1052 DATA_LENGTH #DL#
1053 MAX_DATA_LENGTH #MDL#
1054 INDEX_LENGTH #IL#
1055 DATA_FREE #DF#
1056 AUTO_INCREMENT NULL
1057 CREATE_TIME #CRT#
1058 UPDATE_TIME #UT#
1059 CHECK_TIME #CT#
1060 TABLE_COLLATION utf8_general_ci
1061 CHECKSUM NULL
1062 CREATE_OPTIONS #CO#
1063 TABLE_COMMENT #TC#
1064 user_comment Time zone transition types
1065 Separator -----------------------------------------------------
1066 TABLE_CATALOG NULL
1067 TABLE_SCHEMA mysql
1068 TABLE_NAME user
1069 TABLE_TYPE BASE TABLE
1070 ENGINE MyISAM
1071 VERSION 10
1072 ROW_FORMAT Dynamic
1073 TABLE_ROWS #TBLR#
1074 AVG_ROW_LENGTH #ARL#
1075 DATA_LENGTH #DL#
1076 MAX_DATA_LENGTH #MDL#
1077 INDEX_LENGTH #IL#
1078 DATA_FREE #DF#
1079 AUTO_INCREMENT NULL
1080 CREATE_TIME #CRT#
1081 UPDATE_TIME #UT#
1082 CHECK_TIME #CT#
1083 TABLE_COLLATION utf8_bin
1084 CHECKSUM NULL
1085 CREATE_OPTIONS #CO#
1086 TABLE_COMMENT #TC#
1087 user_comment Users and global privileges
1088 Separator -----------------------------------------------------
1089 # Switch to connection default and close connection testuser1
1090 DROP USER testuser1@localhost;
1091 DROP DATABASE test1;