PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/declare-local-variable.html
To provide a default value for a variable, include a DEFAULT clause. Permissible characters and quoting rules are the same as for other identifiers, as described in Section 9.2, “Schema Object Names”. For examples of variable declarations, see ...type [DEFAULT value] This statement declares local variables within stored ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-shell-install.html
This section describes how to download, install, and start MySQL Shell, which is an interactive JavaScript, Python, or SQL interface supporting development and administration for the MySQL Server. Requirements MySQL Shell is available on Microsoft ...
https://dev.mysql.com/doc/refman/5.7/en/drop-function.html
The DROP FUNCTION statement is used to drop stored functions and loadable functions: For information about dropping stored functions, see Section 13.1.27, “DROP PROCEDURE and DROP FUNCTION Statements”. For information about dropping loadable ...
https://dev.mysql.com/doc/refman/5.7/en/drop-procedure.html
(DROP FUNCTION is also used to drop loadable functions; see Section 13.7.3.2, “DROP FUNCTION Statement for Loadable Functions”.) To drop a stored routine, you must have the ALTER ROUTINE privilege for it. DROP FUNCTION is also used to drop ...
https://dev.mysql.com/doc/refman/5.7/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. Note The syntax of the CASE operator described here differs slightly from that of the SQL CASE statement described in Section 13.6.5.1, “CASE Statement”, for use inside ...If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE ...
https://dev.mysql.com/doc/refman/5.7/en/flow-control-statements.html
MySQL supports the IF, CASE, ITERATE, LEAVE LOOP, WHILE, and REPEAT constructs for flow control within stored programs. For example, an IF statement might contain a WHILE loop, which itself contains a CASE statement. Many of these constructs ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-in-single-primary-mode.html
See Section 17.2.2, “Deploying Group Replication Locally” for information about deploying multiple MySQL server instances running Group Replication on the same host machine, for example for testing purposes. Figure 17.4 Group Architecture This ... Each of the MySQL server instances in a group can run on an independent physical host machine, which is the recommended way to deploy Group ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-distributed-recovery-basics.html
The server joining the group transfers all the transactions that took place in the group before it joined, which are provided by the existing member (called the donor). The donor is responsible for providing the server joining the group all the data ... Whenever a member joins a replication group, it connects to an existing member to carry out state ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-firewall-table-reference.html
Table 24.10 INFORMATION_SCHEMA Firewall Tables Table Name Description MYSQL_FIREWALL_USERS Firewall in-memory data for account profiles MYSQL_FIREWALL_WHITELIST Firewall in-memory data for account profile allowlists .
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-lock-waits-table.html
The INNODB_LOCK_WAITS table contains one or more rows for each blocked InnoDB transaction, indicating the lock it has requested and any locks that are blocking that request. REQUESTED_LOCK_ID The ID of the lock for which a transaction is waiting.