← Back to branch summary

~linuxjedi/drizzle/trunk-bug-667053

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/r/is_tables_is.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/funcs_1/r/is_tables_is.result
 
1
DROP DATABASE IF EXISTS db_datadict;
 
2
CREATE DATABASE db_datadict;
 
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 = 'information_schema'
 
14
AND table_name <> 'profiling' AND table_name not LIKE 'falcon_%'
 
15
ORDER BY table_schema,table_name;
 
16
TABLE_CATALOG   NULL
 
17
TABLE_SCHEMA    information_schema
 
18
TABLE_NAME      CHARACTER_SETS
 
19
TABLE_TYPE      SYSTEM VIEW
 
20
ENGINE  MEMORY
 
21
VERSION 10
 
22
ROW_FORMAT      Fixed
 
23
TABLE_ROWS      #TBLR#
 
24
AVG_ROW_LENGTH  #ARL#
 
25
DATA_LENGTH     #DL#
 
26
MAX_DATA_LENGTH #MDL#
 
27
INDEX_LENGTH    #IL#
 
28
DATA_FREE       #DF#
 
29
AUTO_INCREMENT  NULL
 
30
CREATE_TIME     #CRT#
 
31
UPDATE_TIME     #UT#
 
32
CHECK_TIME      #CT#
 
33
TABLE_COLLATION utf8_general_ci
 
34
CHECKSUM        NULL
 
35
CREATE_OPTIONS  #CO#
 
36
TABLE_COMMENT   #TC#
 
37
user_comment    
 
38
Separator       -----------------------------------------------------
 
39
TABLE_CATALOG   NULL
 
40
TABLE_SCHEMA    information_schema
 
41
TABLE_NAME      COLLATIONS
 
42
TABLE_TYPE      SYSTEM VIEW
 
43
ENGINE  MEMORY
 
44
VERSION 10
 
45
ROW_FORMAT      Fixed
 
46
TABLE_ROWS      #TBLR#
 
47
AVG_ROW_LENGTH  #ARL#
 
48
DATA_LENGTH     #DL#
 
49
MAX_DATA_LENGTH #MDL#
 
50
INDEX_LENGTH    #IL#
 
51
DATA_FREE       #DF#
 
52
AUTO_INCREMENT  NULL
 
53
CREATE_TIME     #CRT#
 
54
UPDATE_TIME     #UT#
 
55
CHECK_TIME      #CT#
 
56
TABLE_COLLATION utf8_general_ci
 
57
CHECKSUM        NULL
 
58
CREATE_OPTIONS  #CO#
 
59
TABLE_COMMENT   #TC#
 
60
user_comment    
 
61
Separator       -----------------------------------------------------
 
62
TABLE_CATALOG   NULL
 
63
TABLE_SCHEMA    information_schema
 
64
TABLE_NAME      COLLATION_CHARACTER_SET_APPLICABILITY
 
65
TABLE_TYPE      SYSTEM VIEW
 
66
ENGINE  MEMORY
 
67
VERSION 10
 
68
ROW_FORMAT      Fixed
 
69
TABLE_ROWS      #TBLR#
 
70
AVG_ROW_LENGTH  #ARL#
 
71
DATA_LENGTH     #DL#
 
72
MAX_DATA_LENGTH #MDL#
 
73
INDEX_LENGTH    #IL#
 
74
DATA_FREE       #DF#
 
75
AUTO_INCREMENT  NULL
 
76
CREATE_TIME     #CRT#
 
77
UPDATE_TIME     #UT#
 
78
CHECK_TIME      #CT#
 
79
TABLE_COLLATION utf8_general_ci
 
80
CHECKSUM        NULL
 
81
CREATE_OPTIONS  #CO#
 
82
TABLE_COMMENT   #TC#
 
83
user_comment    
 
84
Separator       -----------------------------------------------------
 
85
TABLE_CATALOG   NULL
 
86
TABLE_SCHEMA    information_schema
 
87
TABLE_NAME      COLUMNS
 
88
TABLE_TYPE      SYSTEM VIEW
 
89
ENGINE  MyISAM
 
90
VERSION 10
 
91
ROW_FORMAT      Dynamic
 
92
TABLE_ROWS      #TBLR#
 
93
AVG_ROW_LENGTH  #ARL#
 
94
DATA_LENGTH     #DL#
 
95
MAX_DATA_LENGTH #MDL#
 
96
INDEX_LENGTH    #IL#
 
97
DATA_FREE       #DF#
 
98
AUTO_INCREMENT  NULL
 
99
CREATE_TIME     #CRT#
 
100
UPDATE_TIME     #UT#
 
101
CHECK_TIME      #CT#
 
102
TABLE_COLLATION utf8_general_ci
 
103
CHECKSUM        NULL
 
104
CREATE_OPTIONS  #CO#
 
105
TABLE_COMMENT   #TC#
 
106
user_comment    
 
107
Separator       -----------------------------------------------------
 
108
TABLE_CATALOG   NULL
 
109
TABLE_SCHEMA    information_schema
 
110
TABLE_NAME      COLUMN_PRIVILEGES
 
111
TABLE_TYPE      SYSTEM VIEW
 
112
ENGINE  MEMORY
 
113
VERSION 10
 
114
ROW_FORMAT      Fixed
 
115
TABLE_ROWS      #TBLR#
 
116
AVG_ROW_LENGTH  #ARL#
 
117
DATA_LENGTH     #DL#
 
118
MAX_DATA_LENGTH #MDL#
 
119
INDEX_LENGTH    #IL#
 
120
DATA_FREE       #DF#
 
121
AUTO_INCREMENT  NULL
 
122
CREATE_TIME     #CRT#
 
123
UPDATE_TIME     #UT#
 
124
CHECK_TIME      #CT#
 
125
TABLE_COLLATION utf8_general_ci
 
126
CHECKSUM        NULL
 
127
CREATE_OPTIONS  #CO#
 
128
TABLE_COMMENT   #TC#
 
129
user_comment    
 
130
Separator       -----------------------------------------------------
 
131
TABLE_CATALOG   NULL
 
132
TABLE_SCHEMA    information_schema
 
133
TABLE_NAME      ENGINES
 
134
TABLE_TYPE      SYSTEM VIEW
 
135
ENGINE  MEMORY
 
136
VERSION 10
 
137
ROW_FORMAT      Fixed
 
138
TABLE_ROWS      #TBLR#
 
139
AVG_ROW_LENGTH  #ARL#
 
140
DATA_LENGTH     #DL#
 
141
MAX_DATA_LENGTH #MDL#
 
142
INDEX_LENGTH    #IL#
 
143
DATA_FREE       #DF#
 
144
AUTO_INCREMENT  NULL
 
145
CREATE_TIME     #CRT#
 
146
UPDATE_TIME     #UT#
 
147
CHECK_TIME      #CT#
 
148
TABLE_COLLATION utf8_general_ci
 
149
CHECKSUM        NULL
 
150
CREATE_OPTIONS  #CO#
 
151
TABLE_COMMENT   #TC#
 
152
user_comment    
 
153
Separator       -----------------------------------------------------
 
154
TABLE_CATALOG   NULL
 
155
TABLE_SCHEMA    information_schema
 
156
TABLE_NAME      EVENTS
 
157
TABLE_TYPE      SYSTEM VIEW
 
158
ENGINE  MyISAM
 
159
VERSION 10
 
160
ROW_FORMAT      Dynamic
 
161
TABLE_ROWS      #TBLR#
 
162
AVG_ROW_LENGTH  #ARL#
 
163
DATA_LENGTH     #DL#
 
164
MAX_DATA_LENGTH #MDL#
 
165
INDEX_LENGTH    #IL#
 
166
DATA_FREE       #DF#
 
167
AUTO_INCREMENT  NULL
 
168
CREATE_TIME     #CRT#
 
169
UPDATE_TIME     #UT#
 
170
CHECK_TIME      #CT#
 
171
TABLE_COLLATION utf8_general_ci
 
