MySQL Tutorial Data Dictionary 37 codes

  1. Home
  2. MySQL Tutorial
  3. Data Dictionary
1 A bit about the mysql database
2 Check information_schema routines
3 Db table structure
4 Func table
5 Help_category
6 Help_keyword
7 Help_relation
8 Help_topic
9 Host
10 Information_schema triggers
11 MySQL permissions are stored in corresponding tables
12 Proc
13 Procs_priv
14 The INFORMATION_SCHEMA CHARACTER_SETS Table
15 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
16 The INFORMATION_SCHEMA COLLATIONS Table
17 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
18 The INFORMATION_SCHEMA COLUMNS Table
19 The INFORMATION_SCHEMA Database
20 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
21 The INFORMATION_SCHEMA PROFILING Table
22 The INFORMATION_SCHEMA ROUTINES Table
23 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
24 The INFORMATION_SCHEMA SCHEMATA Table
25 The INFORMATION_SCHEMA STATISTICS Table
26 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
27 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
28 The INFORMATION_SCHEMA TABLES Table
29 The INFORMATION_SCHEMA TRIGGERS Table
30 The INFORMATION_SCHEMA USER_PRIVILEGES Table
31 The INFORMATION_SCHEMA VIEWS Table
32 Time_zone
33 Time_zone_leap_second
34 Time_zone_name
35 Time_zone_transition
36 Time_zone_transition_type
37 User table structure