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/json-utility-functions.html
An error results when json_val is not NULL, and is not—or cannot be successfully parsed as—a JSON document. This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
MySQL supports the following static probes, organized into groups of functionality. To identify each argument within the definitions they are provided with a descriptive name, but you must access the information using the corresponding argN ...
https://dev.mysql.com/doc/refman/5.7/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool.html
The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. The buffer pool permits frequently used data to be accessed directly from memory, which speeds up processing. On dedicated servers, up to 80% of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-monitoring.html
Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be loaded. Performance_schema_xxx_instances_lost indicates how many instances of object type xxx could not be ...
https://dev.mysql.com/doc/refman/5.7/en/charset-literal.html
Every character string literal has a character set and a collation. For the simple statement SELECT 'string', the string has the connection default character set and collation defined by the character_set_connection and collation_connection system ...
https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions-charset.html
MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's ...
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. Note The replace utility is deprecated as of MySQL 5.7.18 and is removed in MySQL 8.0. Invoke replace in one of the following ways: replace from to [from to] ... < file_name from represents a string to look for and to represents its ...
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. You can use the BINARY operator to use binary collation within ...