172
CHECKSUM        NULL
 
173
CREATE_OPTIONS  #CO#
 
174
TABLE_COMMENT   #TC#
 
175
user_comment    
 
176
Separator       -----------------------------------------------------
 
177
TABLE_CATALOG   NULL
 
178
TABLE_SCHEMA    information_schema
 
179
TABLE_NAME      FILES
 
180
TABLE_TYPE      SYSTEM VIEW
 
181
ENGINE  MEMORY
 
182
VERSION 10
 
183
ROW_FORMAT      Fixed
 
184
TABLE_ROWS      #TBLR#
 
185
AVG_ROW_LENGTH  #ARL#
 
186
DATA_LENGTH     #DL#
 
187
MAX_DATA_LENGTH #MDL#
 
188
INDEX_LENGTH    #IL#
 
189
DATA_FREE       #DF#
 
190
AUTO_INCREMENT  NULL
 
191
CREATE_TIME     #CRT#
 
192
UPDATE_TIME     #UT#
 
193
CHECK_TIME      #CT#
 
194
TABLE_COLLATION utf8_general_ci
 
195
CHECKSUM        NULL
 
196
CREATE_OPTIONS  #CO#
 
197
TABLE_COMMENT   #TC#
 
198
user_comment    
 
199
Separator       -----------------------------------------------------
 
200
TABLE_CATALOG   NULL
 
201
TABLE_SCHEMA    information_schema
 
202
TABLE_NAME      GLOBAL_STATUS
 
203
TABLE_TYPE      SYSTEM VIEW
 
204
ENGINE  MEMORY
 
205
VERSION 10
 
206
ROW_FORMAT      Fixed
 
207
TABLE_ROWS      #TBLR#
 
208
AVG_ROW_LENGTH  #ARL#
 
209
DATA_LENGTH     #DL#
 
210
MAX_DATA_LENGTH #MDL#
 
211
INDEX_LENGTH    #IL#
 
212
DATA_FREE       #DF#
 
213
AUTO_INCREMENT  NULL
 
214
CREATE_TIME     #CRT#
 
215
UPDATE_TIME     #UT#
 
216
CHECK_TIME      #CT#
 
217
TABLE_COLLATION utf8_general_ci
 
218
CHECKSUM        NULL
 
219
CREATE_OPTIONS  #CO#
 
220
TABLE_COMMENT   #TC#
 
221
user_comment    
 
222
Separator       -----------------------------------------------------
 
223
TABLE_CATALOG   NULL
 
224
TABLE_SCHEMA    information_schema
 
225
TABLE_NAME      GLOBAL_VARIABLES
 
226
TABLE_TYPE      SYSTEM VIEW
 
227
ENGINE  MEMORY
 
228
VERSION 10
 
229
ROW_FORMAT      Fixed
 
230
TABLE_ROWS      #TBLR#
 
231
AVG_ROW_LENGTH  #ARL#
 
232
DATA_LENGTH     #DL#
 
233
MAX_DATA_LENGTH #MDL#
 
234
INDEX_LENGTH    #IL#
 
235
DATA_FREE       #DF#
 
236
AUTO_INCREMENT  NULL
 
237
CREATE_TIME     #CRT#
 
238
UPDATE_TIME     #UT#
 
239
CHECK_TIME      #CT#
 
240
TABLE_COLLATION utf8_general_ci
 
241
CHECKSUM        NULL
 
242
CREATE_OPTIONS  #CO#
 
243
TABLE_COMMENT   #TC#
 
244
user_comment    
 
245
Separator       -----------------------------------------------------
 
246
TABLE_CATALOG   NULL
 
247
TABLE_SCHEMA    information_schema
 
248
TABLE_NAME      KEY_COLUMN_USAGE
 
249
TABLE_TYPE      SYSTEM VIEW
 
250
ENGINE  MEMORY
 
251
VERSION 10
 
252
ROW_FORMAT      Fixed
 
253
TABLE_ROWS      #TBLR#
 
254
AVG_ROW_LENGTH  #ARL#
 
255
DATA_LENGTH     #DL#
 
256
MAX_DATA_LENGTH #MDL#
 
257
INDEX_LENGTH    #IL#
 
258
DATA_FREE       #DF#
 
259
AUTO_INCREMENT  NULL
 
260
CREATE_TIME     #CRT#
 
261
UPDATE_TIME     #UT#
 
262
CHECK_TIME      #CT#
 
263
TABLE_COLLATION utf8_general_ci
 
264
CHECKSUM        NULL
 
265
CREATE_OPTIONS  #CO#
 
266
TABLE_COMMENT   #TC#
 
267
user_comment    
 
268
Separator       -----------------------------------------------------
 
269
TABLE_CATALOG   NULL
 
270
TABLE_SCHEMA    information_schema
 
271
TABLE_NAME      PARAMETERS
 
272
TABLE_TYPE      SYSTEM VIEW
 
273
ENGINE  MyISAM
 
274
VERSION 10
 
275
ROW_FORMAT      Dynamic
 
276
TABLE_ROWS      #TBLR#
 
277
AVG_ROW_LENGTH  #ARL#
 
278
DATA_LENGTH     #DL#
 
279
MAX_DATA_LENGTH #MDL#
 
280
INDEX_LENGTH    #IL#
 
281
DATA_FREE       #DF#
 
282
AUTO_INCREMENT  NULL
 
283
CREATE_TIME     #CRT#
 
284
UPDATE_TIME     #UT#
 
285
CHECK_TIME      #CT#
 
286
TABLE_COLLATION utf8_general_ci
 
287
CHECKSUM        NULL
 
288
CREATE_OPTIONS  #CO#
 
289
TABLE_COMMENT   #TC#
 
290
user_comment    
 
291
Separator       -----------------------------------------------------
 
292
TABLE_CATALOG   NULL
 
293
TABLE_SCHEMA    information_schema
 
294
TABLE_NAME      PARTITIONS
 
295
TABLE_TYPE      SYSTEM VIEW
 
296
ENGINE  MyISAM
 
297
VERSION 10
 
298
ROW_FORMAT      Dynamic
 
299
TABLE_ROWS      #TBLR#
 
300
AVG_ROW_LENGTH  #ARL#
 
301
DATA_LENGTH     #DL#
 
302
MAX_DATA_LENGTH #MDL#
 
303
INDEX_LENGTH    #IL#
 
304
DATA_FREE       #DF#
 
305
AUTO_INCREMENT  NULL
 
306
CREATE_TIME     #CRT#
 
307
UPDATE_TIME     #UT#
 
308
CHECK_TIME      #CT#
 
309
TABLE_COLLATION utf8_general_ci
 
310
CHECKSUM        NULL
 
311
CREATE_OPTIONS  #CO#
 
312
TABLE_COMMENT   #TC#
 
313
user_comment    
 
314
Separator       -----------------------------------------------------
 
315
TABLE_CATALOG   NULL
 
316
TABLE_SCHEMA    information_schema
 
317
TABLE_NAME      PLUGINS
 
318
TABLE_TYPE      SYSTEM VIEW
 
319
ENGINE  MyISAM
 
320
VERSION 10
 
321
ROW_FORMAT      Dynamic
 
322
TABLE_ROWS      #TBLR#
 
323
AVG_ROW_LENGTH  #ARL#
 
324
DATA_LENGTH     #DL#
 
325
MAX_DATA_LENGTH #MDL#
 
326
INDEX_LENGTH    #IL#
 
327
DATA_FREE       #DF#
 
328
AUTO_INCREMENT  NULL
 
329
CREATE_TIME     #CRT#
 
330
UPDATE_TIME     #UT#
 
331
CHECK_TIME      #CT#
 
332
TABLE_COLLATION utf8_general_ci
 
333
CHECKSUM        NULL
 
334
CREATE_OPTIONS  #CO#
 
335
TABLE_COMMENT   #TC#
 
336
user_comment    
 
337
Separator       -----------------------------------------------------
 
