465
465
FROM information_schema.processlist
466
466
WHERE id = CONNECTION_ID() Query test
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
470
472
utf8 utf8_general_ci UTF-8 Unicode 4
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
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
508
utf8_esperanto_ci utf8
509
utf8_estonian_ci utf8
501
510
utf8_general_ci utf8
511
utf8_hungarian_ci utf8
504
512
utf8_icelandic_ci utf8
505
513
utf8_latvian_ci utf8
514
utf8_lithuanian_ci utf8
506
517
utf8_romanian_ci utf8
507
521
utf8_slovenian_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
515
utf8_lithuanian_ci utf8
517
utf8_spanish2_ci utf8
520
utf8_esperanto_ci utf8
521
utf8_hungarian_ci utf8
524
527
SELECT table_name, column_name
525
FROM information_schema.columns;
528
FROM information_schema.columns
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
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
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
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
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
540
COLLATIONS DESCRIPTION
541
COLLATIONS CHARACTER_SET_NAME
591
542
COLLATION_CHARACTER_SET_APPLICABILITY CHARACTER_SET_NAME
543
COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME
592
547
COLUMNS TABLE_CATALOG
595
548
COLUMNS COLUMN_NAME
596
549
COLUMNS ORDINAL_POSITION
597
550
COLUMNS COLUMN_DEFAULT
598
551
COLUMNS IS_NULLABLE
600
COLUMNS CHARACTER_MAXIMUM_LENGTH
601
COLUMNS CHARACTER_OCTET_LENGTH
602
COLUMNS NUMERIC_PRECISION
603
COLUMNS NUMERIC_SCALE
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
610
COLUMNS COLUMN_COMMENT
560
COLUMNS NUMERIC_SCALE
561
COLUMNS NUMERIC_PRECISION
562
COLUMNS CHARACTER_OCTET_LENGTH
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
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
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
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
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_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
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
651
SCHEMATA DEFAULT_COLLATION_NAME
652
SCHEMATA DEFAULT_CHARACTER_SET_NAME
650
654
SCHEMATA CATALOG_NAME
652
SCHEMATA DEFAULT_CHARACTER_SET_NAME
653
SCHEMATA DEFAULT_COLLATION_NAME
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
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
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
716
FROM information_schema.session_status
717
ORDER BY variable_name;
718
VARIABLE_NAME VARIABLE_VALUE
938
FROM information_schema.global_status
939
ORDER BY variable_name;
940
VARIABLE_NAME VARIABLE_VALUE
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