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/communication-errors.html
The host cache, which is accessible using the Performance Schema host_cache table. If connection problems occur such as communication errors or aborted connections, use these sources of information to diagnose problems: The error log. See Section ...
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM ... This section ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
You can obtain information about foreign keys from the Information Schema KEY_COLUMN_USAGE table. Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL supports ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
row *************************** Table: child Create Table: CREATE TABLE `child` ( `id` int(11) DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, KEY `par_ind` (`parent_id`), CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` ...
https://dev.mysql.com/doc/refman/5.7/en/create-temporary-table.html
You can use the TEMPORARY keyword when creating a table. A TEMPORARY table is visible only within the current session, and is dropped automatically when the session is closed. This means that two different sessions can use the same temporary table ...
https://dev.mysql.com/doc/refman/5.7/en/declare-local-variable.html
Permissible characters and quoting rules are the same as for other identifiers, as described in Section 9.2, “Schema Object Names”. type [DEFAULT value] This statement declares local variables within stored programs. To provide a default value ...
https://dev.mysql.com/doc/refman/5.7/en/drop-event.html
This statement requires the EVENT privilege for the schema to which the event to be dropped belongs. DROP EVENT [IF EXISTS] event_name This statement drops the event named event_name. The event immediately ceases being active, and is deleted ...
https://dev.mysql.com/doc/refman/5.7/en/events-metadata.html
These times can also be obtained by selecting from the Information Schema EVENTS table or from SHOW EVENTS, but they are reported as ETZ values. To obtain metadata about events: Query the event table of the mysql database. Event Scheduler Time ...
https://dev.mysql.com/doc/refman/5.7/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
These distributed algorithms and protocols include global checkpointing, DDL (schema) changes, and node restart handling. In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage engine. Which ...