338
TABLE_CATALOG   NULL
 
339
TABLE_SCHEMA    information_schema
 
340
TABLE_NAME      PROCESSLIST
 
341
TABLE_TYPE      SYSTEM VIEW
 
342
ENGINE  MyISAM
 
343
VERSION 10
 
344
ROW_FORMAT      Dynamic
 
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 utf8_general_ci
 
356
CHECKSUM        NULL
 
357
CREATE_OPTIONS  #CO#
 
358
TABLE_COMMENT   #TC#
 
359
user_comment    
 
360
Separator       -----------------------------------------------------
 
361
TABLE_CATALOG   NULL
 
362
TABLE_SCHEMA    information_schema
 
363
TABLE_NAME      REFERENTIAL_CONSTRAINTS
 
364
TABLE_TYPE      SYSTEM VIEW
 
365
ENGINE  MEMORY
 
366
VERSION 10
 
367
ROW_FORMAT      Fixed
 
368
TABLE_ROWS      #TBLR#
 
369
AVG_ROW_LENGTH  #ARL#
 
370
DATA_LENGTH     #DL#
 
371
MAX_DATA_LENGTH #MDL#
 
372
INDEX_LENGTH    #IL#
 
373
DATA_FREE       #DF#
 
374
AUTO_INCREMENT  NULL
 
375
CREATE_TIME     #CRT#
 
376
UPDATE_TIME     #UT#
 
377
CHECK_TIME      #CT#
 
378
TABLE_COLLATION utf8_general_ci
 
379
CHECKSUM        NULL
 
380
CREATE_OPTIONS  #CO#
 
381
TABLE_COMMENT   #TC#
 
382
user_comment    
 
383
Separator       -----------------------------------------------------
 
384
TABLE_CATALOG   NULL
 
385
TABLE_SCHEMA    information_schema
 
386
TABLE_NAME      ROUTINES
 
387
TABLE_TYPE      SYSTEM VIEW
 
388
ENGINE  MyISAM
 
389
VERSION 10
 
390
ROW_FORMAT      Dynamic
 
391
TABLE_ROWS      #TBLR#
 
392
AVG_ROW_LENGTH  #ARL#
 
393
DATA_LENGTH     #DL#
 
394
MAX_DATA_LENGTH #MDL#
 
395
INDEX_LENGTH    #IL#
 
396
DATA_FREE       #DF#
 
397
AUTO_INCREMENT  NULL
 
398
CREATE_TIME     #CRT#
 
399
UPDATE_TIME     #UT#
 
400
CHECK_TIME      #CT#
 
401
TABLE_COLLATION utf8_general_ci
 
402
CHECKSUM        NULL
 
403
CREATE_OPTIONS  #CO#
 
404
TABLE_COMMENT   #TC#
 
405
user_comment    
 
406
Separator       -----------------------------------------------------
 
407
TABLE_CATALOG   NULL
 
408
TABLE_SCHEMA    information_schema
 
409
TABLE_NAME      SCHEMATA
 
410
TABLE_TYPE      SYSTEM VIEW
 
411
ENGINE  MEMORY
 
412
VERSION 10
 
413
ROW_FORMAT      Fixed
 
414
TABLE_ROWS      #TBLR#
 
415
AVG_ROW_LENGTH  #ARL#
 
416
DATA_LENGTH     #DL#
 
417
MAX_DATA_LENGTH #MDL#
 
418
INDEX_LENGTH    #IL#
 
419
DATA_FREE       #DF#
 
420
AUTO_INCREMENT  NULL
 
421
CREATE_TIME     #CRT#
 
422
UPDATE_TIME     #UT#
 
423
CHECK_TIME      #CT#
 
424
TABLE_COLLATION utf8_general_ci
 
425
CHECKSUM        NULL
 
426
CREATE_OPTIONS  #CO#
 
427
TABLE_COMMENT   #TC#
 
428
user_comment    
 
429
Separator       -----------------------------------------------------
 
430
TABLE_CATALOG   NULL
 
431
TABLE_SCHEMA    information_schema
 
432
TABLE_NAME      SCHEMA_PRIVILEGES
 
433
TABLE_TYPE      SYSTEM VIEW
 
434
ENGINE  MEMORY
 
435
VERSION 10
 
436
ROW_FORMAT      Fixed
 
437
TABLE_ROWS      #TBLR#
 
438
AVG_ROW_LENGTH  #ARL#
 
439
DATA_LENGTH     #DL#
 
440
MAX_DATA_LENGTH #MDL#
 
441
INDEX_LENGTH    #IL#
 
442
DATA_FREE       #DF#
 
443
AUTO_INCREMENT  NULL
 
444
CREATE_TIME     #CRT#
 
445
UPDATE_TIME     #UT#
 
446
CHECK_TIME      #CT#
 
447
TABLE_COLLATION utf8_general_ci
 
448
CHECKSUM        NULL
 
449
CREATE_OPTIONS  #CO#
 
450
TABLE_COMMENT   #TC#
 
451
user_comment    
 
452
Separator       -----------------------------------------------------
 
453
TABLE_CATALOG   NULL
 
454
TABLE_SCHEMA    information_schema
 
455
TABLE_NAME      SESSION_STATUS
 
456
TABLE_TYPE      SYSTEM VIEW
 
457
ENGINE  MEMORY
 
458
VERSION 10
 
459
ROW_FORMAT      Fixed
 
460
TABLE_ROWS      #TBLR#
 
461
AVG_ROW_LENGTH  #ARL#
 
462
DATA_LENGTH     #DL#
 
463
MAX_DATA_LENGTH #MDL#
 
464
INDEX_LENGTH    #IL#
 
465
DATA_FREE       #DF#
 
466
AUTO_INCREMENT  NULL
 
467
CREATE_TIME     #CRT#
 
468
UPDATE_TIME     #UT#
 
469
CHECK_TIME      #CT#
 
470
TABLE_COLLATION utf8_general_ci
 
471
CHECKSUM        NULL
 
472
CREATE_OPTIONS  #CO#
 
473
TABLE_COMMENT   #TC#
 
474
user_comment    
 
475
Separator       -----------------------------------------------------
 
476
TABLE_CATALOG   NULL
 
477
TABLE_SCHEMA    information_schema
 
478
TABLE_NAME      SESSION_VARIABLES
 
479
TABLE_TYPE      SYSTEM VIEW
 
480
ENGINE  MEMORY
 
481
VERSION 10
 
482
ROW_FORMAT      Fixed
 
483
TABLE_ROWS      #TBLR#
 
484
AVG_ROW_LENGTH  #ARL#
 
485
DATA_LENGTH     #DL#
 
486
MAX_DATA_LENGTH #MDL#
 
487
INDEX_LENGTH    #IL#
 
488
DATA_FREE       #DF#
 
489
AUTO_INCREMENT  NULL
 
490
CREATE_TIME     #CRT#
 
491
UPDATE_TIME     #UT#
 
492
CHECK_TIME      #CT#
 
493
TABLE_COLLATION utf8_general_ci
 
494
CHECKSUM        NULL
 
495
CREATE_OPTIONS  #CO#
 
496
TABLE_COMMENT   #TC#
 
497
user_comment    
 
498
Separator       -----------------------------------------------------
 
499
TABLE_CATALOG   NULL
 
500
TABLE_SCHEMA    information_schema
 
501
TABLE_NAME      STATISTICS
 
502
TABLE_TYPE      SYSTEM VIEW
 
503
ENGINE  MEMORY
 
504
VERSION 10
 
505
ROW_FORMAT      Fixed
 
506
TABLE_ROWS      #TBLR#
 
507
AVG_ROW_LENGTH  #ARL#
 
508
DATA_LENGTH     #DL#
 
509
MAX_DATA_LENGTH #MDL#
 
510
INDEX_LENGTH    #IL#
 
511
DATA_FREE       #DF#
 
512
AUTO_INCREMENT  NULL
 
513
CREATE_TIME     #CRT#
 
