PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Thus column names, database names, user names, version names, and most of the string results from SHOW are metadata. The metadata requirements mean that the return values of the USER(), CURRENT_USER(), SESSION_USER(), SYSTEM_USER(), DATABASE(), and ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
-DWITH_ZLIB=zlib_type Some features require that the server be built with compression library support, such as the COMPRESS() and UNCOMPRESS() functions, and compression of the client/server protocol. The CMake program provides a great deal of ...
https://dev.mysql.com/doc/refman/5.7/en/multibyte-characters.html
If you want to add support for a new character set named MYSET that includes multibyte characters, you must use multibyte character functions in the ctype-MYSET.c source file in the strings directory. The existing character sets provide the best ...
https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html
If the older ext/mysql extension must be used, then for escaping use the mysql_real_escape_string_quote() function and not mysql_escape_string() or addslashes() because only mysql_real_escape_string_quote() is character set-aware; the other ...If ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-legacy-filtering.html
As of MySQL 5.7.13, if the audit_log plugin is installed without the accompanying audit tables and functions needed for rule-based filtering. The value for either variable can be NULL or a string containing one or more comma-separated account names, ... Note This section describes legacy audit log filtering, which applies under either of these circumstances: Before MySQL 5.7.13, that is, prior to the introduction of rule-based audit log filtering described in Section 6.4.5.7, “Audit Log ...
https://dev.mysql.com/doc/refman/5.7/en/engine-condition-pushdown-optimization.html
A string value to be compared with a column must use the same collation as the column. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to ...
https://dev.mysql.com/doc/refman/5.7/en/explain.html
In this case, the statement displays output only for the columns with names matching the string. There is no need to enclose the string within quotation marks unless it contains spaces or other special characters. You should be aware that while this ...In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html
InnoDB can handle composing and decomposing multiple column values into a single memcached item value, reducing the amount of string parsing and concatenation required in your application. For example, you can store the string value 2|4|6|8 in the ...The combination of InnoDB tables and memcached offers advantages over using either by ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
For column values calculated as a result of string expressions (such as those that invoke a string-valued function), the filesort algorithm cannot tell the maximum length of expression values, so it must allocate max_sort_length bytes for each tuple. For example, if tuples store values of long string columns and you increase the value of max_sort_length, the size of sort buffer tuples increases as well and may require you to increase ... This section describes ...
https://dev.mysql.com/doc/refman/5.7/en/year.html
YEAR accepts input values in a variety of formats: As 4-digit strings in the range '1901' to '2155'. As 1- or 2-digit strings in the range '0' to '99'. To insert zero and have it be interpreted as 2000, specify it as a string '0' or '00'. As the ...