Search Results
https://dev.mysql.com/doc/refman/8.4/en/gis-format-conversion-functions.html
MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB format, or for swapping the order of X and Y coordinates. If any geometry argument is in an undefined spatial reference ...There are also functions to convert a string from WKT or WKB format to internal geometry ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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.4/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] ... Note MySQL 8.4 supports the index-level optimizer hints ...
https://dev.mysql.com/doc/refman/8.4/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] ...The ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
This section lists all NDB errors, ordered by NDB error code. Hash index attributes must be specified in same order as table attributes 4256 MySQL error. range_no not strictly increasing in ordered multi-range index scan 4283 MySQL error. Not all ...Each listing also includes the error's NDB error type, the corresponding MySQL Server error, and the text of the error ...