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/replace-utility.html
The replace utility program changes strings in place in files or on the standard input. < file_name from represents a string to look for and to represents its replacement. Use the -- option to indicate where the string-replacement list ends and the ...Note The replace utility is deprecated as of MySQL 5.7.18 and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-character.html
For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when you do not need language-specific collation features. When comparing values from different columns, declare those ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
For information about a change in MySQL 8.0 that permits bit operations to take binary string type arguments (BINARY, VARBINARY, and the BLOB types), see Section 12.12, “Bit Functions and Operators”. GROUP_CONCAT(expr) This function returns a ...
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/gtid-functions.html
It is important to keep in mind that all of these functions take string representations of GTID sets as arguments. The GTID sets used with this function are represented as strings, as shown in the following examples: mysql> SELECT ... The functions ...As such, the GTID sets must always be quoted when used with ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
(For strings in the ascii or utf8 character sets, no conversion is needed because ascii and utf8 are subsets of utf8mb4.) As an alternative to writing JSON values using literal strings, functions exist for composing JSON values from component ...The ...JSON documents stored in JSON columns are converted to an internal format that permits quick read access to document ...
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/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/data-masking-installation.html
This section describes how to install or uninstall MySQL Enterprise Data Masking and De-Identification, which is implemented as a plugin library file containing a plugin and several loadable functions. For general information about installing or ...
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 ...