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/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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-plugin-installation.html
If you intend to use keyring functions in conjunction with the chosen keyring plugin, install the functions after installing that plugin, using the instructions in Section 6.4.4.8, “General-Purpose Keyring Key-Management Functions”. As a result, ... Keyring service consumers require that a keyring plugin be ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-example.html
* * In your $HOME/.my.cnf file, you probably want to put: [test2_libmysqld_SERVER] language = /path/to/source/of/mysql/sql/share/english * You could, of course, modify argc and argv before passing * them to this function. * * If you link this client ... These two example programs should work without any changes on a Linux or FreeBSD ...