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/case-sensitivity.html
This means that if you search with col_name LIKE 'a%', you get all column values that start with A or a. For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-coercibility.html
For example, in the following cases, it should be clear that the collation is the collation of column x: SELECT x FROM T ORDER BY x; SELECT x FROM T WHERE x = x; SELECT DISTINCT x FROM T; However, with multiple operands, there can be ambiguity. For ... In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison ...
https://dev.mysql.com/doc/refman/5.7/en/charset-table.html
The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name]] ALTER TABLE tbl_name ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf16.html
For example, since U+F8FF is the Apple Logo, this is legal: INSERT INTO t (utf16_column)VALUES (0xf8ff); /* legal */ Such characters cannot be expected to mean the same thing to everyone. Because MySQL must allow for the worst case (that one ... The ...
https://dev.mysql.com/doc/refman/5.7/en/distinct-optimization.html
Because DISTINCT may use GROUP BY, learn how MySQL works with columns in ORDER BY or HAVING clauses that are not part of the selected columns. If you do not use columns from all tables named in a query, MySQL stops scanning any unused tables as soon ... DISTINCT combined with ORDER BY needs a temporary table in many ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
The Message value in SHOW WARNINGS output displays how the optimizer qualifies table and column names in the SELECT statement, what the SELECT looks like after the application of rewriting and optimization rules, and possibly other notes about the ... For SELECT statements, the EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
False hits or misses might occur for stopword lookups if the stopword file or columns used for full-text indexing or searches have a character set or collation different from character_set_server or collation_server. The stopword table must have a ... The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-replication-group-members.html
The MEMBER_STATE column shows one of the Section 17.4.1, “Group Replication Server States”, in this case it shows that all three members in this group are ONLINE, and the MEMBER_ROLE column shows that there are two secondaries, and a single ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-mapping.html
There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each database as a directory in the data directory, and each table by one or more files in the appropriate ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-collation-character-set-applicability-table.html
Notes The COLLATION_CHARACTER_SET_APPLICABILITY columns are equivalent to the first two columns displayed by the SHOW COLLATION statement. The COLLATION_CHARACTER_SET_APPLICABILITY table indicates what character set is applicable for what collation. CHARACTER_SET_NAME The name of the character set with which the collation is ...