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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/using-explain.html
That is, MySQL explains how it would process the statement, including information about how tables are joined and in which order. You can also use EXPLAIN to check whether the optimizer joins the tables in an optimal order. To give a hint to the ...
https://dev.mysql.com/doc/refman/8.0/en/values.html
VALUES row_constructor_list [ORDER BY column_designator] [LIMIT number] row_constructor_list: ROW(value_list)[, ROW(value_list)][, ...] value_list: value[, value][, ...] column_designator: column_index The VALUES statement consists of the VALUES ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
lock_order_debug_loop: Whether to cause debug assert when LOCK_ORDER tool encounters dependency flagged as loop. lock_order_debug_missing_arc: Whether to cause debug assert when LOCK_ORDER tool encounters undeclared dependency. Options and ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation.html
Add configuration information that names the collation and describes the character-ordering rules. Note If you modify an existing user-defined collation, that may affect the ordering of rows for indexes on columns that use the collation. Warning ...