PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/error-message-language.html
By default, mysqld produces error messages in English, but they can be displayed instead in any of several other languages: Czech, Danish, Dutch, Estonian, French, German, Greek, Hungarian, Italian, Japanese, Korean, Norwegian, Norwegian-ny, ...
https://dev.mysql.com/doc/refman/5.7/en/events-syntax.html
MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. The definition of an existing event can be changed by means of the ALTER EVENT statement. When a scheduled event is no ...
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-row.html
Task: Find the number, dealer, and price of the most expensive article.
https://dev.mysql.com/doc/refman/5.7/en/expired-password-handling.html
MySQL provides password-expiration capability, which enables database administrators to require that users reset their password. Passwords can be expired manually, and on the basis of a policy for automatic expiration (see Section 6.2.11, ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ... ] HANDLER tbl_name READ index_name { FIRST | NEXT | PREV | LAST } [ WHERE where_condition ] [LIMIT ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-mapping.html
There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each database as a directory in the data directory, and each table by one or more files in the appropriate ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 23.4, “Using the Event Scheduler”. The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
The INNODB_SYS_TABLES table provides metadata about InnoDB tables, equivalent to the information from the SYS_TABLES table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, “InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablestats-table.html
The INNODB_SYS_TABLESTATS table provides a view of low-level status information about InnoDB tables. This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. This information is derived from in-memory ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-key-column-usage-table.html
The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. TABLE_CATALOG The name of the catalog to ...