PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-options-gtids.html
When binlog_gtid_simple_recovery=TRUE (the default), the values of gtid_executed and gtid_purged are computed at startup based on the values of Previous_gtids_log_event in the most recent and oldest binary log files. If all binary logs on the server ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/9.7/en/set-operations.html
In other words, all of the following statements are true: TABLE x UNION TABLE y and TABLE y UNION TABLE x produce the same result, although the ordering of the rows may differ. Result Set Column Names and Data Types Set Operations with TABLE and ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-trace-thread.html
Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...
https://dev.mysql.com/doc/refman/9.7/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. It also prevents updates to rows for which the WHERE clause is true but the update would ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-installation.html
Note The Audit Log component is intended to replace the Audit Log plugin, which is now deprecated. This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log component and related elements ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-installation.html
Important The audit_log plugin is deprecated, and is being replaced by the audit_log component. Deprecation of the plugin means that you should expect the plugin to be removed in a future version of MySQL. For more information about the audit log ...
https://dev.mysql.com/doc/refman/9.7/en/cast-functions.html
Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values ...
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per ...
https://dev.mysql.com/doc/refman/9.7/en/correlated-subqueries.html
WHERE column1 = ANY (SELECT column1 FROM t2) would be TRUE, but in this example, the WHERE clause within the subquery is FALSE (because (5,6) is not equal to (5,7)), so the expression as a whole is FALSE. A correlated subquery is a subquery that ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-component-function-reference.html
Table 8.56 MySQL Enterprise Data Masking Component Functions Name Description current_role_in() Returns true if any active role matches an authorization ID in the list current_user_in() Returns true if the current user matches an authorization ID ...