PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. SQL pattern matching enables you to use _ to match any ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connection-protocols-ciphers.html
MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to permit for encrypted connections. It is also possible to determine which protocol and cipher the current session uses. Supported Connection ...
https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-authentication.html
Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. As of MySQL 5.7.19, MySQL Enterprise Edition supports an authentication method that enables MySQL Server to use LDAP (Lightweight ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html
To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or (from MySQL 5.7.32) TRUNCATE TABLE statement ... When a replication source server shuts down and restarts, its MEMORY tables become ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers (GTIDs). For additional information, see Section 16.1.3, “Replication with Global Transaction Identifiers”.
https://dev.mysql.com/doc/refman/5.7/en/reset-master.html
RESET MASTER Warning Use this statement with caution to ensure you do not lose any wanted binary log file data and GTID execution history. For a server where binary logging is enabled (log_bin is ON), RESET MASTER deletes all existing binary log ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
The MySQL server maintains many status variables that provide information about its operation. You can view these variables and their values by using the SHOW [GLOBAL | SESSION] STATUS statement (see Section 13.7.5.35, “SHOW STATUS Statement”).
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second support. For information about time zone ...
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 ...