~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

  • Committer: Brian Aker
  • Date: 2009-07-23 00:02:03 UTC
  • mfrom: (1093.1.25 captain)
  • Revision ID: brian@gaz-20090723000203-kkrx4udjiiwy869o
Mege Jay

Show diffs side-by-side

added added

removed removed

Lines of Context:
244
244
        )
245
245
AND t.table_name NOT LIKE 'falcon%';
246
246
table_name      column_name
247
 
GLOBAL_STATUS   VARIABLE_NAME
248
 
GLOBAL_VARIABLES        VARIABLE_NAME
249
 
SESSION_STATUS  VARIABLE_NAME
250
 
SESSION_VARIABLES       VARIABLE_NAME
251
247
INNODB_TRX      trx_id
252
248
INNODB_LOCKS    lock_id
253
249
INNODB_LOCK_WAITS       requesting_trx_id
260
256
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
261
257
COLUMNS TABLE_SCHEMA
262
258
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
 
259
GLOBAL_STATUS   VARIABLE_NAME
 
260
GLOBAL_VARIABLES        VARIABLE_NAME
263
261
PLUGINS PLUGIN_NAME
264
262
PROCESSLIST     ID
265
263
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
266
264
SCHEMATA        SCHEMA_NAME
 
265
SESSION_STATUS  VARIABLE_NAME
 
266
SESSION_VARIABLES       VARIABLE_NAME
267
267
STATISTICS      TABLE_SCHEMA
268
268
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
269
269
TABLES  TABLE_SCHEMA
283
283
        )
284
284
AND t.table_name NOT LIKE 'falcon%';
285
285
table_name      column_name
286
 
GLOBAL_STATUS   VARIABLE_NAME
287
 
GLOBAL_VARIABLES        VARIABLE_NAME
288
 
SESSION_STATUS  VARIABLE_NAME
289
 
SESSION_VARIABLES       VARIABLE_NAME
290
286
INNODB_TRX      trx_id
291
287
INNODB_LOCKS    lock_id
292
288
INNODB_LOCK_WAITS       requesting_trx_id
299
295
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
300
296
COLUMNS TABLE_SCHEMA
301
297
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
 
298
GLOBAL_STATUS   VARIABLE_NAME
 
299
GLOBAL_VARIABLES        VARIABLE_NAME
302
300
PLUGINS PLUGIN_NAME
303
301
PROCESSLIST     ID
304
302
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
305
303
SCHEMATA        SCHEMA_NAME
 
304
SESSION_STATUS  VARIABLE_NAME
 
305
SESSION_VARIABLES       VARIABLE_NAME
306
306
STATISTICS      TABLE_SCHEMA
307
307
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
308
308
TABLES  TABLE_SCHEMA
465
465
FROM information_schema.processlist
466
466
WHERE id = CONNECTION_ID()      Query   test
467
467
SELECT *
468
 
FROM information_schema.character_sets;
 
468
FROM information_schema.character_sets
 
469
ORDER BY character_set_name;
469
470
CHARACTER_SET_NAME      DEFAULT_COLLATE_NAME    DESCRIPTION     MAXLEN
 
471
binary  binary          1
470
472
utf8    utf8_general_ci UTF-8 Unicode   4
471
 
binary  binary          1
472
473
SELECT *
473
 
FROM information_schema.collations;
 
474
FROM information_schema.collations
 
475
ORDER BY collation_name;
474
476
COLLATION_NAME  CHARACTER_SET_NAME      DESCRIPTION     ID      IS_DEFAULT      IS_COMPILED     SORTLEN
 
477
binary  binary  63      0       Yes     1       0
 
478
utf8_bin        utf8    46      0       Yes     1       0
 
479
utf8_czech_ci   utf8    234     0       Yes     8       0
 
480
utf8_danish_ci  utf8    235     0       Yes     8       0
 
481
utf8_esperanto_ci       utf8    241     0       Yes     8       0
 
482
utf8_estonian_ci        utf8    230     0       Yes     8       0
475
483
utf8_general_ci utf8    45      0       Yes     1       0
476
 
utf8_bin        utf8    46      0       Yes     1       0
477
 
utf8_unicode_ci utf8    224     0       Yes     8       0
 
484
utf8_hungarian_ci       utf8    242     0       Yes     8       0
478
485
utf8_icelandic_ci       utf8    225     0       Yes     8       0
479
486
utf8_latvian_ci utf8    226     0       Yes     8       0
 
