PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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. Note A user variable used to ...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/pluggable-authentication-system-variables.html
authentication_ldap_sasl_bind_base_dn Command-Line Format --authentication-ldap-sasl-bind-base-dn=value Introduced 5.7.19 System Variable authentication_ldap_sasl_bind_base_dn Scope Global Dynamic Yes Type String Default Value NULL For SASL LDAP ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-reference.html
| +------------------------------------+ An argument of NULL is treated as an empty string, which has no effect on the token list. (It is not an error to delete nonexisting tokens.) To clear the token list entirely without knowing which tokens are ...version_tokens_delete(name_list) Deletes tokens from the server's list of version tokens using the name_list argument and returns a binary string that indicates the outcome of the ... The following discussion serves as a ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-legacy-filtering.html
The value for either variable can be NULL or a string containing one or more comma-separated account names, each in user_name@host_name format. By default, both variables are NULL, in which case, no account filtering is done and auditing occurs for ... 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/partitioning-limitations.html
However, the result must be an integer value or NULL (except in the case of [LINEAR] KEY partitioning, as discussed elsewhere in this chapter; see Section 22.2, “Partitioning Types”, for more information). A partitioning key may not be a ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
Given this statement: CREATE TABLE t AS SELECT INET6_NTOA(expr) AS c1; The resulting table would have this definition: CREATE TABLE t (c1 VARCHAR(39) CHARACTER SET utf8 DEFAULT NULL); The return string uses lowercase letters for IPv6 addresses. The ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
Important Invalid DATE and DATETIME values referenced in the WHERE condition of a statement against a partitioned table are treated as NULL. The core concept behind partition pruning is relatively simple, and can be described as “Do not scan ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
If in_table is NULL and no snapshot exists, a new snapshot is created. Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
--debug[=debug_options], -# [debug_options] Command-Line Format --debug[=debug_options] System Variable debug Scope Global, Session Dynamic Yes Type String Default Value (Unix) d:t:i:o,/tmp/mysqld.trace Default Value (Windows) d:t:i:O,\mysqld.trace ... 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/innodb-auto-increment-handling.html
An example follows, where c1 is an AUTO_INCREMENT column of table t1: INSERT INTO t1 (c1,c2) VALUES (1,'a'), (NULL,'b'), (5,'c'), (NULL,'d'); Another type of “mixed-mode insert” is INSERT ... To make this clear, consider an example that uses ...