PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/8.0/en/locking-functions.html
If multiple clients are waiting for a lock, the order in which they acquire it is undefined. Applications should not assume that clients acquire the lock in the same order that they issued the lock requests. Also, if it is important that locks are ...While held by one session, other sessions cannot obtain a lock of the same ...
https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html
You cannot merge MyISAM tables in which the columns are listed in a different order, do not have exactly the same data types in corresponding columns, or have the indexes in different order. The column order in the underlying table and the MERGE ...
https://dev.mysql.com/doc/refman/8.0/en/merge-table-problems.html
The checks ensure that the definitions of the tables and the parent MERGE table definition match by comparing column order, types, sizes and associated indexes. Because these checks take place when the tables are opened, any changes to the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-innodb-mutex-waits-performance-schema.html
Data is presented in descending order, by the number of summarized wait events (COUNT_STAR). You can adjust the ORDER BY clause to order the data by total wait time. A mutex is a synchronization mechanism used in the code to enforce that only one ...