487
utf8_lithuanian_ci      utf8    236     0       Yes     8       0
 
488
utf8_persian_ci utf8    240     0       Yes     8       0
 
489
utf8_polish_ci  utf8    229     0       Yes     8       0
480
490
utf8_romanian_ci        utf8    227     0       Yes     8       0
 
491
utf8_roman_ci   utf8    239     0       Yes     8       0
 
492
utf8_sinhala_ci utf8    243     0       Yes     8       0
 
493
utf8_slovak_ci  utf8    237     0       Yes     8       0
481
494
utf8_slovenian_ci       utf8    228     0       Yes     8       0
482
 
utf8_polish_ci  utf8    229     0       Yes     8       0
483
 
utf8_estonian_ci        utf8    230     0       Yes     8       0
 
495
utf8_spanish2_ci        utf8    238     0       Yes     8       0
484
496
utf8_spanish_ci utf8    231     0       Yes     8       0
485
497
utf8_swedish_ci utf8    232     0       Yes     8       0
486
498
utf8_turkish_ci utf8    233     0       Yes     8       0
487
 
utf8_czech_ci   utf8    234     0       Yes     8       0
488
 
utf8_danish_ci  utf8    235     0       Yes     8       0
489
 
utf8_lithuanian_ci      utf8    236     0       Yes     8       0
490
 
utf8_slovak_ci  utf8    237     0       Yes     8       0
491
 
utf8_spanish2_ci        utf8    238     0       Yes     8       0
492
 
utf8_roman_ci   utf8    239     0       Yes     8       0
493
 
utf8_persian_ci utf8    240     0       Yes     8       0
494
 
utf8_esperanto_ci       utf8    241     0       Yes     8       0
495
 
utf8_hungarian_ci       utf8    242     0       Yes     8       0
496
 
utf8_sinhala_ci utf8    243     0       Yes     8       0
497
 
binary  binary  63      0       Yes     1       0
 
499
utf8_unicode_ci utf8    224     0       Yes     8       0
498
500
SELECT * 
499
 
FROM information_schema.collation_character_set_applicability;
 
501
FROM information_schema.collation_character_set_applicability
 
502
ORDER BY collation_name;
500
503
COLLATION_NAME  CHARACTER_SET_NAME
 
504
binary  binary
 
505
utf8_bin        utf8
 
506
utf8_czech_ci   utf8
 
507
utf8_danish_ci  utf8
 
508
utf8_esperanto_ci       utf8
 
509
utf8_estonian_ci        utf8
501
510
utf8_general_ci utf8
502
 
utf8_bin        utf8
503
 
utf8_unicode_ci utf8
 
511
utf8_hungarian_ci       utf8
504
512
utf8_icelandic_ci       utf8
505
513
utf8_latvian_ci utf8
 
514
utf8_lithuanian_ci      utf8
 
515
utf8_persian_ci utf8
 
516
utf8_polish_ci  utf8
506
517
utf8_romanian_ci        utf8
 
518
utf8_roman_ci   utf8
 
519
utf8_sinhala_ci utf8
 
520
utf8_slovak_ci  utf8
507
521
utf8_slovenian_ci       utf8
508
 
utf8_polish_ci  utf8
509
 
utf8_estonian_ci        utf8
 
522
utf8_spanish2_ci        utf8
510
523
utf8_spanish_ci utf8
511
524
utf8_swedish_ci utf8
512
525
utf8_turkish_ci utf8
513
 
utf8_czech_ci   utf8
514
 
utf8_danish_ci  utf8
515
 
utf8_lithuanian_ci      utf8
516
 
utf8_slovak_ci  utf8
517
 
utf8_spanish2_ci        utf8
518
 
utf8_roman_ci   utf8
519
 
utf8_persian_ci utf8
520
 
utf8_esperanto_ci       utf8
521
 
utf8_hungarian_ci       utf8
522
 
utf8_sinhala_ci utf8
523
 
binary  binary
 
526
utf8_unicode_ci utf8
524
527
SELECT table_name, column_name
525
 
FROM information_schema.columns;
 
528
FROM information_schema.columns
 
529
ORDER BY table_name;
526
530
table_name      column_name
527
 
GLOBAL_STATUS   VARIABLE_NAME
528
 
GLOBAL_STATUS   VARIABLE_VALUE
529
 
GLOBAL_VARIABLES        VARIABLE_NAME
530
 
