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/partitioning-selection.html
Partitions and subpartitions named in partition_names may be listed in any order, and may overlap. You can use WHERE conditions, ORDER BY and LIMIT options, and so on. Explicit selection of partitions and subpartitions for rows matching a given ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
The range condition extraction algorithm can handle nested AND/OR constructs of arbitrary depth, and its output does not depend on the order in which conditions appear in WHERE clause. Key tuple intervals are defined over a set of key tuples, using ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
Specifying both causes the replica to treat the value as signed if possible, otherwise to treat it as unsigned; the order in which they are listed is not significant. Source and target tables for replication do not have to be identical. A table on ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transaction-inconsistencies.html
A gap in the externalized transaction set appears when, given an ordered sequence of transactions, a transaction that is later in the sequence is applied before some other transaction that is prior in the sequence. To avoid gaps occurring on a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
This is unsafe because the order in which the rows are updated may differ on the source and the replica. When executed against a table that contains more than one primary or unique key, this statement is considered unsafe, being sensitive to the ...
https://dev.mysql.com/doc/refman/8.0/en/select-into.html
An example of such a statement is shown here: TABLE employees ORDER BY lname DESC LIMIT 1 INTO @id, @fname, @lname, @hired, @separated, @job_code, @store_id; You can also select values from a VALUES statement that generates a single row into a set ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/set.html
MySQL stores SET values numerically, with the low-order bit of the stored value corresponding to the first set member. For a value containing more than one SET element, it does not matter what order the elements are listed in when you insert the ...
https://dev.mysql.com/doc/refman/8.0/en/start-replica.html
Transactions in a GTID set do not necessarily appear in the replication stream in the order of their GTIDs, so the transaction before which the applier stops is not necessarily the earliest. Transactions are processed in the order received, so it is ... START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
Bits in bits are examined from right to left (from low-order to high-order bits). This is the same as the two-argument form of LOCATE(), except that the order of the arguments is reversed. REVERSE(str) Returns the string str with the order of the ...
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html
Command Syntax Meaning default Reset every optimization to its default value opt_name=default Set the named optimization to its default value opt_name=off Disable the named optimization opt_name=on Enable the named optimization The order of the ...