PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-effect.html
latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...The first ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
key_part A key_part specification can end with ASC or DESC to specify whether index values are stored in ascending or descending order. The pointer to the row is stored in high-byte-first order directly after the key, to improve compression. | ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-types.html
Although MySQL tries to interpret values in several formats, date parts must always be given in year-month-day order (for example, '98-09-04'), rather than in the month-day-year or day-month-year orders commonly used elsewhere (for example, ... The ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
That is, MySQL explains how it would process the statement, including information about how tables are joined and in which order. You can also use EXPLAIN to check whether the optimizer joins the tables in an optimal order. To give a hint to the ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
The ORDER BY and LIMIT clauses of the UPDATE and DELETE statements. You can specify ASC and DESC with GROUP BY, not just with ORDER BY. String comparisons are case-insensitive by default, with sort ordering determined by the collation of the current ... MySQL Server supports some extensions that you are not likely to find in other SQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-optimization.html
The most important preconditions for using indexes for GROUP BY are that all GROUP BY columns reference attributes from the same index, and that the index stores its keys in order (as is true, for example, for a BTREE index, but not for a HASH ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
This approach does not work for operators such as < or >, for example, when comparing character-based values, 9 > 1000, which is not expected from a clause such as ORDER BY population DESC. This technique lets you issue simple SELECT * queries from ... Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ASCII ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
Statement-based replication requires the consecutive auto-increment lock mode to ensure that auto-increment values are assigned in a predictable and repeatable order for a given sequence of SQL statements, whereas row-based replication is not ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-rules.html
Syntax Rules LDML has reset rules and shift rules to specify character ordering. Orderings are given as a set of rules that begin with a reset rule that establishes an anchor point, followed by shift rules that indicate how characters sort relative ...This is a subset of the syntax described in the LDML specification available at http://www.unicode.org/reports/tr35/, which should be consulted for further ...
https://dev.mysql.com/doc/refman/8.0/en/load-xml.html
The user variables need not be listed or assigned in the same order as the corresponding fields. The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >). LOAD ...