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/mysql-cluster-replication-conflict-resolution.html
The epoch-based conflict resolution functions NDB$EPOCH() and NDB$EPOCH_TRANS() compare the order in which epochs are replicated (and thus these functions are transactional). The NDB$EPOCH() and NDB$EPOCH_TRANS() functions discussed later in this ...
https://dev.mysql.com/doc/refman/8.0/en/update.html
Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET assignment_list [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] value: {expr | DEFAULT} assignment: col_name = value assignment_list: assignment [, assignment] ... If ... UPDATE is a DML statement that modifies rows in a ...
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending order. Previously, indexes could be scanned in reverse order but at a performance penalty. A descending index can be ...For InnoDB full-text search, this means that the index required on the FTS_DOC_ID column of the indexed table cannot be defined as a descending ...
https://dev.mysql.com/doc/refman/8.0/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.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/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/history.html
We started out with the intention of using the mSQL database system to connect to our tables using our own fast low-level (ISAM) routines. However, after some testing, we came to the conclusion that mSQL was not fast enough or flexible enough for ...
https://dev.mysql.com/doc/refman/8.0/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric ...