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/group-replication-summary.html
The communication layer provides a set of guarantees such as atomic message and total order message delivery. If they receive it, then they all receive it in the same order with respect to other transactions that were sent before. All servers ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-float.html
Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. A floating-point value as written in an SQL statement may not be the same as the value represented internally. Attempts to treat ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
DISTINCT with ORDER BY does not work inside GROUP_CONCAT() if you do not use all and only those columns that are in the DISTINCT list. If and only if the preceding queries have no ORDER BY clause guaranteeing a deterministic order. SELECT with no ...
https://dev.mysql.com/doc/refman/8.0/en/parenthesized-query-expressions.html
parenthesized_query_expression: ( query_expression [order_by_clause] [limit_clause] ) [order_by_clause] [limit_clause] [into_clause] query_expression: query_block [set_op query_block [set_op query_block ...]] [order_by_clause] [limit_clause] ...
https://dev.mysql.com/doc/refman/8.0/en/sorting-rows.html
You may have noticed in the preceding examples that the result rows are displayed in no particular order. This means that the order is undefined for columns that are identical except for their case. You can force a case-sensitive sort for a column ...It is often easier to examine query output when the rows are sorted in some meaningful ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
Single-Table Syntax DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name [[AS] tbl_alias] [PARTITION (partition_name [, partition_name] ...)] [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] The DELETE statement deletes rows from tbl_name ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
It lists the tables in the output in the order that MySQL would read them while processing the statement. Note that this column is totally independent of the order of the tables as displayed in the output from EXPLAIN. That means that some of the ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
Used for storing text-based documents, with associated character set and collation order. descending index A type of index where index storage is optimized to process ORDER BY column DESC clauses. Unlike the binary log, which is used for ... These ...
https://dev.mysql.com/doc/refman/8.0/en/index-hints.html
index_hint: USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) index_list: index_name [, index_name] ... To influence index usage for sorting or grouping rows, use ... Index hints give the optimizer information about how to choose indexes during query ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
With ORDER BY, the server issues a first-key request followed by several next-key requests, whereas with ORDER BY DESC, the server issues a last-key request followed by several previous-key requests. Handler_read_next The number of requests to read ... The MySQL server maintains many status variables that provide information about its ...