PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-collate.html
With the COLLATE clause, you can override whatever the default collation is for a comparison.
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-implementations.html
mysql> SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'; Query OK, 0 rows affected (0.05 sec) mysql> SELECT HEX('a'), HEX(WEIGHT_STRING('a')); +----------+-------------------------+ | HEX('a') | HEX(WEIGHT_STRING('a')) | ... MySQL implements several types ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-information-schema.html
For example, comparisons with SCHEMATA.SCHEMA_NAME match 'information_schema' or 'INFORMATION_SCHEMA' regardless of platform: mysql> SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'information_schema'; +--------------------+ ... String columns in INFORMATION_SCHEMA tables have a collation of utf8_general_ci, which is ...
https://dev.mysql.com/doc/refman/5.7/en/dbug-package.html
The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. When you have configured MySQL for debugging, this package makes it possible to get a trace file of what the program is doing. This section ...
https://dev.mysql.com/doc/refman/5.7/en/explain.html
Obtaining Execution Plan Information The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. For SELECT statements, EXPLAIN produces additional ...In ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
To achieve this result, specify MATCH() twice: once in the SELECT list and once in the WHERE clause. By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-tuning-recovery.html
The following section explains how recovery works and how to tune the settings Donor Selection A random donor is selected from the existing online members in the group. This way there is a good chance that the same server is not selected more than ... Whenever a new member joins a replication group, it connects to a suitable donor and fetches the data that it has missed up until the point it is declared ...
https://dev.mysql.com/doc/refman/5.7/en/gtid-functions.html
The GTID sets used with this function are represented as strings, as shown in the following examples: mysql> SELECT GTID_SUBSET('3E11FA47-71CA-11E1-9E33-C80AA9429562:23', -> '3E11FA47-71CA-11E1-9E33-C80AA9429562:21-57')\G *************************** ... The functions described in this section are used with GTID-based ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
Although you can select INFORMATION_SCHEMA as the default database with a USE statement, you can only read the contents of tables, not perform INSERT, UPDATE, or DELETE operations on them. Using SELECT has these advantages, compared to SHOW: It ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html
VIEW_DEFINITION The SELECT statement that provides the definition of the view. Skip the words before SELECT and skip the words WITH CHECK OPTION. Suppose that the original statement was: CREATE VIEW v AS SELECT s2,s1 FROM t WHERE s1 > 5 ORDER BY s1 ...You must have the SHOW VIEW privilege to access this ...