GLOBAL_VARIABLES        VARIABLE_VALUE
531
 
SESSION_STATUS  VARIABLE_NAME
532
 
SESSION_STATUS  VARIABLE_VALUE
533
 
SESSION_VARIABLES       VARIABLE_NAME
534
 
SESSION_VARIABLES       VARIABLE_VALUE
535
 
INNODB_TRX      trx_id
536
 
INNODB_TRX      trx_state
537
 
INNODB_TRX      trx_started
538
 
INNODB_TRX      trx_requested_lock_id
539
 
INNODB_TRX      trx_wait_started
540
 
INNODB_TRX      trx_weight
541
 
INNODB_TRX      trx_mysql_thread_id
542
 
INNODB_TRX      trx_query
543
 
INNODB_LOCKS    lock_id
544
 
INNODB_LOCKS    lock_trx_id
545
 
INNODB_LOCKS    lock_mode
546
 
INNODB_LOCKS    lock_type
547
 
INNODB_LOCKS    lock_table
548
 
INNODB_LOCKS    lock_index
549
 
INNODB_LOCKS    lock_space
550
 
INNODB_LOCKS    lock_page
551
 
INNODB_LOCKS    lock_rec
552
 
INNODB_LOCKS    lock_data
553
 
INNODB_LOCK_WAITS       requesting_trx_id
554
 
INNODB_LOCK_WAITS       requested_lock_id
555
 
INNODB_LOCK_WAITS       blocking_trx_id
556
 
INNODB_LOCK_WAITS       blocking_lock_id
557
 
INNODB_CMP      page_size
558
 
INNODB_CMP      compress_ops
559
 
INNODB_CMP      compress_ops_ok
560
 
INNODB_CMP      compress_time
561
 
INNODB_CMP      uncompress_ops
562
 
INNODB_CMP      uncompress_time
563
 
INNODB_CMP_RESET        page_size
564
 
INNODB_CMP_RESET        compress_ops
565
 
INNODB_CMP_RESET        compress_ops_ok
566
 
INNODB_CMP_RESET        compress_time
567
 
INNODB_CMP_RESET        uncompress_ops
568
 
INNODB_CMP_RESET        uncompress_time
569
 
INNODB_CMPMEM   page_size
570
 
INNODB_CMPMEM   pages_used
571
 
INNODB_CMPMEM   pages_free
572
 
INNODB_CMPMEM   relocation_ops
573
 
INNODB_CMPMEM   relocation_time
574
 
INNODB_CMPMEM_RESET     page_size
575
 
INNODB_CMPMEM_RESET     pages_used
576
 
INNODB_CMPMEM_RESET     pages_free
577
 
INNODB_CMPMEM_RESET     relocation_ops
578
 
INNODB_CMPMEM_RESET     relocation_time
579
 
CHARACTER_SETS  CHARACTER_SET_NAME
 
531
CHARACTER_SETS  MAXLEN
 
532
CHARACTER_SETS  DESCRIPTION
580
533
CHARACTER_SETS  DEFAULT_COLLATE_NAME
581
 
CHARACTER_SETS  DESCRIPTION
582
 
CHARACTER_SETS  MAXLEN
583
 
COLLATIONS      COLLATION_NAME
584
 
COLLATIONS      CHARACTER_SET_NAME
585
 
COLLATIONS      DESCRIPTION
586
 
COLLATIONS      ID
587
 
COLLATIONS      IS_DEFAULT
 
534
CHARACTER_SETS  CHARACTER_SET_NAME
588
535
COLLATIONS      IS_COMPILED
 
536
COLLATIONS      COLLATION_NAME
589
537
COLLATIONS      SORTLEN
590
 
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
 
538
COLLATIONS      IS_DEFAULT
 
539
COLLATIONS      ID
 
540
COLLATIONS      DESCRIPTION
 
541
COLLATIONS      CHARACTER_SET_NAME
591
542
COLLATION_CHARACTER_SET_APPLICABILITY   CHARACTER_SET_NAME
 
543
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
 
544
COLUMNS PRIVILEGES
 
545
COLUMNS TABLE_SCHEMA
 
546
COLUMNS TABLE_NAME
592
547
COLUMNS TABLE_CATALOG
593
 
COLUMNS TABLE_SCHEMA
594
 
