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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
Order of REQUIRE options does not matter, but no option can be specified twice. ALTER USER 'jeffrey'@'localhost' REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/ O=MySQL demo client certificate/ CN=client/emailAddress=client@example.com'; MySQL does ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.0/en/bnl-bka-optimization.html
The rows are fetched by the MRR functions in an optimal way: They are fetched in the row ID (primary key) order. This improves performance because reads are in disk order rather than random order. In MySQL, a Batched Key Access (BKA) Join algorithm ...
https://dev.mysql.com/doc/refman/8.0/en/character-arrays.html
<collation> elements indicate character ordering for comparison and sorting, one element per collation. Binary collations need no <map> element because the character codes themselves provide the ordering. For example: lower['A'] should contain 'a' ... Each simple character set has a configuration file located in the sql/share/charsets ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collate.html
With the COLLATE clause, you can override whatever the default collation is for a comparison.
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode.html
The MySQL implementation of UCS-2, UTF-16, and UTF-32 stores characters in big-endian byte order and does not use a byte order mark (BOM) at the beginning of values. Other database systems might use little-endian byte order or a BOM. The Unicode ...
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
FULLTEXT queries that sort the matching rows in descending order of score and apply a LIMIT clause to take the top N matching rows. For this optimization to apply, there must be no WHERE clauses and only a single ORDER BY clause in descending order.