PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/locale-support.html
This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names value does not affect the result from FORMAT(), but this function takes an optional third parameter that enables a locale to be ... The ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
LIKE, CREATE VIEW, DROP VIEW, and DDL statements on stored functions and procedures and events. You can avoid using LOCK TABLES in many cases by using relative updates (UPDATE customer SET value=value+new_value) or the LAST_INSERT_ID() function. You ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...