COLUMNS TABLE_NAME
595
548
COLUMNS COLUMN_NAME
596
549
COLUMNS ORDINAL_POSITION
597
550
COLUMNS COLUMN_DEFAULT
598
551
COLUMNS IS_NULLABLE
599
 
COLUMNS DATA_TYPE
600
 
COLUMNS CHARACTER_MAXIMUM_LENGTH
601
 
COLUMNS CHARACTER_OCTET_LENGTH
602
 
COLUMNS NUMERIC_PRECISION
603
 
COLUMNS NUMERIC_SCALE
 
552
COLUMNS FORMAT
 
553
COLUMNS COLLATION_NAME
604
554
COLUMNS CHARACTER_SET_NAME
605
 
COLUMNS COLLATION_NAME
 
555
COLUMNS COLUMN_COMMENT
606
556
COLUMNS COLUMN_TYPE
607
557
COLUMNS COLUMN_KEY
608
558
COLUMNS EXTRA
609
 
COLUMNS PRIVILEGES
610
 
COLUMNS COLUMN_COMMENT
611
559
COLUMNS STORAGE
612
 
COLUMNS FORMAT
 
560
COLUMNS NUMERIC_SCALE
 
561
COLUMNS NUMERIC_PRECISION
 
562
COLUMNS CHARACTER_OCTET_LENGTH
 
563
COLUMNS DATA_TYPE
 
564
COLUMNS CHARACTER_MAXIMUM_LENGTH
 
565
GLOBAL_STATUS   VARIABLE_NAME
 
566
GLOBAL_STATUS   VARIABLE_VALUE
 
567
GLOBAL_VARIABLES        VARIABLE_VALUE
 
568
GLOBAL_VARIABLES        VARIABLE_NAME
 
569
INNODB_CMP      compress_time
 
570
INNODB_CMP      uncompress_ops
 
571
INNODB_CMP      compress_ops
 
572
INNODB_CMP      page_size
 
573
INNODB_CMP      uncompress_time
 
574
INNODB_CMP      compress_ops_ok
 
575
INNODB_CMPMEM   relocation_time
 
576
INNODB_CMPMEM   relocation_ops
 
577
INNODB_CMPMEM   pages_used
 
578
INNODB_CMPMEM   page_size
 
579
INNODB_CMPMEM   pages_free
 
580
INNODB_CMPMEM_RESET     relocation_time
 
581
INNODB_CMPMEM_RESET     relocation_ops
 
582
INNODB_CMPMEM_RESET     pages_free
 
583
INNODB_CMPMEM_RESET     pages_used
 
584
INNODB_CMPMEM_RESET     page_size
 
585
INNODB_CMP_RESET        page_size
 
586
INNODB_CMP_RESET        compress_ops
 
587
INNODB_CMP_RESET        compress_ops_ok
 
588
INNODB_CMP_RESET        compress_time
 
589
INNODB_CMP_RESET        uncompress_ops
 
590
INNODB_CMP_RESET        uncompress_time
 
591
INNODB_LOCKS    lock_index
 
592
INNODB_LOCKS    lock_table
 
593
INNODB_LOCKS    lock_type
 
594
INNODB_LOCKS    lock_trx_id
 
595
INNODB_LOCKS    lock_id
 
596
INNODB_LOCKS    lock_mode
 
597
INNODB_LOCKS    lock_space
 
598
INNODB_LOCKS    lock_page
 
599
INNODB_LOCKS    lock_rec
 
600
INNODB_LOCKS    lock_data
 
601
INNODB_LOCK_WAITS       blocking_lock_id
 
602
INNODB_LOCK_WAITS       blocking_trx_id
 
603
INNODB_LOCK_WAITS       requested_lock_id
 
604
INNODB_LOCK_WAITS       requesting_trx_id
 
605
INNODB_TRX      trx_id
 
606
INNODB_TRX      trx_state
 
607
INNODB_TRX      trx_started
 
608
INNODB_TRX      trx_requested_lock_id
 
609
INNODB_TRX      trx_wait_started
 
610
INNODB_TRX      trx_weight
 
611
INNODB_TRX      trx_mysql_thread_id
 
612
INNODB_TRX      trx_query
 
613
KEY_COLUMN_USAGE        REFERENCED_COLUMN_NAME
 
614
KEY_COLUMN_USAGE        REFERENCED_TABLE_NAME
 
615
KEY_COLUMN_USAGE        REFERENCED_TABLE_SCHEMA
 
