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/query-cache-operation.html
In addition, query strings that are identical may be treated as different for other reasons. Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. This section describes how the query cache works when it is operational. Section 8.10.3.3, “Query Cache Configuration”, describes how to control whether it is ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html
The following is an example of a function that takes a parameter, performs an operation using an SQL function, and returns the result. Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html
When validate_password_check_user_name is enabled, it has these effects: Checking occurs in all contexts for which validate_password is invoked, which includes use of statements such as ALTER USER or SET PASSWORD to change the current user's ...
https://dev.mysql.com/doc/refman/5.7/en/error-interfaces.html
Regardless of whether an error originates from within the client library or is received from the server, a MySQL client program obtains the error code, SQLSTATE value, message string, and other related information by calling C API functions in the ... Error messages can originate on the server side or the client side, and each error message includes an error code, SQLSTATE value, and message string, as described in Section B.1, “Error Message Sources and ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
To extract the user name or host name part from a CURRENT_USER() or USER() value, use the SUBSTRING_INDEX() function: mysql> SELECT SUBSTRING_INDEX(CURRENT_USER(),'@',1); +---------------------------------------+ | ...Normally, the CURRENT_USER() ...
https://dev.mysql.com/doc/refman/5.7/en/correlated-subqueries.html
Aggregate functions in correlated subqueries may contain outer references, provided the function contains nothing but outer references, and provided the function is not contained in another function or expression. A correlated subquery is a ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
This can occur if the outer query accesses any tables and an inner query invokes a stored function that changes one or more rows of a table. A derived table is an expression that generates a table within the scope of a query FROM clause. For ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption.html
MySQL Enterprise Edition includes a set of encryption functions based on the OpenSSL library that expose OpenSSL capabilities at the SQL level. MySQL Enterprise Encryption is supplied as a library of loadable functions, from which individual ...
https://dev.mysql.com/doc/refman/5.7/en/if.html
Note There is also an IF() function, which differs from the IF statement described here. [ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. The IF statement can have THEN, ELSE, and ELSEIF ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-key-types.html
The permitted key lengths are subject to multiple factors: General keyring loadable-function interface limits (for keys managed using one of the keyring functions described in Section 6.4.4.8, “General-Purpose Keyring Key-Management Functions”), ... MySQL Keyring supports keys of different types (encryption algorithms) and lengths: The available key types depend on which keyring plugin is ...