514
UPDATE_TIME     #UT#
 
515
CHECK_TIME      #CT#
 
516
TABLE_COLLATION utf8_general_ci
 
517
CHECKSUM        NULL
 
518
CREATE_OPTIONS  #CO#
 
519
TABLE_COMMENT   #TC#
 
520
user_comment    
 
521
Separator       -----------------------------------------------------
 
522
TABLE_CATALOG   NULL
 
523
TABLE_SCHEMA    information_schema
 
524
TABLE_NAME      TABLES
 
525
TABLE_TYPE      SYSTEM VIEW
 
526
ENGINE  MEMORY
 
527
VERSION 10
 
528
ROW_FORMAT      Fixed
 
529
TABLE_ROWS      #TBLR#
 
530
AVG_ROW_LENGTH  #ARL#
 
531
DATA_LENGTH     #DL#
 
532
MAX_DATA_LENGTH #MDL#
 
533
INDEX_LENGTH    #IL#
 
534
DATA_FREE       #DF#
 
535
AUTO_INCREMENT  NULL
 
536
CREATE_TIME     #CRT#
 
537
UPDATE_TIME     #UT#
 
538
CHECK_TIME      #CT#
 
539
TABLE_COLLATION utf8_general_ci
 
540
CHECKSUM        NULL
 
541
CREATE_OPTIONS  #CO#
 
542
TABLE_COMMENT   #TC#
 
543
user_comment    
 
544
Separator       -----------------------------------------------------
 
545
TABLE_CATALOG   NULL
 
546
TABLE_SCHEMA    information_schema
 
547
TABLE_NAME      TABLE_CONSTRAINTS
 
548
TABLE_TYPE      SYSTEM VIEW
 
549
ENGINE  MEMORY
 
550
VERSION 10
 
551
ROW_FORMAT      Fixed
 
552
TABLE_ROWS      #TBLR#
 
553
AVG_ROW_LENGTH  #ARL#
 
554
DATA_LENGTH     #DL#
 
555
MAX_DATA_LENGTH #MDL#
 
556
INDEX_LENGTH    #IL#
 
557
DATA_FREE       #DF#
 
558
AUTO_INCREMENT  NULL
 
559
CREATE_TIME     #CRT#
 
560
UPDATE_TIME     #UT#
 
561
CHECK_TIME      #CT#
 
562
TABLE_COLLATION utf8_general_ci
 
563
CHECKSUM        NULL
 
564
CREATE_OPTIONS  #CO#
 
565
TABLE_COMMENT   #TC#
 
566
user_comment    
 
567
Separator       -----------------------------------------------------
 
568
TABLE_CATALOG   NULL
 
569
TABLE_SCHEMA    information_schema
 
570
TABLE_NAME      TABLE_PRIVILEGES
 
571
TABLE_TYPE      SYSTEM VIEW
 
572
ENGINE  MEMORY
 
573
VERSION 10
 
574
ROW_FORMAT      Fixed
 
575
TABLE_ROWS      #TBLR#
 
576
AVG_ROW_LENGTH  #ARL#
 
577
DATA_LENGTH     #DL#
 
578
MAX_DATA_LENGTH #MDL#
 
579
INDEX_LENGTH    #IL#
 
580
DATA_FREE       #DF#
 
581
AUTO_INCREMENT  NULL
 
582
CREATE_TIME     #CRT#
 
583
UPDATE_TIME     #UT#
 
584
CHECK_TIME      #CT#
 
585
TABLE_COLLATION utf8_general_ci
 
586
CHECKSUM        NULL
 
587
CREATE_OPTIONS  #CO#
 
588
TABLE_COMMENT   #TC#
 
589
user_comment    
 
590
Separator       -----------------------------------------------------
 
591
TABLE_CATALOG   NULL
 
592
TABLE_SCHEMA    information_schema
 
593
TABLE_NAME      TRIGGERS
 
594
TABLE_TYPE      SYSTEM VIEW
 
595
ENGINE  MyISAM
 
596
VERSION 10
 
597
ROW_FORMAT      Dynamic
 
598
TABLE_ROWS      #TBLR#
 
599
AVG_ROW_LENGTH  #ARL#
 
600
DATA_LENGTH     #DL#
 
601
MAX_DATA_LENGTH #MDL#
 
602
INDEX_LENGTH    #IL#
 
603
DATA_FREE       #DF#
 
604
AUTO_INCREMENT  NULL
 
605
CREATE_TIME     #CRT#
 
606
UPDATE_TIME     #UT#
 
607
CHECK_TIME      #CT#
 
608
TABLE_COLLATION utf8_general_ci
 
609
CHECKSUM        NULL
 
610
CREATE_OPTIONS  #CO#
 
611
TABLE_COMMENT   #TC#
 
612
user_comment    
 
613
Separator       -----------------------------------------------------
 
614
TABLE_CATALOG   NULL
 
615
TABLE_SCHEMA    information_schema
 
616
TABLE_NAME      USER_PRIVILEGES
 
617
TABLE_TYPE      SYSTEM VIEW
 
618
ENGINE  MEMORY
 
619
VERSION 10
 
620
ROW_FORMAT      Fixed
 
621
TABLE_ROWS      #TBLR#
 
622
AVG_ROW_LENGTH  #ARL#
 
623
DATA_LENGTH     #DL#
 
624
MAX_DATA_LENGTH #MDL#
 
625
INDEX_LENGTH    #IL#
 
626
DATA_FREE       #DF#
 
627
AUTO_INCREMENT  NULL
 
628
CREATE_TIME     #CRT#
 
629
UPDATE_TIME     #UT#
 
630
CHECK_TIME      #CT#
 
631
TABLE_COLLATION utf8_general_ci
 
632
CHECKSUM        NULL
 
633
CREATE_OPTIONS  #CO#
 
634
TABLE_COMMENT   #TC#
 
635
user_comment    
 
636
Separator       -----------------------------------------------------
 
637
TABLE_CATALOG   NULL
 
638
TABLE_SCHEMA    information_schema
 
639
TABLE_NAME      VIEWS
 
640
TABLE_TYPE      SYSTEM VIEW
 
641
ENGINE  MyISAM
 
642
VERSION 10
 
643
ROW_FORMAT      Dynamic
 
644
TABLE_ROWS      #TBLR#
 
645
AVG_ROW_LENGTH  #ARL#
 
646
DATA_LENGTH     #DL#
 
647
MAX_DATA_LENGTH #MDL#
 
648
INDEX_LENGTH    #IL#
 
649
DATA_FREE       #DF#
 
650
AUTO_INCREMENT  NULL
 
651
CREATE_TIME     #CRT#
 
652
UPDATE_TIME     #UT#
 
653
CHECK_TIME      #CT#
 
654
TABLE_COLLATION utf8_general_ci
 
655
CHECKSUM        NULL
 
656
CREATE_OPTIONS  #CO#
 
657
TABLE_COMMENT   #TC#
 
658
user_comment    
 
659
Separator       -----------------------------------------------------
 
660
DROP   USER testuser1@localhost;
 
661
CREATE USER testuser1@localhost;
 
662
GRANT SELECT ON db_datadict.* TO testuser1@localhost;
 
663
# Establish connection testuser1 (user=testuser1)
 
664
SELECT *,
 
665
LEFT( table_comment,
 
666
IF(INSTR(table_comment,'InnoDB free') = 0
 
667
AND INSTR(table_comment,'number_of_replicas') = 0,
 
668
LENGTH(table_comment),
 
669
INSTR(table_comment,'InnoDB free')
 
670
+ INSTR(table_comment,'number_of_replicas') - 1))
 
671
AS "user_comment",
 
672
'-----------------------------------------------------' AS "Separator"
 
673
FROM information_schema.tables
 
674
WHERE table_schema = 'information_schema'
 
675
AND table_name <> 'profiling' AND table_name not LIKE 'falcon_%'
 
676
ORDER BY table_schema,table_name;
 
677
TABLE_CATALOG   NULL
 