616
KEY_COLUMN_USAGE        POSITION_IN_UNIQUE_CONSTRAINT
 
617
KEY_COLUMN_USAGE        ORDINAL_POSITION
613
618
KEY_COLUMN_USAGE        CONSTRAINT_CATALOG
614
619
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
615
620
KEY_COLUMN_USAGE        CONSTRAINT_NAME
617
622
KEY_COLUMN_USAGE        TABLE_SCHEMA
618
623
KEY_COLUMN_USAGE        TABLE_NAME
619
624
KEY_COLUMN_USAGE        COLUMN_NAME
620
 
KEY_COLUMN_USAGE        ORDINAL_POSITION
621
 
KEY_COLUMN_USAGE        POSITION_IN_UNIQUE_CONSTRAINT
622
 
KEY_COLUMN_USAGE        REFERENCED_TABLE_SCHEMA
623
 
KEY_COLUMN_USAGE        REFERENCED_TABLE_NAME
624
 
KEY_COLUMN_USAGE        REFERENCED_COLUMN_NAME
625
 
PLUGINS PLUGIN_NAME
 
625
PLUGINS PLUGIN_LICENSE
 
626
PLUGINS PLUGIN_DESCRIPTION
 
627
PLUGINS PLUGIN_AUTHOR
 
628
PLUGINS PLUGIN_STATUS
626
629
PLUGINS PLUGIN_VERSION
627
 
PLUGINS PLUGIN_STATUS
628
 
PLUGINS PLUGIN_AUTHOR
629
 
PLUGINS PLUGIN_DESCRIPTION
630
 
PLUGINS PLUGIN_LICENSE
631
 
PROCESSLIST     ID
 
630
PLUGINS PLUGIN_NAME
 
631
PROCESSLIST     INFO
 
632
PROCESSLIST     STATE
 
633
PROCESSLIST     TIME
 
634
PROCESSLIST     COMMAND
 
635
PROCESSLIST     DB
 
636
PROCESSLIST     HOST
632
637
PROCESSLIST     USER
633
 
PROCESSLIST     HOST
634
 
PROCESSLIST     DB
635
 
PROCESSLIST     COMMAND
636
 
PROCESSLIST     TIME
637
 
PROCESSLIST     STATE
638
 
PROCESSLIST     INFO
 
638
PROCESSLIST     ID
 
639
REFERENTIAL_CONSTRAINTS REFERENCED_TABLE_NAME
 
640
REFERENTIAL_CONSTRAINTS TABLE_NAME
 
641
REFERENTIAL_CONSTRAINTS DELETE_RULE
 
642
REFERENTIAL_CONSTRAINTS UPDATE_RULE
 
643
REFERENTIAL_CONSTRAINTS MATCH_OPTION
 
644
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_NAME
 
645
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_SCHEMA
 
646
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_CATALOG
 
647
REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME
 
648
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
639
649
REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG
640
 
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
641
 
REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME
642
 
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_CATALOG
643
 
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_SCHEMA
644
 
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_NAME
645
 
REFERENTIAL_CONSTRAINTS MATCH_OPTION
646
 
REFERENTIAL_CONSTRAINTS UPDATE_RULE
647
 
REFERENTIAL_CONSTRAINTS DELETE_RULE
648
 
REFERENTIAL_CONSTRAINTS TABLE_NAME
649
 
REFERENTIAL_CONSTRAINTS REFERENCED_TABLE_NAME
 
650
SCHEMATA        SQL_PATH
 
651
SCHEMATA        DEFAULT_COLLATION_NAME
 
652
SCHEMATA        DEFAULT_CHARACTER_SET_NAME
 
653
SCHEMATA        SCHEMA_NAME
650
654
SCHEMATA        CATALOG_NAME
651
 
SCHEMATA        SCHEMA_NAME
652
 
SCHEMATA        DEFAULT_CHARACTER_SET_NAME
653
 
SCHEMATA        DEFAULT_COLLATION_NAME
654
 
SCHEMATA        SQL_PATH
655
 
STATISTICS      TABLE_CATALOG
656
 
STATISTICS      TABLE_SCHEMA
657
 
STATISTICS      TABLE_NAME
658
 
STATISTICS      NON_UNIQUE
659
 
STATISTICS      INDEX_SCHEMA
660
 
STATISTICS      INDEX_NAME
661
 
STATISTICS      SEQ_IN_INDEX
662
 
STATISTICS      COLUMN_NAME
663
 
