VIEWS table: gives information about the views in the database. The column named "mysql.proc name" specifies the mysql.proc table column corresponding to the INFORMATION_SCHEMA.ROUTINES table. At this point, the ROUTINES table does not contain custom functions (UDFs). ROUTINES table: provides information about stored subroutines (stored procedures and functions). KEY_COLUMN_USAGE table: describes the key columns with constraints. TABLE_CONSTRAINTS table: describes the table with constraints. These columns are equivalent to the first two display fields of SHOW COLLATION. This table is taken from the SHOW CHARACTER SET result set.ĬOLLATIONS table: Provides comparison information about each character set.ĬOLLATION_CHARACTER_SET_APPLICABILITY table: indicates the character set that can be used for proofreading. is a non-standard table.ĬHARACTER_SETS (character set) table: provides information on the character sets available to the mysql instance. This information is derived from the lumns_priv grant table. is a non-standard table.ĬOLUMN_PRIVILEGES (column privileges) table: gives information about column privileges. This information is derived from the mysql.tables_priv grant table. TABLE_PRIVILEGES (table privileges) table: gives information about table privileges. This information comes from the mysql.db grant table. SCHEMA_PRIVILEGES (schema permissions) table: gives information about schema (database) permissions. This information is derived from the er grant table.
#Mysql data dictionary for mac full#
USER_PRIVILEGES (user privileges) table: gives information about the full privileges.
This table is taken from the result of show index from schemaname.tablename. STATISTICS table: Provides information about table indexes. This table is taken from the result of show columns from schemaname.tablename. Describes all the columns of a table and the information about each column in detail.
This table is taken from the result of show tables from schemaname.ĬOLUMNS table: provides column information in the table. Describes in detail which schema a table belongs to, table type, table engine, creation time and other information. TABLES TABLES: Provides information (including views) about tables in the database. This table is taken from the result of show databases. SCHEMATA table: Provides information about all databases in the current mysql instance. Information_schema database table description: They are actually views, not base tables, so you won't be able to see any files related to them. In INFORMATION_SCHEMA, there are several read-only tables. Such as database name, database table, table column data type and access rights.
It holds information about all other databases maintained by the MySQL server. In MySQL, the information_schema is regarded as a database, to be precise, an information database. Other terms sometimes used to describe this information include "data dictionary" and "system catalog". What is metadata? Metadata is data about data, such as database or table names, data types of columns, or access rights, etc. The information_schema database comes with MySQL and provides a way to access database metadata. What is the information_schema database for? Friends who use WordPress blogs may wonder, is it the database added by the installation template? After reading this article, you will have an understanding of the information_schema database.
#Mysql data dictionary for mac install#
When you install or use MYSQL, you will find that in addition to the database installed by yourself, there is also an information_schema database.
0 kommentar(er)