678
TABLE_SCHEMA    information_schema
 
679
TABLE_NAME      CHARACTER_SETS
 
680
TABLE_TYPE      SYSTEM VIEW
 
681
ENGINE  MEMORY
 
682
VERSION 10
 
683
ROW_FORMAT      Fixed
 
684
TABLE_ROWS      #TBLR#
 
685
AVG_ROW_LENGTH  #ARL#
 
686
DATA_LENGTH     #DL#
 
687
MAX_DATA_LENGTH #MDL#
 
688
INDEX_LENGTH    #IL#
 
689
DATA_FREE       #DF#
 
690
AUTO_INCREMENT  NULL
 
691
CREATE_TIME     #CRT#
 
692
UPDATE_TIME     #UT#
 
693
CHECK_TIME      #CT#
 
694
TABLE_COLLATION utf8_general_ci
 
695
CHECKSUM        NULL
 
696
CREATE_OPTIONS  #CO#
 
697
TABLE_COMMENT   #TC#
 
698
user_comment    
 
699
Separator       -----------------------------------------------------
 
700
TABLE_CATALOG   NULL
 
701
TABLE_SCHEMA    information_schema
 
702
TABLE_NAME      COLLATIONS
 
703
TABLE_TYPE      SYSTEM VIEW
 
704
ENGINE  MEMORY
 
705
VERSION 10
 
706
ROW_FORMAT      Fixed
 
707
TABLE_ROWS      #TBLR#
 
708
AVG_ROW_LENGTH  #ARL#
 
709
DATA_LENGTH     #DL#
 
710
MAX_DATA_LENGTH #MDL#
 
711
INDEX_LENGTH    #IL#
 
712
DATA_FREE       #DF#
 
713
AUTO_INCREMENT  NULL
 
714
CREATE_TIME     #CRT#
 
715
UPDATE_TIME     #UT#
 
716
CHECK_TIME      #CT#
 
717
TABLE_COLLATION utf8_general_ci
 
718
CHECKSUM        NULL
 
719
CREATE_OPTIONS  #CO#
 
720
TABLE_COMMENT   #TC#
 
721
user_comment    
 
722
Separator       -----------------------------------------------------
 
723
TABLE_CATALOG   NULL
 
724
TABLE_SCHEMA    information_schema
 
725
TABLE_NAME      COLLATION_CHARACTER_SET_APPLICABILITY
 
726
TABLE_TYPE      SYSTEM VIEW
 
727
ENGINE  MEMORY
 
728
VERSION 10
 
729
ROW_FORMAT      Fixed
 
730
TABLE_ROWS      #TBLR#
 
731
AVG_ROW_LENGTH  #ARL#
 
732
DATA_LENGTH     #DL#
 
733
MAX_DATA_LENGTH #MDL#
 
734
INDEX_LENGTH    #IL#
 
735
DATA_FREE       #DF#
 
736
AUTO_INCREMENT  NULL
 
737
CREATE_TIME     #CRT#
 
738
UPDATE_TIME     #UT#
 
739
CHECK_TIME      #CT#
 
740
TABLE_COLLATION utf8_general_ci
 
741
CHECKSUM        NULL
 
742
CREATE_OPTIONS  #CO#
 
743
TABLE_COMMENT   #TC#
 
744
user_comment    
 
745
Separator       -----------------------------------------------------
 
746
TABLE_CATALOG   NULL
 
747
TABLE_SCHEMA    information_schema
 
748
TABLE_NAME      COLUMNS
 
749
TABLE_TYPE      SYSTEM VIEW
 
750
ENGINE  MyISAM
 
751
VERSION 10
 
752
ROW_FORMAT      Dynamic
 
753
TABLE_ROWS      #TBLR#
 
754
AVG_ROW_LENGTH  #ARL#
 
755
DATA_LENGTH     #DL#
 
756
MAX_DATA_LENGTH #MDL#
 
757
INDEX_LENGTH    #IL#
 
758
DATA_FREE       #DF#
 
759
AUTO_INCREMENT  NULL
 
760
CREATE_TIME     #CRT#
 
761
UPDATE_TIME     #UT#
 
762
CHECK_TIME      #CT#
 
763
TABLE_COLLATION utf8_general_ci
 
764
CHECKSUM        NULL
 
765
CREATE_OPTIONS  #CO#
 
766
TABLE_COMMENT   #TC#
 
767
user_comment    
 
768
Separator       -----------------------------------------------------
 
769
TABLE_CATALOG   NULL
 
770
TABLE_SCHEMA    information_schema
 
771
TABLE_NAME      COLUMN_PRIVILEGES
 
772
TABLE_TYPE      SYSTEM VIEW
 
773
ENGINE  MEMORY
 
774
VERSION 10
 
775
ROW_FORMAT      Fixed
 
776
TABLE_ROWS      #TBLR#
 
777
AVG_ROW_LENGTH  #ARL#
 
778
DATA_LENGTH     #DL#
 
779
MAX_DATA_LENGTH #MDL#
 
780
INDEX_LENGTH    #IL#
 
781
DATA_FREE       #DF#
 
782
AUTO_INCREMENT  NULL
 
783
CREATE_TIME     #CRT#
 
784
UPDATE_TIME     #UT#
 
785
CHECK_TIME      #CT#
 
786
TABLE_COLLATION utf8_general_ci
 
787
CHECKSUM        NULL
 
788
CREATE_OPTIONS  #CO#
 
789
TABLE_COMMENT   #TC#
 
790
user_comment    
 
791
Separator       -----------------------------------------------------
 
792
TABLE_CATALOG   NULL
 
793
TABLE_SCHEMA    information_schema
 
794
TABLE_NAME      ENGINES
 
795
TABLE_TYPE      SYSTEM VIEW
 
796
ENGINE  MEMORY
 
797
VERSION 10
 
798
ROW_FORMAT      Fixed
 
799
TABLE_ROWS      #TBLR#
 
800
AVG_ROW_LENGTH  #ARL#
 
801
DATA_LENGTH     #DL#
 
802
MAX_DATA_LENGTH #MDL#
 
803
INDEX_LENGTH    #IL#
 
804
DATA_FREE       #DF#
 
805
AUTO_INCREMENT  NULL
 
806
CREATE_TIME     #CRT#
 
807
UPDATE_TIME     #UT#
 
808
CHECK_TIME      #CT#
 
809
TABLE_COLLATION utf8_general_ci
 
810
CHECKSUM        NULL
 
811
CREATE_OPTIONS  #CO#
 
812
TABLE_COMMENT   #TC#
 
813
user_comment    
 
814
Separator       -----------------------------------------------------
 
815
TABLE_CATALOG   NULL
 
816
TABLE_SCHEMA    information_schema
 
817
TABLE_NAME      EVENTS
 
818
TABLE_TYPE      SYSTEM VIEW
 
819
ENGINE  MyISAM
 
820
VERSION 10
 
821
ROW_FORMAT      Dynamic
 
822
TABLE_ROWS      #TBLR#
 
823
AVG_ROW_LENGTH  #ARL#
 
824
DATA_LENGTH     #DL#
 
825
MAX_DATA_LENGTH #MDL#
 
826
INDEX_LENGTH    #IL#
 
827
DATA_FREE       #DF#
 
828
AUTO_INCREMENT  NULL
 
829
CREATE_TIME     #CRT#
 
830
UPDATE_TIME     #UT#
 
831
CHECK_TIME      #CT#
 
832
TABLE_COLLATION utf8_general_ci
 
833
CHECKSUM        NULL
 
834
CREATE_OPTIONS  #CO#
 
835
TABLE_COMMENT   #TC#
 
836
user_comment    
 
837
Separator       -----------------------------------------------------
 
838
TABLE_CATALOG   NULL
 
839
TABLE_SCHEMA    information_schema
 
840
TABLE_NAME      FILES
 
841
TABLE_TYPE      SYSTEM VIEW
 
842
ENGINE  MEMORY
 