STATISTICS      COLLATION
 
655
SESSION_STATUS  VARIABLE_VALUE
 
656
SESSION_STATUS  VARIABLE_NAME
 
657
SESSION_VARIABLES       VARIABLE_NAME
 
658
SESSION_VARIABLES       VARIABLE_VALUE
664
659
STATISTICS      CARDINALITY
665
660
STATISTICS      SUB_PART
666
661
STATISTICS      PACKED
668
663
STATISTICS      INDEX_TYPE
669
664
STATISTICS      COMMENT
670
665
STATISTICS      INDEX_COMMENT
671
 
TABLE_CONSTRAINTS       CONSTRAINT_CATALOG
672
 
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
673
 
TABLE_CONSTRAINTS       CONSTRAINT_NAME
674
 
TABLE_CONSTRAINTS       TABLE_SCHEMA
675
 
TABLE_CONSTRAINTS       TABLE_NAME
676
 
TABLE_CONSTRAINTS       CONSTRAINT_TYPE
677
 
TABLES  TABLE_CATALOG
678
 
TABLES  TABLE_SCHEMA
679
 
TABLES  TABLE_NAME
680
 
TABLES  TABLE_TYPE
681
 
TABLES  ENGINE
682
 
TABLES  VERSION
683
 
TABLES  ROW_FORMAT
684
 
TABLES  TABLE_ROWS
 
666
STATISTICS      COLLATION
 
667
STATISTICS      COLUMN_NAME
 
668
STATISTICS      TABLE_CATALOG
 
669
STATISTICS      TABLE_SCHEMA
 
670
STATISTICS      TABLE_NAME
 
671
STATISTICS      NON_UNIQUE
 
672
STATISTICS      INDEX_SCHEMA
 
673
STATISTICS      INDEX_NAME
 
674
STATISTICS      SEQ_IN_INDEX
685
675
TABLES  AVG_ROW_LENGTH
686
676
TABLES  DATA_LENGTH
687
677
TABLES  MAX_DATA_LENGTH
694
684
TABLES  TABLE_COLLATION
695
685
TABLES  CHECKSUM
696
686
TABLES  CREATE_OPTIONS
 
687
TABLES  TABLE_ROWS
 
688
TABLES  ROW_FORMAT
697
689
TABLES  TABLE_COMMENT
 
690
TABLES  TABLE_CATALOG
 
691
TABLES  TABLE_SCHEMA
 
692
TABLES  TABLE_NAME
 
693
TABLES  TABLE_TYPE
 
694
TABLES  ENGINE
 
695
TABLES  VERSION
 
696
TABLE_CONSTRAINTS       TABLE_NAME
 
697
TABLE_CONSTRAINTS       TABLE_SCHEMA
 
698
TABLE_CONSTRAINTS       CONSTRAINT_NAME
 
699
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
 
700
TABLE_CONSTRAINTS       CONSTRAINT_CATALOG
 
701
TABLE_CONSTRAINTS       CONSTRAINT_TYPE
698
702
SELECT *
699
703
FROM information_schema.key_column_usage;
700
704
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     ORDINAL_POSITION        POSITION_IN_UNIQUE_CONSTRAINT   REFERENCED_TABLE_SCHEMA REFERENCED_TABLE_NAME   REFERENCED_COLUMN_NAME
702
706
FROM information_schema.referential_constraints;
703
707
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG       UNIQUE_CONSTRAINT_SCHEMA        UNIQUE_CONSTRAINT_NAME  MATCH_OPTION    UPDATE_RULE     DELETE_RULE     TABLE_NAME      REFERENCED_TABLE_NAME
704
708
SELECT catalog_name, schema_name
705
 
FROM information_schema.schemata;
 
709
FROM information_schema.schemata
 
710
ORDER BY schema_name;
706
711
catalog_name    schema_name
707
712
NULL    information_schema
708
713
NULL    mysql
709
714
NULL    test
710
715
SELECT *
 
716
FROM information_schema.session_status
 
717
ORDER BY variable_name;
 
718
VARIABLE_NAME   VARIABLE_VALUE
 
719
#       #
 
720
#       #
 
721
#       #
 
722
#       #
 
723
#       #
 
724
#       #
 
725
#       #
 
726
#       #
 
727
#       #
 
728
#       #
 
729
#       #
 
730
#       #
 
731
#       #
 
732
#       #
 
733
#       #
 
