PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.4Kb
Man Pages (Zip)
- 360.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
However, if logging occurs at the statement level, there are certain binary logging issues with respect to stored programs (stored procedures and functions, triggers, and events): In some cases, a statement might affect different sets of rows on ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); -> 32 This function is safe to use with BIGINT values. The inverse of this function is LOG() (using a single argument only) or LN(). HEX(N_or_S) This function can be used to obtain a hexadecimal ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
Memory structures already allocated are reused, and runtime optimizations such as local caching of results already evaluated for aggregate functions can alter the results. mysql> SELECT CONNECTION_ID(); -> 23786 Warning Changing the session value of ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/refman/5.7/en/gtid-functions.html
The functions described in this section are used with GTID-based replication. It is important to keep in mind that all of these functions take string representations of GTID sets as arguments. Table 12.24 GTID Functions Name Description ...As such, ...
https://dev.mysql.com/doc/refman/5.7/en/server-loadable-functions.html
MySQL supports loadable functions, that is, functions that are not built in but can be loaded at runtime (either during startup or later) to extend server capabilities, or unloaded to remove capabilities. For a table describing the available ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
This section describes aggregate functions that operate on sets of values. If you use an aggregate function in a statement containing no GROUP BY clause, it is equivalent to grouping on all rows. For numeric arguments, the variance and standard ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-functions.html
If a MySQL Enterprise Data Masking and De-Identification function is invoked from within the mysql client, binary string results display using hexadecimal notation, depending on the value of the --binary-as-hex. Data Masking Functions Each function ...If a string return value should be in a different character set, convert ...
https://dev.mysql.com/doc/refman/5.7/en/xml-functions.html
Table 12.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Two functions providing basic ...Note It is possible to obtain XML-formatted output from MySQL in the mysql and mysqldump clients by invoking them with the --xml ...
https://dev.mysql.com/doc/refman/5.7/en/functions.html
Expressions can be written using values from several sources, such as literal values, column values, NULL, variables, built-in functions and operators, loadable functions, and stored functions (a type of stored object). This chapter describes the ...