843
VERSION 10
 
844
ROW_FORMAT      Fixed
 
845
TABLE_ROWS      #TBLR#
 
846
AVG_ROW_LENGTH  #ARL#
 
847
DATA_LENGTH     #DL#
 
848
MAX_DATA_LENGTH #MDL#
 
849
INDEX_LENGTH    #IL#
 
850
DATA_FREE       #DF#
 
851
AUTO_INCREMENT  NULL
 
852
CREATE_TIME     #CRT#
 
853
UPDATE_TIME     #UT#
 
854
CHECK_TIME      #CT#
 
855
TABLE_COLLATION utf8_general_ci
 
856
CHECKSUM        NULL
 
857
CREATE_OPTIONS  #CO#
 
858
TABLE_COMMENT   #TC#
 
859
user_comment    
 
860
Separator       -----------------------------------------------------
 
861
TABLE_CATALOG   NULL
 
862
TABLE_SCHEMA    information_schema
 
863
TABLE_NAME      GLOBAL_STATUS
 
864
TABLE_TYPE      SYSTEM VIEW
 
865
ENGINE  MEMORY
 
866
VERSION 10
 
867
ROW_FORMAT      Fixed
 
868
TABLE_ROWS      #TBLR#
 
869
AVG_ROW_LENGTH  #ARL#
 
870
DATA_LENGTH     #DL#
 
871
MAX_DATA_LENGTH #MDL#
 
872
INDEX_LENGTH    #IL#
 
873
DATA_FREE       #DF#
 
874
AUTO_INCREMENT  NULL
 
875
CREATE_TIME     #CRT#
 
876
UPDATE_TIME     #UT#
 
877
CHECK_TIME      #CT#
 
878
TABLE_COLLATION utf8_general_ci
 
879
CHECKSUM        NULL
 
880
CREATE_OPTIONS  #CO#
 
881
TABLE_COMMENT   #TC#
 
882
user_comment    
 
883
Separator       -----------------------------------------------------
 
884
TABLE_CATALOG   NULL
 
885
TABLE_SCHEMA    information_schema
 
886
TABLE_NAME      GLOBAL_VARIABLES
 
887
TABLE_TYPE      SYSTEM VIEW
 
888
ENGINE  MEMORY
 
889
VERSION 10
 
890
ROW_FORMAT      Fixed
 
891
TABLE_ROWS      #TBLR#
 
892
AVG_ROW_LENGTH  #ARL#
 
893
DATA_LENGTH     #DL#
 
894
MAX_DATA_LENGTH #MDL#
 
895
INDEX_LENGTH    #IL#
 
896
DATA_FREE       #DF#
 
897
AUTO_INCREMENT  NULL
 
898
CREATE_TIME     #CRT#
 
899
UPDATE_TIME     #UT#
 
900
CHECK_TIME      #CT#
 
901
TABLE_COLLATION utf8_general_ci
 
902
CHECKSUM        NULL
 
903
CREATE_OPTIONS  #CO#
 
904
TABLE_COMMENT   #TC#
 
905
user_comment    
 
906
Separator       -----------------------------------------------------
 
907
TABLE_CATALOG   NULL
 
908
TABLE_SCHEMA    information_schema
 
909
TABLE_NAME      KEY_COLUMN_USAGE
 
910
TABLE_TYPE      SYSTEM VIEW
 
911
ENGINE  MEMORY
 
912
VERSION 10
 
913
ROW_FORMAT      Fixed
 
914
TABLE_ROWS      #TBLR#
 
915
AVG_ROW_LENGTH  #ARL#
 
916
DATA_LENGTH     #DL#
 
917
MAX_DATA_LENGTH #MDL#
 
918
INDEX_LENGTH    #IL#
 
919
DATA_FREE       #DF#
 
920
AUTO_INCREMENT  NULL
 
921
CREATE_TIME     #CRT#
 
922
UPDATE_TIME     #UT#
 
923
CHECK_TIME      #CT#
 
924
TABLE_COLLATION utf8_general_ci
 
925
CHECKSUM        NULL
 
926
CREATE_OPTIONS  #CO#
 
927
TABLE_COMMENT   #TC#
 
928
user_comment    
 
929
Separator       -----------------------------------------------------
 
930
TABLE_CATALOG   NULL
 
931
TABLE_SCHEMA    information_schema
 
932
TABLE_NAME      PARAMETERS
 
933
TABLE_TYPE      SYSTEM VIEW
 
934
ENGINE  MyISAM
 
935
VERSION 10
 
936
ROW_FORMAT      Dynamic
 
937
TABLE_ROWS      #TBLR#
 
938
AVG_ROW_LENGTH  #ARL#
 
939
DATA_LENGTH     #DL#
 
940
MAX_DATA_LENGTH #MDL#
 
941
INDEX_LENGTH    #IL#
 
942
DATA_FREE       #DF#
 
943
AUTO_INCREMENT  NULL
 
944
CREATE_TIME     #CRT#
 
945
UPDATE_TIME     #UT#
 
946
CHECK_TIME      #CT#
 
947
TABLE_COLLATION utf8_general_ci
 
948
CHECKSUM        NULL
 
949
CREATE_OPTIONS  #CO#
 
950
TABLE_COMMENT   #TC#
 
951
user_comment    
 
952
Separator       -----------------------------------------------------
 
953
TABLE_CATALOG   NULL
 
954
TABLE_SCHEMA    information_schema
 
955
TABLE_NAME      PARTITIONS
 
956
TABLE_TYPE      SYSTEM VIEW
 
957
ENGINE  MyISAM
 
958
VERSION 10
 
959
ROW_FORMAT      Dynamic
 
960
TABLE_ROWS      #TBLR#
 
961
AVG_ROW_LENGTH  #ARL#
 
962
DATA_LENGTH     #DL#
 
963
MAX_DATA_LENGTH #MDL#
 
964
INDEX_LENGTH    #IL#
 
965
DATA_FREE       #DF#
 
966
AUTO_INCREMENT  NULL
 
967
CREATE_TIME     #CRT#
 
968
UPDATE_TIME     #UT#
 
969
CHECK_TIME      #CT#
 
970
TABLE_COLLATION utf8_general_ci
 
971
CHECKSUM        NULL
 
972
CREATE_OPTIONS  #CO#
 
973
TABLE_COMMENT   #TC#
 
974
user_comment    
 
975
Separator       -----------------------------------------------------
 
976
TABLE_CATALOG   NULL
 
977
TABLE_SCHEMA    information_schema
 
978
TABLE_NAME      PLUGINS
 
979
TABLE_TYPE      SYSTEM VIEW
 
980
ENGINE  MyISAM
 
981
VERSION 10
 
982
ROW_FORMAT      Dynamic
 
983
TABLE_ROWS      #TBLR#
 
984
AVG_ROW_LENGTH  #ARL#
 
985
DATA_LENGTH     #DL#
 
986
MAX_DATA_LENGTH #MDL#
 
987
INDEX_LENGTH    #IL#
 
988
DATA_FREE       #DF#
 
989
AUTO_INCREMENT  NULL
 
990
CREATE_TIME     #CRT#
 
991
UPDATE_TIME     #UT#
 
992
CHECK_TIME      #CT#
 
993
TABLE_COLLATION utf8_general_ci
 
994
CHECKSUM        NULL
 
995
CREATE_OPTIONS  #CO#
 
996
TABLE_COMMENT   #TC#
 
997
user_comment    
 
998
Separator       -----------------------------------------------------
 
999
TABLE_CATALOG   NULL
 
1000
TABLE_SCHEMA    information_schema
 
1001
TABLE_NAME      PROCESSLIST
 
1002
TABLE_TYPE      SYSTEM VIEW
 
1003
ENGINE  MyISAM
 
1004
VERSION 10
 
1005
ROW_FORMAT      Dynamic
 
1006
TABLE_ROWS      #TBLR#
 
1007
AVG_ROW_LENGTH  #ARL#
 
1008
DATA_LENGTH     #DL#
 
