PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
Each of those functions, if successful, returns a binary string indicating what action occurred. The SUPER privilege is required to call any of the Version Token functions, so token list modification is expected to be done by a management or ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
SQL:1999 and later permits such nonaggregates per optional feature T301 if they are functionally dependent on GROUP BY columns: If such a relationship exists between name and custid, the query is legal. If the ONLY_FULL_GROUP_BY SQL mode is enabled ... SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-service.html
Keyring service functions treat key IDs, user names, types, and values as binary strings, so comparisons are case-sensitive. The function stores into it a pointer to a null-terminated string that provides additional information about the key (stored ...MySQL distributions provide a keyring interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
To clear the SQL mode explicitly, set it to an empty string using --sql-mode="" on the command line, or sql-mode="" in an option file. ANSI_QUOTES Treat " as an identifier quote character (like the ` quote character) and not as a string quote ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
CHARACTER_MAXIMUM_LENGTH For stored function string return values, the maximum length in characters. CHARACTER_OCTET_LENGTH For stored function string return values, the maximum length in bytes. CHARACTER_SET_NAME For stored function character ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
An API provides a stable set of names and types for functions, procedures, parameters, and return values. client libraries Files containing collections of functions for working with databases. client-side prepared statement A type of prepared ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
Columns retrieved by the SELECT statement can be simple references to table columns, or expressions that use functions, constant values, operators, and so forth. Within a view definition, the CURRENT_USER function returns the view's DEFINER value by ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
--allow-suspicious-udfs Command-Line Format --allow-suspicious-udfs[={OFF|ON}] Type Boolean Default Value OFF This option controls whether loadable functions that have only an xxx symbol for the main function can be loaded. By default, the option is ... When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-aws-plugin.html
The plugin library file contains the keyring_aws plugin and two loadable functions, keyring_aws_rotate_cmk() and keyring_aws_rotate_keys(). Start the MySQL server and install the functions associated with the keyring_aws plugin. This is a one-time ... Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
Prefix lengths are given in characters for nonbinary string types and in bytes for binary string types. To retrieve an AUTO_INCREMENT value after inserting a row, use the LAST_INSERT_ID() SQL function or the mysql_insert_id() C API function. | ...