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/numeric-functions.html
Table 12.8 Numeric Functions and Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator ABS() Return the absolute value ACOS() Return ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-functions.html
The following sections describe sys schema stored functions. ...
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/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/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. | ...
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/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/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/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 ...