1009
MAX_DATA_LENGTH #MDL#
 
1010
INDEX_LENGTH    #IL#
 
1011
DATA_FREE       #DF#
 
1012
AUTO_INCREMENT  NULL
 
1013
CREATE_TIME     #CRT#
 
1014
UPDATE_TIME     #UT#
 
1015
CHECK_TIME      #CT#
 
1016
TABLE_COLLATION utf8_general_ci
 
1017
CHECKSUM        NULL
 
1018
CREATE_OPTIONS  #CO#
 
1019
TABLE_COMMENT   #TC#
 
1020
user_comment    
 
1021
Separator       -----------------------------------------------------
 
1022
TABLE_CATALOG   NULL
 
1023
TABLE_SCHEMA    information_schema
 
1024
TABLE_NAME      REFERENTIAL_CONSTRAINTS
 
1025
TABLE_TYPE      SYSTEM VIEW
 
1026
ENGINE  MEMORY
 
1027
VERSION 10
 
1028
ROW_FORMAT      Fixed
 
1029
TABLE_ROWS      #TBLR#
 
1030
AVG_ROW_LENGTH  #ARL#
 
1031
DATA_LENGTH     #DL#
 
1032
MAX_DATA_LENGTH #MDL#
 
1033
INDEX_LENGTH    #IL#
 
1034
DATA_FREE       #DF#
 
1035
AUTO_INCREMENT  NULL
 
1036
CREATE_TIME     #CRT#
 
1037
UPDATE_TIME     #UT#
 
1038
CHECK_TIME      #CT#
 
1039
TABLE_COLLATION utf8_general_ci
 
1040
CHECKSUM        NULL
 
1041
CREATE_OPTIONS  #CO#
 
1042
TABLE_COMMENT   #TC#
 
1043
user_comment    
 
1044
Separator       -----------------------------------------------------
 
1045
TABLE_CATALOG   NULL
 
1046
TABLE_SCHEMA    information_schema
 
1047
TABLE_NAME      ROUTINES
 
1048
TABLE_TYPE      SYSTEM VIEW
 
1049
ENGINE  MyISAM
 
1050
VERSION 10
 
1051
ROW_FORMAT      Dynamic
 
1052
TABLE_ROWS      #TBLR#
 
1053
AVG_ROW_LENGTH  #ARL#
 
1054
DATA_LENGTH     #DL#
 
1055
MAX_DATA_LENGTH #MDL#
 
1056
INDEX_LENGTH    #IL#
 
1057
DATA_FREE       #DF#
 
1058
AUTO_INCREMENT  NULL
 
1059
CREATE_TIME     #CRT#
 
1060
UPDATE_TIME     #UT#
 
1061
CHECK_TIME      #CT#
 
1062
TABLE_COLLATION utf8_general_ci
 
1063
CHECKSUM        NULL
 
1064
CREATE_OPTIONS  #CO#
 
1065
TABLE_COMMENT   #TC#
 
1066
user_comment    
 
1067
Separator       -----------------------------------------------------
 
1068
TABLE_CATALOG   NULL
 
1069
TABLE_SCHEMA    information_schema
 
1070
TABLE_NAME      SCHEMATA
 
1071
TABLE_TYPE      SYSTEM VIEW
 
1072
ENGINE  MEMORY
 
1073
VERSION 10
 
1074
ROW_FORMAT      Fixed
 
1075
TABLE_ROWS      #TBLR#
 
1076
AVG_ROW_LENGTH  #ARL#
 
1077
DATA_LENGTH     #DL#
 
1078
MAX_DATA_LENGTH #MDL#
 
1079
INDEX_LENGTH    #IL#
 
1080
DATA_FREE       #DF#
 
1081
AUTO_INCREMENT  NULL
 
1082
CREATE_TIME     #CRT#
 
1083
UPDATE_TIME     #UT#
 
1084
CHECK_TIME      #CT#
 
1085
TABLE_COLLATION utf8_general_ci
 
1086
CHECKSUM        NULL
 
1087
CREATE_OPTIONS  #CO#
 
1088
TABLE_COMMENT   #TC#
 
1089
user_comment    
 
1090
Separator       -----------------------------------------------------
 
1091
TABLE_CATALOG   NULL
 
1092
TABLE_SCHEMA    information_schema
 
1093
TABLE_NAME      SCHEMA_PRIVILEGES
 
1094
TABLE_TYPE      SYSTEM VIEW
 
1095
ENGINE  MEMORY
 
1096
VERSION 10
 
1097
ROW_FORMAT      Fixed
 
1098
TABLE_ROWS      #TBLR#
 
1099
AVG_ROW_LENGTH  #ARL#
 
1100
DATA_LENGTH     #DL#
 
1101
MAX_DATA_LENGTH #MDL#
 
1102
INDEX_LENGTH    #IL#
 
1103
DATA_FREE       #DF#
 
1104
AUTO_INCREMENT  NULL
 
1105
CREATE_TIME     #CRT#
 
1106
UPDATE_TIME     #UT#
 
1107
CHECK_TIME      #CT#
 
1108
TABLE_COLLATION utf8_general_ci
 
1109
CHECKSUM        NULL
 
1110
CREATE_OPTIONS  #CO#
 
1111
TABLE_COMMENT   #TC#
 
1112
user_comment    
 
1113
Separator       -----------------------------------------------------
 
1114
TABLE_CATALOG   NULL
 
1115
TABLE_SCHEMA    information_schema
 
1116
TABLE_NAME      SESSION_STATUS
 
1117
TABLE_TYPE      SYSTEM VIEW
 
1118
ENGINE  MEMORY
 
1119
VERSION 10
 
1120
ROW_FORMAT      Fixed
 
1121
TABLE_ROWS      #TBLR#
 
1122
AVG_ROW_LENGTH  #ARL#
 
1123
DATA_LENGTH     #DL#
 
1124
MAX_DATA_LENGTH #MDL#
 
1125
INDEX_LENGTH    #IL#
 
1126
DATA_FREE       #DF#
 
1127
AUTO_INCREMENT  NULL
 
1128
CREATE_TIME     #CRT#
 
1129
UPDATE_TIME     #UT#
 
1130
CHECK_TIME      #CT#
 
1131
TABLE_COLLATION utf8_general_ci
 
1132
CHECKSUM        NULL
 
1133
CREATE_OPTIONS  #CO#
 
1134
TABLE_COMMENT   #TC#
 
1135
user_comment    
 
1136
Separator       -----------------------------------------------------
 
1137
TABLE_CATALOG   NULL
 
1138
TABLE_SCHEMA    information_schema
 
1139
TABLE_NAME      SESSION_VARIABLES
 
1140
TABLE_TYPE      SYSTEM VIEW
 
1141
ENGINE  MEMORY
 
1142
VERSION 10
 
1143
ROW_FORMAT      Fixed
 
1144
TABLE_ROWS      #TBLR#
 
1145
AVG_ROW_LENGTH  #ARL#
 
1146
DATA_LENGTH     #DL#
 
1147
MAX_DATA_LENGTH #MDL#
 
1148
INDEX_LENGTH    #IL#
 
1149
DATA_FREE       #DF#
 
1150
AUTO_INCREMENT  NULL
 
1151
CREATE_TIME     #CRT#
 
1152
UPDATE_TIME     #UT#
 
1153
CHECK_TIME      #CT#
 
1154
TABLE_COLLATION utf8_general_ci
 
1155
CHECKSUM        NULL
 
1156
CREATE_OPTIONS  #CO#
 
1157
TABLE_COMMENT   #TC#
 
1158
user_comment    
 
1159
Separator       -----------------------------------------------------
 
1160
TABLE_CATALOG   NULL
 
1161
TABLE_SCHEMA    information_schema
 
1162
TABLE_NAME      STATISTICS
 
1163
TABLE_TYPE      SYSTEM VIEW
 
1164
ENGINE  MEMORY
 
1165
VERSION 10
 
