PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
TABLE_SCHEMA The name of the schema (database) to which the table containing the column belongs. The following statements are nearly equivalent: SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE ...The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
EVENT_SCHEMA The name of the schema (database) to which the event belongs. The following statements are equivalent: SELECT EVENT_SCHEMA, EVENT_NAME, DEFINER, TIME_ZONE, EVENT_TYPE, EXECUTE_AT, INTERVAL_VALUE, INTERVAL_FIELD, STARTS, ENDS, STATUS, ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-table.html
Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including data types and default values. For usage information, see Section 14.9.1.4, “Monitoring InnoDB Table ... The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmpmem-table.html
Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including data types and default values. For usage information, see Section 14.9.1.4, “Monitoring InnoDB Table ... The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information on compressed pages within the InnoDB buffer ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-table.html
For related usage information and examples, see Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”. The INNODB_SYS_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
For related usage information and examples, see Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”. NAME The name of the table, preceded by the schema (database) name where appropriate (for example, test/t1). Example mysql> SELECT * FROM ... The INNODB_SYS_TABLES table provides metadata about InnoDB tables, equivalent to the information from the SYS_TABLES table in the InnoDB data ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablespaces-table.html
For related usage information and examples, see Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”. Note The INFORMATION_SCHEMA FILES table reports metadata for all InnoDB tablespace types including file-per-table tablespaces, general ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-parameters-table.html
SPECIFIC_SCHEMA The name of the schema (database) to which the routine containing the parameter belongs. The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-partitions-table.html
TABLE_SCHEMA The name of the schema (database) to which the table belongs. Each row in this table corresponds to an individual partition or subpartition of a partitioned table. The PARTITIONS table has these columns: TABLE_CATALOG The name of the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-processlist-table.html
This is the same value displayed in the Id column of the SHOW PROCESSLIST statement, displayed in the PROCESSLIST_ID column of the Performance Schema threads table, and returned by the CONNECTION_ID() function within the thread. The following ...