734
#       #
 
735
#       #
 
736
#       #
 
737
#       #
 
738
#       #
 
739
#       #
 
740
#       #
 
741
#       #
 
742
#       #
 
743
#       #
 
744
#       #
 
745
#       #
 
746
#       #
 
747
#       #
 
748
#       #
 
749
#       #
 
750
#       #
 
751
#       #
 
752
#       #
 
753
#       #
 
754
#       #
 
755
#       #
 
756
#       #
 
757
#       #
 
758
#       #
 
759
#       #
 
760
#       #
 
761
#       #
 
762
#       #
 
763
#       #
 
764
#       #
 
765
#       #
 
766
#       #
 
767
#       #
 
768
#       #
 
769
#       #
 
770
#       #
 
771
#       #
 
772
#       #
 
773
#       #
 
774
#       #
 
775
#       #
 
776
#       #
 
777
#       #
 
778
#       #
 
779
#       #
 
780
#       #
 
781
#       #
 
782
#       #
 
783
#       #
 
784
#       #
 
785
#       #
 
786
#       #
 
787
#       #
 
788
#       #
 
789
#       #
 
790
#       #
 
791
#       #
 
792
#       #
 
793
#       #
 
794
#       #
 
795
#       #
 
796
#       #
 
797
#       #
 
798
#       #
 
799
#       #
 
800
#       #
 
801
#       #
 
802
#       #
 
803
#       #
 
804
#       #
 
805
#       #
 
806
#       #
 
807
#       #
 
808
#       #
 
809
#       #
 
810
#       #
 
811
#       #
 
812
#       #
 
813
#       #
 
814
#       #
 
815
#       #
 
816
#       #
 
817
#       #
 
818
#       #
 
819
#       #
 
820
#       #
 
821
#       #
 
822
#       #
 
823
#       #
 
824
#       #
 
825
#       #
 
826
#       #
 
827
SHOW STATUS;
 
828
Variable_name   Value
 
829
#       #
 
830
#       #
 
831
#       #
 
832
#       #
 
833
#       #
 
834
#       #
 
835
#       #
 
836
#       #
 
837
#       #
 
838
#       #
 
839
#       #
 
840
#       #
 
841
#       #
 
842
#       #
 
843
#       #
 
844
#       #
 
845
#       #
 
846
#       #
 
847
#       #
 
848
#       #
 
849
#       #
 
850
#       #
 
851
#       #
 
852
#       #
 
853
#       #
 
854
#       #
 
855
#       #
 
856
#       #
 
857
#       #
 
858
#       #
 
859
#       #
 
860
#       #
 
861
#       #
 
862
#       #
 
863
#       #
 
864
#       #
 
865
#       #
 
866
#       #
 
867
#       #
 
868
#       #
 
869
#       #
 
870
#       #
 
871
#       #
 
872
#       #
 
873
#       #
 
874
#       #
 
875
#       #
 
876
#       #
 
877
#       #
 
878
#       #
 
879
#       #
 
880
#       #
 
881
#       #
 
882
#       #
 
883
#       #
 
884
#       #
 
885
#       #
 
886
#       #
 
887
#       #
 
888
#       #
 
889
#       #
 
890
#       #
 
891
#       #
 
892
#       #
 
893
#       #
 
894
#       #
 
895
#       #
 
896
#       #
 
897
#       #
 
898
#       #
 
899
#       #
 
900
#       #
 
901
#       #
 
902
#       #
 
903
#       #
 
904
#       #
 
905
#       #
 
906
#       #
 
907
#       #
 
908
#       #
 
909
#       #
 
910
#       #
 
911
#       #
 
912
#       #
 
913
#       #
 
914
#       #
 
915
#       #
 
916
#       #
 
917
#       #
 
918
#       #
 
919
#       #
 
920
#       #
 
921
#       #
 
922
#       #
 
923
#       #
 
924
#       #
 
925
#       #
 
926
#       #
 
927
#       #
 
928
#       #
 
929
#       #
 
930
#       #
 
931
#       #
 
932
#       #
 
933
#       #
 
934
#       #
 
935
#       #
 
936
#       #
 
937
SELECT *
 
938
FROM information_schema.global_status
 
939
ORDER BY variable_name;
 
940
VARIABLE_NAME   VARIABLE_VALUE
 
941
#       #
 
942
#       #
 
943
#       #
 
944
#       #
 
945
#       #
 