1166
ROW_FORMAT      Fixed
 
1167
TABLE_ROWS      #TBLR#
 
1168
AVG_ROW_LENGTH  #ARL#
 
1169
DATA_LENGTH     #DL#
 
1170
MAX_DATA_LENGTH #MDL#
 
1171
INDEX_LENGTH    #IL#
 
1172
DATA_FREE       #DF#
 
1173
AUTO_INCREMENT  NULL
 
1174
CREATE_TIME     #CRT#
 
1175
UPDATE_TIME     #UT#
 
1176
CHECK_TIME      #CT#
 
1177
TABLE_COLLATION utf8_general_ci
 
1178
CHECKSUM        NULL
 
1179
CREATE_OPTIONS  #CO#
 
1180
TABLE_COMMENT   #TC#
 
1181
user_comment    
 
1182
Separator       -----------------------------------------------------
 
1183
TABLE_CATALOG   NULL
 
1184
TABLE_SCHEMA    information_schema
 
1185
TABLE_NAME      TABLES
 
1186
TABLE_TYPE      SYSTEM VIEW
 
1187
ENGINE  MEMORY
 
1188
VERSION 10
 
1189
ROW_FORMAT      Fixed
 
1190
TABLE_ROWS      #TBLR#
 
1191
AVG_ROW_LENGTH  #ARL#
 
1192
DATA_LENGTH     #DL#
 
1193
MAX_DATA_LENGTH #MDL#
 
1194
INDEX_LENGTH    #IL#
 
1195
DATA_FREE       #DF#
 
1196
AUTO_INCREMENT  NULL
 
1197
CREATE_TIME     #CRT#
 
1198
UPDATE_TIME     #UT#
 
1199
CHECK_TIME      #CT#
 
1200
TABLE_COLLATION utf8_general_ci
 
1201
CHECKSUM        NULL
 
1202
CREATE_OPTIONS  #CO#
 
1203
TABLE_COMMENT   #TC#
 
1204
user_comment    
 
1205
Separator       -----------------------------------------------------
 
1206
TABLE_CATALOG   NULL
 
1207
TABLE_SCHEMA    information_schema
 
1208
TABLE_NAME      TABLE_CONSTRAINTS
 
1209
TABLE_TYPE      SYSTEM VIEW
 
1210
ENGINE  MEMORY
 
1211
VERSION 10
 
1212
ROW_FORMAT      Fixed
 
1213
TABLE_ROWS      #TBLR#
 
1214
AVG_ROW_LENGTH  #ARL#
 
1215
DATA_LENGTH     #DL#
 
1216
MAX_DATA_LENGTH #MDL#
 
1217
INDEX_LENGTH    #IL#
 
1218
DATA_FREE       #DF#
 
1219
AUTO_INCREMENT  NULL
 
1220
CREATE_TIME     #CRT#
 
1221
UPDATE_TIME     #UT#
 
1222
CHECK_TIME      #CT#
 
1223
TABLE_COLLATION utf8_general_ci
 
1224
CHECKSUM        NULL
 
1225
CREATE_OPTIONS  #CO#
 
1226
TABLE_COMMENT   #TC#
 
1227
user_comment    
 
1228
Separator       -----------------------------------------------------
 
1229
TABLE_CATALOG   NULL
 
1230
TABLE_SCHEMA    information_schema
 
1231
TABLE_NAME      TABLE_PRIVILEGES
 
1232
TABLE_TYPE      SYSTEM VIEW
 
1233
ENGINE  MEMORY
 
1234
VERSION 10
 
1235
ROW_FORMAT      Fixed
 
1236
TABLE_ROWS      #TBLR#
 
1237
AVG_ROW_LENGTH  #ARL#
 
1238
DATA_LENGTH     #DL#
 
1239
MAX_DATA_LENGTH #MDL#
 
1240
INDEX_LENGTH    #IL#
 
1241
DATA_FREE       #DF#
 
1242
AUTO_INCREMENT  NULL
 
1243
CREATE_TIME     #CRT#
 
1244
UPDATE_TIME     #UT#
 
1245
CHECK_TIME      #CT#
 
1246
TABLE_COLLATION utf8_general_ci
 
1247
CHECKSUM        NULL
 
1248
CREATE_OPTIONS  #CO#
 
1249
TABLE_COMMENT   #TC#
 
1250
user_comment    
 
1251
Separator       -----------------------------------------------------
 
1252
TABLE_CATALOG   NULL
 
1253
TABLE_SCHEMA    information_schema
 
1254
TABLE_NAME      TRIGGERS
 
1255
TABLE_TYPE      SYSTEM VIEW
 
1256
ENGINE  MyISAM
 
1257
VERSION 10
 
1258
ROW_FORMAT      Dynamic
 
1259
TABLE_ROWS      #TBLR#
 
1260
AVG_ROW_LENGTH  #ARL#
 
1261
DATA_LENGTH     #DL#
 
1262
MAX_DATA_LENGTH #MDL#
 
1263
INDEX_LENGTH    #IL#
 
1264
DATA_FREE       #DF#
 
1265
AUTO_INCREMENT  NULL
 
1266
CREATE_TIME     #CRT#
 
1267
UPDATE_TIME     #UT#
 
1268
CHECK_TIME      #CT#
 
1269
TABLE_COLLATION utf8_general_ci
 
1270
CHECKSUM        NULL
 
1271
CREATE_OPTIONS  #CO#
 
1272
TABLE_COMMENT   #TC#
 
1273
user_comment    
 
1274
Separator       -----------------------------------------------------
 
1275
TABLE_CATALOG   NULL
 
1276
TABLE_SCHEMA    information_schema
 
1277
TABLE_NAME      USER_PRIVILEGES
 
1278
TABLE_TYPE      SYSTEM VIEW
 
1279
ENGINE  MEMORY
 
1280
VERSION 10
 
1281
ROW_FORMAT      Fixed
 
1282
TABLE_ROWS      #TBLR#
 
1283
AVG_ROW_LENGTH  #ARL#
 
1284
DATA_LENGTH     #DL#
 
1285
MAX_DATA_LENGTH #MDL#
 
1286
INDEX_LENGTH    #IL#
 
1287
DATA_FREE       #DF#
 
1288
AUTO_INCREMENT  NULL
 
1289
CREATE_TIME     #CRT#
 
1290
UPDATE_TIME     #UT#
 
1291
CHECK_TIME      #CT#
 
1292
TABLE_COLLATION utf8_general_ci
 
1293
CHECKSUM        NULL
 
1294
CREATE_OPTIONS  #CO#
 
1295
TABLE_COMMENT   #TC#
 
1296
user_comment    
 
1297
Separator       -----------------------------------------------------
 
1298
TABLE_CATALOG   NULL
 
1299
TABLE_SCHEMA    information_schema
 
1300
TABLE_NAME      VIEWS
 
1301
TABLE_TYPE      SYSTEM VIEW
 
1302
ENGINE  MyISAM
 
1303
VERSION 10
 
1304
ROW_FORMAT      Dynamic
 
1305
TABLE_ROWS      #TBLR#
 
1306
AVG_ROW_LENGTH  #ARL#
 
1307
DATA_LENGTH     #DL#
 
1308
MAX_DATA_LENGTH #MDL#
 
1309
INDEX_LENGTH    #IL#
 
1310
DATA_FREE       #DF#
 
1311
AUTO_INCREMENT  NULL
 
1312
CREATE_TIME     #CRT#
 
1313
UPDATE_TIME     #UT#
 
1314
CHECK_TIME      #CT#
 
1315
TABLE_COLLATION utf8_general_ci
 
1316
CHECKSUM        NULL
 
1317
CREATE_OPTIONS  #CO#
 
1318
TABLE_COMMENT   #TC#
 
1319
user_comment    
 
1320
Separator       -----------------------------------------------------
 
1321
# Switch to connection default and close connection testuser1
 
1322
DROP USER testuser1@localhost;
 
1323
DROP DATABASE db_datadict;