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/ansi-diff-foreign-keys.html
If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it has previously updated during the same cascade, it acts like RESTRICT. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE SET NULL operations. A self-referential ON DELETE SET NULL, on the other hand, is possible, as is a self-referential ON DELETE ...For example, if you define a RESTRICT type constraint, ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimization.html
row *************************** id: 1 select_type: SIMPLE table: VIEWS type: ALL possible_keys: NULL key: TABLE_SCHEMA,TABLE_NAME key_len: NULL ref: NULL rows: NULL Extra: Using where; Open_frm_only; Scanned 0 databases Use of constant database and ... Applications that monitor databases may make frequent use of INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
The result value is 0, or NULL for inappropriate arguments such as a NULL or negative repeat count. mysql> SELECT CHARSET('abc'); -> 'latin1' mysql> SELECT CHARSET(CONVERT('abc' USING utf8)); -> 'utf8' mysql> SELECT CHARSET(USER()); -> 'utf8' ...It ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-functions.html
Return value: The masked string, or NULL if either margin is negative. Return value: The masked string, or NULL if either margin is negative. Return value: The masked Social Security number as a string, or NULL if the argument is not the correct ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
In addition, for a non-transactional update, if a disk write failure occurs while attempting to write to the binary log cache and a gap is therefore created in the binary log, the resulting incident log event is assigned a GTID. When you issue RESET ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the replication source ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
GROUP_CONCAT(expr) This function returns a string result with the concatenated non-NULL values from a group. For information about a change in MySQL 8.0 that permits bit operations to take binary string type arguments (BINARY, VARBINARY, and the ...
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 System Variable authentication_ldap_sasl_bind_base_dn Scope Global Dynamic Yes Type String Default Value NULL For SASL LDAP authentication, the ...These variables can be set to override the default OpenLDAP TLS configuration; see LDAP Pluggable Authentication and ldap.conf authentication_ldap_sasl_group_search_attr Command-Line Format --authentication-ldap-sasl-group-search-attr=value System Variable authentication_ldap_sasl_group_search_attr Scope Global Dynamic Yes Type String Default Value cn For SASL LDAP authentication, the name of the attribute that specifies group names in LDAP directory ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-worker.html
On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator and replication_applier_status_by_worker show status information for the replica's coordinator thread and applier worker threads respectively. For a ...
https://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html
XA transaction support is limited to the InnoDB storage engine. For “external XA,” a MySQL server acts as a Resource Manager and client programs act as Transaction Managers. For “Internal XA”, storage engines within a MySQL server act as ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...