946
#       #
 
947
#       #
 
948
#       #
 
949
#       #
 
950
#       #
 
951
#       #
 
952
#       #
 
953
#       #
 
954
#       #
 
955
#       #
 
956
#       #
 
957
#       #
 
958
#       #
 
959
#       #
 
960
#       #
 
961
#       #
 
962
#       #
 
963
#       #
 
964
#       #
 
965
#       #
 
966
#       #
 
967
#       #
 
968
#       #
 
969
#       #
 
970
#       #
 
971
#       #
 
972
#       #
 
973
#       #
 
974
#       #
 
975
#       #
 
976
#       #
 
977
#       #
 
978
#       #
 
979
#       #
 
980
#       #
 
981
#       #
 
982
#       #
 
983
#       #
 
984
#       #
 
985
#       #
 
986
#       #
 
987
#       #
 
988
#       #
 
989
#       #
 
990
#       #
 
991
#       #
 
992
#       #
 
993
#       #
 
994
#       #
 
995
#       #
 
996
#       #
 
997
#       #
 
998
#       #
 
999
#       #
 
1000
#       #
 
1001
#       #
 
1002
#       #
 
1003
#       #
 
1004
#       #
 
1005
#       #
 
1006
#       #
 
1007
#       #
 
1008
#       #
 
1009
#       #
 
1010
#       #
 
1011
#       #
 
1012
#       #
 
1013
#       #
 
1014
#       #
 
1015
#       #
 
1016
#       #
 
1017
#       #
 
1018
#       #
 
1019
#       #
 
1020
#       #
 
1021
#       #
 
1022
#       #
 
1023
#       #
 
1024
#       #
 
1025
#       #
 
1026
#       #
 
1027
#       #
 
1028
#       #
 
1029
#       #
 
1030
#       #
 
1031
#       #
 
1032
#       #
 
1033
#       #
 
1034
#       #
 
1035
#       #
 
1036
#       #
 
1037
#       #
 
1038
#       #
 
1039
#       #
 
1040
#       #
 
1041
#       #
 
1042
#       #
 
1043
#       #
 
1044
#       #
 
1045
#       #
 
1046
#       #
 
1047
#       #
 
1048
#       #
 
1049
SELECT *
711
1050
FROM information_schema.table_constraints;
712
1051
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME TABLE_SCHEMA    TABLE_NAME      CONSTRAINT_TYPE
713
1052
SELECT table_schema, table_name
714
 
FROM information_schema.tables;
 
1053
FROM information_schema.tables
 
1054
ORDER BY table_name;
715
1055
table_schema    table_name
 
1056
information_schema      CHARACTER_SETS
 
1057
information_schema      COLLATIONS
 
1058
information_schema      COLLATION_CHARACTER_SET_APPLICABILITY
 
1059
information_schema      COLUMNS
716
1060
information_schema      GLOBAL_STATUS
717
1061
information_schema      GLOBAL_VARIABLES
718
 
information_schema      SESSION_STATUS
719
 
information_schema      SESSION_VARIABLES
720
 
information_schema      INNODB_TRX
721
 
information_schema      INNODB_LOCKS
722
 
information_schema      INNODB_LOCK_WAITS
723
1062
information_schema      INNODB_CMP
724
 
information_schema      INNODB_CMP_RESET
725
1063
information_schema      INNODB_CMPMEM
726
1064
information_schema      INNODB_CMPMEM_RESET
727
 
information_schema      CHARACTER_SETS
728
 
information_schema      COLLATIONS
729
 
information_schema      COLLATION_CHARACTER_SET_APPLICABILITY
730
 
information_schema      COLUMNS
 
1065
information_schema      INNODB_CMP_RESET
 
1066
information_schema      INNODB_LOCKS
 
1067
information_schema      INNODB_LOCK_WAITS
 
1068
information_schema      INNODB_TRX
731
1069
information_schema      KEY_COLUMN_USAGE
732
1070
information_schema      PLUGINS
733
1071
information_schema      PROCESSLIST
734
1072
information_schema      REFERENTIAL_CONSTRAINTS
735
1073
information_schema      SCHEMATA
 
1074
information_schema      SESSION_STATUS
 
1075
information_schema      SESSION_VARIABLES
736
1076
information_schema      STATISTICS
 
1077
information_schema      TABLES
737
1078
information_schema      TABLE_CONSTRAINTS
738
 
information_schema      TABLES